Appearance
Imports and exports
Also known as
- import
- export
- CSV
- Excel
- XLSX
- data migration
- bulk upload
- mass upload
- template
- opening balances
Use imports to load data in bulk (at go-live, or when you add many items, customers or employees at once) and exports to take data out to Excel, an auditor, your bank or a data warehouse. This page lists every way in and out, from the CSV import wizard in Settings to the export buttons on lists, reports and documents.
Import data from a CSV file
The import checks every row before anything is saved: you see the problems first and confirm only the good rows.
- Open SettingsImport and export.
- In Import, under What are you importing?, pick the data.
- Select Download template. The template has the columns in the right order, listed under Columns, in this order:.
- Fill the template in Excel or any spreadsheet tool, one record per row, and save it as CSV (UTF-8).
- Select Next, then drop the file on the Upload file step or select it.
- On the Check step, read the preview. Rows with problems are marked; the banner says how many (for example "3 rows have errors and will be skipped.") and All problems lists each one with its row number.
- Fix the file and select Upload another file, or select Import n rows to import the good rows.
The Import step shows "n … imported." and the import is added to Recent imports with the number imported and skipped and who ran it. You also get an Import finished notification.
| Field or column | What to enter |
|---|---|
Codes (code, item_code, vendor_code, warehouse_code …) | The code of an existing record. Import the master data before the data that refers to it. |
| Dates | yyyy-MM-dd, for example 2026-10-31. |
| Amounts and quantities | Plain numbers with a full stop as the decimal separator, no thousands separator: 1234.50. |
Yes/no columns (active, is_default …) | true or false (yes/no, y/n and 1/0 work too). |
| Several values in one cell | Serial numbers separated by | (SN-001|SN-002); user roles as role keys separated by commas (finance,sales). |
What you can import
| Module | Data you can import |
|---|---|
| Platform | Users (users), items (items), item categories (categories), units of measure (uoms) |
| Finance | Chart of accounts, customers, vendors, exchange rates |
| Inventory | Warehouses, locations, item inventory settings (reorder point, min, max, safety stock), opening stock |
| Procurement | Vendor items and prices, vendor contracts |
| Sales & CRM | Leads, price lists |
| Manufacturing | Work centres, routings, bills of materials |
| People | Employees, org units, holidays |
| Projects | Projects, tasks (WBS) |
| Service | Knowledge base articles, warranties |
| Assets | Assets, meters, meter readings |
| Quality | Inspection plans, measuring instruments |
| Supply chain | Carriers, freight rates, HS codes, demand history |
| Planning | Plan lines, drivers |
| Compliance | Risks |
You see only the data of enabled modules that you may change.
Load data in this order at go-live
- Units of measure, categories, items. 2. Chart of accounts, exchange rates, customers, vendors.
- Warehouses and locations, then item inventory settings. 4. Opening stock (quantity and unit cost per item, warehouse and location; lots, expiry dates and serial numbers when the item is tracked). 5. Employees, then users.
Opening balances of the general ledger are not a CSV import: post them as one journal entry dated the day before go-live.
Export a whole table to CSV
- Open SettingsImport and export.
- In Export, pick the Data.
- Select Download CSV.
The file has every record of that kind, in the same columns as the import template, so you can edit it and import it back.
Other ways to export
| What | Where | Format |
|---|---|---|
| The rows of a list | Export CSV (download icon) in any list's filter bar. See Lists. | CSV |
| A report | Export on the report page. See Reports catalogue. | CSV, Excel workbook, PDF |
| An ad-hoc query | Export CSV in the report builder | CSV |
| Large or regular extracts for a data warehouse | AnalyticsData export | CSV or JSON Lines |
| A document (purchase order, quote, sales order, shipment, receipt, inspection, NCR, payslip …) | Download PDF, Print or PDF on the document | |
| Supplier payments | Download bank file on a payment run | Bank file |
| Salaries | Download bank file on a pay run | Bank file |
| Barcode labels | Barcode labels → Print labels |
Export a dataset for a data warehouse
- Open AnalyticsData export.
- Pick the Dataset and the Format: CSV (header = column keys) or JSON Lines.
- Optionally pick Columns (empty: every column) and Changed since to take only rows changed at or after a time.
- Select Download, or copy the request shown next to it for an integration that uses an API key.
Other imports
| What | Where |
|---|---|
| Bank statements (CSV or OFX-style CSV from your bank, up to 10 MB) | FinanceBank statementsImport bank statement: steps File, Columns (map date, description, amount or debit and credit; Save this mapping for the bank account) and Preview (lines imported before are skipped). See Statement import. |
| Attachments (scans, PDFs, photos) | The Attachments panel of a record. See Attachments. |
Permissions
| What | Permission |
|---|---|
| See the import templates and recent imports | Permission: settings.integrations.view |
| Import and export from Settings | Permission: settings.integrations.manage, plus the permission to change the data you import (for example Permission: finance.customer.manage for customers) |
| Data export | Permission: analytics.export.use |
| Bank statement import | Permission: finance.bank_statement.import |
Account administrators can do all of these. SettingsImport and export is shown in the Settings menu to account administrators.
Limits and gotchas
- One file imports one kind of data. The file must be UTF-8 CSV with a heading row; save from Excel as CSV UTF-8 (Comma delimited).
- Nothing is saved until you select Import n rows. Rows with errors are skipped, never half-imported.
- Imports create and update master data and opening figures. Transactions (orders, invoices, bills) are not imported: enter open documents on the screens, or post opening balances.
- A list's Export CSV takes the rows of the current page as you see them (columns, filters, sort). To export everything, use the Settings export or a report.
- Exported amounts are plain numbers and dates are
yyyy-MM-dd, whatever your display formats.
