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-lengthRecords are cut after decoding at a character length equal to the sum of the configured column widths, not at a 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.

Row limits ​

Product catalogue imports

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

Baseline imports: up to 100,000 data rows per file.

QuantalCount Help Centre