Use import templates
Templates give you the exact columns each import type expects, so your file imports cleanly the first time.
Fill in a template
- On Upload, pick the import type, then download the Excel template or CSV template.
- In the Excel template, header colours show required (red), match key (amber) and optional (slate) columns. Hover a header for a description, format and allowed values.
- Use the dropdowns for columns with fixed lists or your own reference data, such as product group, warehouse, unit, tax group, supplier and department. They warn rather than block, so you can type a value you are about to create.
- Read the Field Guide sheet for each column's meaning, format and the alternative headings that match it automatically.
- Delete the sample rows and add your data. The samples are made-up US examples that show the format only.
Format rules
- Dates as
YYYY-MM-DD(Excel date cells are fine). - Numbers with a dot as the decimal separator and no currency symbol.
- Yes/no as
true/false,yes/noor1/0. - Quantity, price, credit limit and day-count columns reject negatives.
The CSV template starts with a UTF-8 byte-order mark so Excel opens accented text correctly. The import accepts files with or without it.
:::info You do not have to use the template Columns are matched by name and known alternative spellings, and anything unmatched you can map by hand or skip. :::
Learn more about Biznsbook Data Import on biznsbook.com.