Exporting your list

Downloading your list as a file (CSV, Excel, JSON and the other file formats) works on every plan and costs no credits.

Where to export from#

Open a list and click the Export & Sync arrow button in the list header (not on phones) to open the export wizard directly, or use the ⋯ icon at the far right of the header (not the More menu) for more options. In ⌘K, search for Export Wizard, Export All (Excel) or Export Visible Rows.

The ⋯ icon's menu includes:

• Export Data — opens the export wizard, where you pick a destination, choose columns and (for file downloads) a format.
• Export as Excel — a one-click shortcut that downloads exactly what the grid currently shows as an .xlsx file, no wizard.
• Export Selected Records — appears when you have rows selected; exports only those rows through the wizard.
• Export Visible Records — appears when a search, sublist (segment) or the Changes filter is active; exports only the rows currently shown (renamed Export Sublist "Name" when a sublist is the active filter).

The export wizard#

The wizard has two steps: pick a destination, then pick columns. On the column step you check or uncheck any column, search by name, drag to reorder, and rename a column just for this export (the list itself is unchanged). For a file download you also edit the file name before downloading.

Destinations include instant file downloads — Excel, CSV, JSON, and more under "More formats" — plus app destinations. See "Sending contacts to Lemlist, Instantly and Smartlead" for sequencers, "Exporting to HubSpot and Google Sheets" for those two, and "Zapier, Make and n8n via webhook" for sending to any other tool through a webhook URL. "Export file formats: CSV, Excel, JSON, SQL and Markdown" covers the file options (CSV, Excel, JSON, SQL, Markdown) in detail.

Which rows and columns are included#

Export Data (and the header Export button and Export Wizard) exports every row saved in the list, including rows marked ignored, whatever is filtered on screen. Export as Excel in the ⋯ menu downloads exactly what the grid shows right now: the current filter, search or sublist, the visible columns, and ignored rows only when Show Ignored Rows is on. Export All (Excel) in ⌘K downloads every row, including ignored ones. Export Selected Records and Export Visible Records limit the wizard to the rows selected or shown. In the wizard, columns default to every column in the list except internal system columns, and you can uncheck any of them on the column step.

Exporting only includes what's actually saved in the list's cells. If you looked up data with Enrich but it isn't in the cells (lookups fill empty cells by themselves; only an AI Analysis from the Enrich menu waits for the "Fill empty cells?" prompt), that data is not in the export — fill it in first, then export. Two destinations are the exception: the webhook destination has an optional Include enrichment data setting (see "Zapier, Make and n8n via webhook"), and Lemlist, Instantly and Smartlead fill empty standard fields (name, company, phone, website, LinkedIn) from enrichment results automatically (see "Sending contacts to Lemlist, Instantly and Smartlead").

The export wizard reads the list as it's saved. Your own edits are saved automatically within a second; open AI suggestions are only included after you click Apply in the list header. The one-click Excel shortcuts download the grid as you see it.

Related topics: export-files · send-to-sequencers · export-to-hubspot-and-sheets · zapier-make-n8n.

FAQ#

How do I export my list?#

Click the Export button in the list header to open the export wizard directly, or use the ⋯ icon at the far right of the header for more options such as Export as Excel or Export Selected/Visible Records. You can also press ⌘K and search for Export Wizard, Export All (Excel) or Export Visible Rows.

Does exporting cost credits?#

No. Downloading a list as a file costs no credits on every plan, including Basic. Sending to apps like HubSpot or Google Sheets needs Pro or Premium and costs credits per request; see that destination's topic.

Can I choose which columns get exported?#

Yes. The export wizard's column step lists every column with a checkbox, a search box, drag-to-reorder, and you can rename a column just for that export without changing the list itself.

Can I export just the rows I've selected?#

Yes. Select the rows in the grid, then choose Export Selected Records from the ⋯ menu — only those rows go into the export.

Can I export a filtered view or a sublist (segment)?#

Yes. With a search, sublist or the Changes filter active, the ⋯ menu shows Export Visible Records (or Export Sublist "Name" when a sublist is the active filter) instead of the full-list option, and only those rows are exported.

Does exporting the whole list include ignored rows?#

Export Data and Export All (Excel) include rows marked ignored. Export as Excel in the ⋯ menu leaves them out unless Show Ignored Rows is on. To send ignored-free data through the wizard, open a sublist or search first and use Export Visible Records.

Will data I looked up with Enrich but haven't filled in yet be exported?#

No — export only includes what's actually saved in the list's cells, so data Enrich found but that is not in a cell (a value for a cell that was already filled, or an AI Analysis you haven't accepted via the "Fill empty cells?" prompt) is excluded until you fill it in and export. Exceptions: the webhook destination has an optional Include enrichment data setting, and Lemlist, Instantly and Smartlead fill empty standard fields from enrichment results automatically (see "Zapier, Make and n8n via webhook" and "Sending contacts to Lemlist, Instantly and Smartlead").

Do I need to save before exporting?#

No — your own edits are saved automatically about a second after you make them, and the export wizard reads the saved list. Open AI suggestions are only included after you click Apply in the list header; the one-click Excel shortcuts download the grid as you see it.

What file formats can I download?#

CSV, Excel, JSON, SQL and Markdown, plus a one-click Excel shortcut outside the wizard. See "Export file formats: CSV, Excel, JSON, SQL and Markdown" for details on each.

Can I export straight to my CRM or a sequencer instead of downloading a file?#

Yes — the export wizard also offers app destinations: Google Sheets, HubSpot, Lemlist, Instantly, Smartlead, and a generic webhook for tools like Zapier, Make or n8n. See the linked topics for each one's requirements.