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
| Mode | Meaning |
|---|---|
newline (default) | One row per line |
delimiter | Rows separated by a custom marker (1–8 characters) |
fixed-length | Every row has the same byte length |
Encodings you can pick (text files only)
utf-8(default)utf-16le,utf-16begb18030(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
| Starter | Business | Enterprise | |
|---|---|---|---|
| Rows per file | 10,000 | 500,000 | 6,000,000 |