Data tables

Import spreadsheet data

Preview CSV, TSV, or XLSX data, review the inferred field types, and import it as a new table in your `.ktable` file.

Updated

By Kition Docs

Verified against Kition 0.2.0 (7d49036f) on 2026-11-06

Supported entry points and formats

  • Tab bar → Import a file as a new table — adds a table to the open .ktable file from a CSV, TSV, or XLSX file
  • .csv and .tsv — must be UTF-8
  • .xlsx — one sheet per import, cell values only; formatting and formulas are not brought over
  • Legacy .xls — not supported; save it as XLSX, CSV, or TSV first

Review the preview

The Import spreadsheet dialog shows the detected format, row count, field count, sample values, and warnings. For a workbook with several visible sheets, choose the Sheet to import. Name the new table in New table name.

Review each inferred field and change its type when needed. The type choices are Text, Long text, Number, Date, Date and time, Single select, Multi select, Checkbox, and URL.

Importing into an existing table

The tab bar import always creates a new table. To add rows to a table that already exists, or to replace its records, ask your AI agent: it can preview the file and import it into an existing table in append or replace mode.

How CSV and TSV are read

The importer detects comma, tab, or semicolon delimiters, preserves quoted commas, escaped quotes, and quoted newlines, and ignores a leading byte-order mark.

Inference is a starting point

The analyzer can infer checkbox, number, datetime, date, URL, long-text, and single-select fields; otherwise it uses text. Its Boolean tokens are true/false and yes/no.

Use a header row, save as UTF-8, normalize mixed date formats, and inspect columns with identifiers, leading zeros, large numbers, or sparse categorical values before importing.

Completion and recovery

When the import finishes, the editor reports how many records and fields were imported and shows the new table.

For important data, keep the source file, import into a test file first, and verify record and field counts before deleting the original.

Related pages

Ready when you are.

Kition is a desktop AI workspace for connected documents, structured tables, editable designs, whiteboards, visual workflows, and reviewable AI agents.