CSV import and export
Move data in and out of Kabaido with CSV, and know what the parser accepts before you upload.
Updated 23 September 2026
On this page
- Why
- Every business has spreadsheets, and CSV is the integration that needs no integration.
- How
- Choose Import CSV in
/app/catalogor/app/customers, and Export above any list.
What the parser accepts
- Comma, semicolon, tab and pipe delimiters, sniffed from the header line, so a semicolon file needs no setting.
- Double quoted fields, with a doubled quote for a literal one. Delimiters and line breaks inside quotes are safe.
- CRLF and LF line endings alike.
- XLSX workbooks, converted to CSV in your browser; the first sheet is used.
Save your own files as UTF-8. The wizard's blank template carries a byte order mark so Excel opens it as UTF-8.
Importing products
- Step 1.
In
/app/catalog, choose Import CSV, upload the file and pick the schema. Importing needs the admin role. - Step 2.
Map each column to a core field or a schema attribute. SKU and title must be mapped; unmapped columns are ignored.
- Step 3.
Validate: the first 500 rows are checked and the problems are listed by row and column.
- Step 4.
Choose to update or skip SKUs that already exist, then run.
| Validation reports | Meaning |
|---|---|
| Error | The cell will not convert to the field's type. The row still imports with that cell empty. |
| Note | The cell holds no figure (POA, N/A). Not an error and never a zero. |
| Warning | The price mapping looks wrong: no column mapped to Price, or a money column left unmapped. |
| Unit hint | A value looks like a different unit from the field's. |
The run works in batches of 1,000 rows and records its place after each, so an interrupted import resumes where it stopped and no row is written twice. An error report CSV lists the cells that had something to say. A mapping can be saved and reused for the next file.
Importing customers
In /app/customers, Import CSV takes company, contact, email, phone and terms columns in any order, mapped by heading. Download a sample CSV shows the shape. A preview counts new rows and possible duplicates (by email domain and company name) and offers to skip them.
Exporting
See Export your data.
Related
- Importing productsLoad a CSV or XLSX into your catalogue with the columns mapped for you, a checked sample and a run that resumes if it stops.
- Export your dataGet the records you put into Kabaido back out, and know which route gives you which.
- CustomersKeep one record per customer with its contacts, terms, special prices, context for the AI and, with Commerce, its sign in.