Reference
CSV import fails
Validate the file format, encoding, headers, preview, and type inference when importing into the Table kit.
Updated
By Kition Docs
Verified against Kition 0.2.0 (7d49036f) on 2026-11-06
Confirm the supported path
- The Table kit imports CSV, TSV, and XLSX files, either as a new table (Import a file as a new table, in the table tab bar) or into the table you have open
- Legacy
.xlsis rejected; save it as XLSX, CSV, or TSV first - An XLSX import brings in one sheet at a time, values only; formatting and formulas are not imported
- A
.csvfile in the workspace opens in the Sheet kit; to turn it into table records, import it in the Table kit
Repair the source file
The importer detects comma, tab, or semicolon delimiters. Blank headers become Column 1, Column 2, and so on, and repeated headers get a number added. An empty file produces an Import warnings entry instead of fields.
- Save CSV and TSV files as UTF-8; other encodings fail with “CSV and TSV imports must use UTF-8 encoding”
- Include a header row and at least one data row
- Keep delimiters consistent and quote values that contain delimiters or newlines
- Normalize mixed dates and inspect identifiers with leading zeros or large numeric values
Review the preview and field types
Check the format, rows, fields, sheet, warnings, and sample values before importing. Change an inferred Field type when the preview would turn an identifier into a number or interpret a mixed column incorrectly.
A column becomes a Checkbox only when its values are true/false or yes/no.
Recover safely
Keep the source file, import into a test table first, and compare row and field counts. When importing into the table you have open, Write mode offers Append to current table or Replace current table; choose Append unless you mean to replace the existing records.
Related pages
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.
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.
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.