Export records to CSV
Download a record type as a CSV file: columns, value formats and the 10,000-row limit.
Download the records of a type as a CSV file you can open in Excel, Google Sheets or Numbers. The file holds exactly what the list shows: the same filters and the same sort.
Before you start: You need Can add & edit (or higher) on Business records, which includes exporting. You can only export records and fields you are allowed to read.
Steps
- Open the record type's list.
- Optional: add filters, pick a saved view or sort by a column. For example, filter Invoices to
Status = overdueto export only the overdue ones. See Find records. - Click More › Export.
Your browser saves a file named after the record type, for example customers.csv. If it fails you see Export failed.
What is in the file
- One header row, then one row per record in the list, in the list's order. With no filters, every record of the type is included.
- The first two columns are
idandcreated_at(a timestamp). After them come all the type's fields in order, with the field key as the column heading. - Records you cannot read are left out. Fields your role hides are blank.
- Computed and auto-numbered fields are included.
How values are written
| Field type | In the file |
|---|---|
bool |
true or false |
currency |
amount code, for example 1250.5 INR |
multiselect, refs |
A list in square brackets, for example ["red","blue"] |
ref |
The linked record's ID (a UUID) |
date |
YYYY-MM-DD |
datetime |
An RFC 3339 time in UTC |
| Everything else | The plain value |
Cells that start with =, +, - or @ get a ' in front so that spreadsheet programs do not run them as formulas. Plain numbers and phone numbers such as +91 98641 83399 are left alone. Import removes the ' again.
Limits
- Up to 10,000 records per export. A bigger list is cut off at 10,000 and the app shows "Only the first 10,000 records were exported. Filter the list to export the rest." (or, for a filtered list, "Only the first 10,000 matching records were exported. Narrow the filter to export the rest."). Export in parts, for example one month at a time with a date filter.
- The file always has every field you can read, whatever columns the list shows.
- Edit in Sheets is different: it always takes the whole type, not the filtered list.
Troubleshooting
Export failed You may lack the export permission, or the type could not be read. Ask a workspace owner to check your role: Business records at Can add & edit or higher.
Dates look wrong in Excel Timestamps are in UTC. Convert the time zone in your spreadsheet if needed.