Skip to content

File formats & encodings

Both imports accept CSV, XLSX, and fixed-width TXT. The format settings live in your import template and are frozen into each upload.

CSV

  • Header row optional (a switch in the template).
  • Pick the encoding from the list below if it's not UTF-8.

XLSX

  • The first sheet is read.
  • No encoding setting needed — the format handles it.

Fixed-width TXT

  • Needs a template with column widths filled in — without one, these files can't be uploaded at all.
  • How columns are cut: each column is trimmed; short lines are padded; the last column takes whatever is left.

How records are separated

ModeMeaning
newline (default)One row per line
delimiterRows separated by a custom marker (1–8 characters)
fixed-lengthEvery row has the same byte length

Encodings you can pick (text files only)

  • utf-8 (default)
  • utf-16le, utf-16be
  • gb18030 (Simplified Chinese)
  • big5 (Traditional Chinese)
  • shift-jis (Japanese)
  • euc-kr (Korean)

If your file comes from an older ERP and shows garbled text in the preview, pick the matching encoding in the template and preview again.

Plan limits

StarterBusinessEnterprise
Rows per file10,000500,0006,000,000

QuantalCount Help Center