Skip to main content

CSV export

Export a list of records as a CSV file, from the app or the API.

Written by Michael Simmons

Export any list of people, companies, deals, or custom objects as a CSV file for use in spreadsheets, external tools, or data pipelines.


Export a list

  1. Open any People, Companies, Deals, or List view in Clarify

  2. Click the menu in the top right of the view

  3. Click Export CSV

The file downloads immediately, named after the current view (e.g., All People.csv, My Pipeline.csv).

Columns exported match the columns visible in the current view. Adjust the view before exporting to include or exclude specific fields.


What can be exported

  • People ✅

  • Companies ✅

  • Deals ✅

  • Custom Objects ✅

  • Any saved List view ✅

  • Lead Finder results ❌ - see below

ℹ️ Lead Finder results can't be exported directly. Add them to a list first (Lead FinderAdd to), then export the list.


Limits and availability

CSV export is available on all plans. There is no row limit - the export includes every row in the current view. Large lists may take a moment to generate.


API access

CSV export is also available through the Clarify API. It runs the same export as the button in the app.

POST https://api.clarify.ai/v1/workspaces/{slug}/objects/{object}/lists/{listId}/rows/csv

⚠️ A request body is required. Send {} to export the list as it stands - omitting the body returns a 422 error. The optional sql field replaces the list’s rows with a custom query.

  • The response is the CSV file itself, as text/csv, named after the list. There is no job to poll and no download link to fetch afterwards.

  • For {object}, use person, company, deal, or a custom object’s c_ name.

  • Find the list ID in the address bar with the list open - it is the segment after /lists/. In code, GET /v1/workspaces/{slug}/objects/{object}/lists returns every list for that object with its ID and title.

  • Columns follow the list’s saved columns, including the record ID and fields on related records, which appear as Company > Domains. Click Save (or Save for everyone) before exporting if you have changed the columns on screen - the API reads the saved list, not your unsaved view.

  • The search field in the request body is not applied to this export. Filter in the list itself instead.

Authenticate with the api-key scheme, not Bearer. See Clarify API for keys and headers.

What an export contains

An export contains only the records and fields you can see. If a teammate cannot open a record in Clarify, it will not appear in their export either. See Sharing and permissions.

Did this answer your question?