Exporting Your Data

Cleanlist supports two export formats:

No other formats are supported (no Excel/.xlsx, no ZIP batching, no scheduled exports, no FTP/SFTP, no email delivery of exports).

CSV Export

Quick export

1. Open any lead list
2. Click Export
3. Choose Quick Export — all fields, all leads
4. A signed download URL is generated; the file downloads immediately

The link is valid for 24 hours. Download it right away.

Custom export

1. Open the lead list
2. Click Export → Custom Export
3. Configure your export:
   • Select leads: All, selected only, filtered, or first N leads
   • Choose columns: Standard fields, Smart Column data, metadata
4. Click Download CSV

What's included in a CSV export

Standard columns (always available):

• First Name, Last Name, Email, Phone
• Company, Job Title
• Location (City, State, Country)
• LinkedIn URL

Smart Column data: any smart column results, each as a separate column

Metadata columns:

• Enrichment Date
• Source
• Confidence Score
• Validation Status
• Phone Type
• Created Date / Updated Date

Example output

first_name,last_name,email,phone,company,title
John,Doe,john@acme.com,+15551234567,Acme Corp,VP Sales
Jane,Smith,jane@tech.com,+15559876543,Tech Inc,CEO

Export Filters

Use list filters before exporting to create targeted subsets:

Filter by email status

1. Click the filter icon on the Email column
2. Select a status (verified, likely_valid, risky, invalid, unknown)
3. Export — only matching rows are included

Filter by enrichment date

Filter the "Enriched Date" column by date range to export only recently enriched leads.

Filter by Smart Column results

Add a Smart Column (e.g., icp_fit_analysis), filter to fit_level = perfect, then export the qualifying subset.

Combining filters

Stack multiple filters for precise exports:

Filter 1: Title contains "VP"
Filter 2: Company size > 1000
Filter 3: Email status = verified

Export only leads matching all criteria.

JSON via API

For developers needing programmatic access, retrieve leads via the paginated JSON endpoint:

Authentication

Authorization: Bearer YOUR_API_KEY

Endpoint

GET /api/v2/lead-lists/{list_id}/leads

Query parameters

?limit=100&cursor=abc123

Example response

{
  "list_id": "list_abc123",
  "leads": [
    {
      "first_name": "John",
      "last_name": "Doe",
      "email": "john@acme.com",
      "phone": "+15551234567",
      "company": "Acme Corp",
      "title": "VP Sales"
    }
  ],
  "total": 1000,
  "cursor": "def456"
}

See the API reference for full parameter documentation.

CRM Sync (instead of exporting)

If you have a HubSpot or Salesforce integration configured (Pro+), push leads directly without exporting a file:

1. Open the lead list
2. Click Sync to CRM
3. Map fields (first time only)
4. Choose sync options (create new, update existing, skip duplicates)
5. Start sync and monitor progress

See CRM integration guide for setup instructions.

Tips for Format Compatibility

For HubSpot import

firstname,lastname,email,phone,company,jobtitle

Use HubSpot property names (lowercase). Email required for contact creation.

For Salesforce import

FirstName,LastName,Email,Phone,Company,Title

Use E.164 format for phone (+1234567890). Match Salesforce field names exactly.

For Google Sheets

CSV with UTF-8 encoding. Import via File → Import → Upload.

Troubleshooting

Download link expired

The signed URL is valid for 24 hours. Re-run the export to get a fresh link.

Wrong number of rows

Check for active filters or an active search term — both reduce the exported row count.

Special characters broken

Use UTF-8 encoding. In Excel, open via Data → From Text → UTF-8 to preserve accented characters.

Need a very large export

Use the JSON API with pagination for large datasets (50,000+ leads). The cursor-based pagination handles any list size.

Learn More

• Managing Lead Lists
• API Reference
• Set up CRM integrations