Skip to content

Exporting your records

Exporting works the same across every module: any object’s index page offers Export all and Export selection. What changes between them is how much they download and how many decisions they ask for first.

Under More actions, Export all downloads every record in the object, not the ones the table is showing at that moment.

More actions menu with the Export all option highlighted

This is worth stressing because the menu itself says otherwise (“Downloads what the table shows”), and that description only holds for Export selection:

  • Filters and search do not narrow the export. Even if the table shows a single contact, the file arrives with every record in the object.
  • Visible columns don’t narrow anything either. The file carries every field on the record, including your account’s custom fields, no matter how many columns you have in view.

Ticking rows is the way to narrow the download: tick the checkboxes you need and use Export selection. The selection survives changing pages, so you can gather records from several pages into one file.

Every export asks for two decisions: the content type and the file format.

Export all submenu with Report/Data and, inside Report, Excel/JSON

  • Report — uses the records’ visible names in their references. Pick it when you need a file a person will read.
  • Data — keeps references as IDs instead of names. Pick it when you need to prepare a re-import or feed the information into another system.

Once you’ve picked the content type, you pick the format:

  • Excel — downloads an .xlsx spreadsheet.
  • JSON — downloads structured .json data.

All four combinations are available for both Report and Data, but only from Export all: Export selection goes straight to Excel or JSON, skipping the Report or Data step.

If what you need is a file narrowed by conditions rather than row by row, use Custom reports, which do filter what they include.

Frequently asked questions

Was this article helpful?