All topics
Get started8Account, team & permissions44Units & fields70Records, views & tasks39WhatsApp & Cortex Chat68Email & social27Lead ads & distribution38Automations52Documents & quotes32Dashboards40Cortex AI18Developers & API12
Help Center·448 guidesAll topicsContact support

Export a unit’s records to CSV or Excel

Export all the records you can see in a unit to CSV or XLSX, and choose the columns. Large files are prepared in the background, and you get a notification.

4 min
Before you start · for everyone
The view permission on the unit
  • You need: The view permission on the unit

Steps

1
Open the unit and choose Export.
2
Choose the format: CSV or XLSX.
3
Keep Export all fields on, or turn it off and choose the columns.
4
Press Export.
Up to 50,000 records, the file downloads straight away. Above that, it’s prepared in the background and you get an alert when it’s ready.
5
Download the file within 60 minutes of it being ready.

What the file includes

The fields in their order, with an extra Hijri column for fields that use the Hijri calendar, then the assignee, then single relations as record names, then the created and updated dates. Lookup fields are included; multiple relations aren’t.

What the export covers

The export includes every record within your permissions in the unit, and doesn’t apply the filters of the open view. Someone who can’t see every record exports only their own records.

The file format

A CSV file downloads compressed, as .csv.gz. Unzip it, then open it in Excel. Arabic shows correctly, and dates show as the day you entered.

To export with a specific filter, ask the assistant.

If something goes wrong

What you see
Why
What to do
“No data to export”
No records in the unit are within your permissions.
“The file isn’t ready yet”
The export is still running.
Wait for the alert.
“The export file has expired”
60 minutes have passed.
Export again.
The file has a strange extension
It’s a compressed CSV file.
Unzip it first, or choose XLSX.
The file doesn’t match the view’s filter
Exports don’t apply view filters.

A real example

Shield Security Co.
The situation

The accountant needs the list of contracts every month.

What they did
  1. The manager exports the contracts unit as XLSX, with only the client, value and end date columns.
The result

A file is ready for the accountant in a minute.

A made-up company, to show the idea. The numbers are rounded.

Good to know

Up to 50,000 records download straight away; more are prepared in the background.
The file is available for 60 minutes, then deleted.
Only the person who started the export can download the file.
Did this guide solve it?
If not, we’ll ask what was missing.
Open in Corteksa
Did this guide solve it?

We read every answer. To get a reply, use Contact support.