Table

Exporting data

Once your data is enriched and ready, export it to use in your CRM, email platform, spreadsheet, or wherever else you need it.


Export formats

This table scrolls sideways on small screens.

FormatBest for
CSVUniversal —works with nearly every tool. Default choice.
Excel (.xlsx)Analysis in Excel or Google Sheets with formatting preserved.
JSONDeveloper integrations and custom workflows.
TSVAlternative to CSV when your data contains lots of commas.

How to export

  1. Open your table.
  2. Click the Export button in the toolbar.
  3. Choose your format (CSV, Excel, JSON, or TSV).
  4. Select which columns to include (all, or pick specific ones).
  5. Choose which rows to export:
  • All rows —everything in the table.
  • Filtered rows —apply a filter first, then export only visible rows.
  • Selected rows —select specific rows with checkboxes, then export.
  1. Click Export and the file downloads.

Selecting columns

You don't have to export every column. During export:

  • Check or uncheck columns to include.
  • Reorder columns if needed.
  • Rename columns for compatibility with your destination tool (renaming only affects the export, not your table).

Tip: If importing to a CRM, order and name columns to match the expected field names. This speeds up the import on the other end.


Common export scenarios

Import to your CRM

  1. Export as CSV.
  2. Select key columns: Email, First Name, Last Name, Company, Title, Phone.
  3. Order columns to match your CRM's import fields.
  4. In your CRM, use the import feature and map CSV columns to CRM fields.

Email campaign

  1. Export as CSV.
  2. Select: Email, First Name, Last Name, Company, Job Title.
  3. Filter to rows where email is not empty.
  4. Upload to your email platform as a contact list.

Spreadsheet analysis

  1. Export as Excel (.xlsx) for formatting, or CSV for simplicity.
  2. Include all columns.
  3. Open in your spreadsheet application for pivot tables, charts, and formulas.

Quality checks before exporting

Before you export:

  1. Check for duplicate rows.
  2. Verify key fields (email, company) are populated.
  3. Review formatting (phone numbers, dates).
  4. Spot-check a few rows for accuracy.

Privacy and security

  • Only export data you need.
  • Store exported files securely.
  • Delete old exports when they're no longer needed.
  • Follow applicable data privacy regulations (GDPR, CCPA, etc.).

Troubleshooting

This table scrolls sideways on small screens.

ProblemSolution
Export button grayed outMake sure your table has at least one row. Select columns to include.
Missing data in exportThis is expected if enrichment didn't find data. Check your enrichment results.
Formatting lost in CSVCSV is plain text. Use Excel (.xlsx) format if you need formatting preserved.
Special characters garbledTry exporting as UTF-8 CSV, or use Excel format.

Next steps