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
.ktablefile from a CSV, TSV, or XLSX file .csvand.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
Create a table
Create a `.ktable` file from the workspace Create menu, add more tables from templates inside it, then customize fields, records, and views.
Export a table to CSV or Markdown
Use the Export menu in the tab bar to write the table you are looking at as a new CSV or Markdown file next to the `.ktable` file.
Field types overview
Choose from the 23 field types the Table editor offers, know which ones do not fill in values, and configure AI on supported fields.