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 .xls is 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 .csv file 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

Ready when you are.

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