Export, import & bulk actions: how it works
From any list you can download the rows as a spreadsheet, load many records at once from a CSV file, and apply one action to many selected rows. Use it to hand data to your accountant, to bring in customers or products from another system, or to tidy up in one go.
Lesson 5 of 15 · How it works
How it works
Press «Export Export downloads a list as a file: CSV or XLSX for Excel, or JSON for other software. Import loads records from a file into a list. More words in the glossary» on a list and choose «CSV (Excel / Sheets)», «XLSX (Excel)» or JSON. The file holds the current view: the same search, filters and sorting you see on screen.
Tick rows first to export only those; the menu then says how many are selected, and the bar above the list has «Export selected».
Lists that accept imports show «Import from CSV…» in the same menu: customers, products, expenses, suppliers, employees, newsletter subscribers, redirects and autopilot topics.
In the import window press «Download template» to get a file with the right columns and one example row. Fill it in, then «Choose CSV file».
The system matches your columns to its fields by name; correct any of them under «Map columns», check the preview of the first rows, then start the import. Required columns must be mapped.
The result says how many records were new, how many were updated and how many were skipped, with the row number and the reason for the skipped ones.
For Bulk actions Ticking several rows in a list and doing one thing to all of them, such as changing the status or exporting them. More words in the glossary, tick rows and use the bar above the list. Which actions appear depends on the list and on your role, for example «Delete», «Publish», «Set status» or «Approve».
Where to find it
- Customers → Customers
/admin/customers - Catalog & stock → Products
/admin/products - Money → Expenses
/admin/expenses
Settings that change it
- People → Roles & permissions
/admin/roles
Checklist
Before you move on, check that you can:
- Open Customers → Customers
- Press Export on a list and choose CSV (Excel / Sheets), XLSX (Excel) or JSON.
- Tick rows first to export only those; the menu then says how many are selected, and the bar above the list…
- Lists that accept imports show Import from CSV… in the same menu: customers, products, expenses, suppliers,…
- In the import window press Download template to get a file with the right columns and one example row.
Tips and common mistakes
- Import reads CSV files only. Save an Excel sheet as CSV first, and keep one header row at the top.
- One import takes up to 5,000 rows and one export up to 20,000 rows. Split bigger files, or narrow the list with filters before exporting.
- Every export and import is written to the activity log with the person and the number of rows.
- A bulk action is missing from the bar? Your role does not have the permission for it on that list.