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

  1. Open the record type's list.
  2. Optional: add filters, pick a saved view or sort by a column. For example, filter Invoices to Status = overdue to export only the overdue ones. See Find records.
  3. 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 id and created_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.