CSV Import

Import your lead lists from CSV files with automatic column mapping and smart deduplication.

Supported CSV Formats

Enrichabl supports standard CSV files with the following requirements:

  • Encoding: UTF-8 (recommended) or ASCII
  • File size: Up to 100MB
  • Row limit: 100,000 leads per import
  • Headers: First row must contain column names
  • Delimiter: Comma (,) or semicolon (;)

Example CSV Format

leads.csv
email,first_name,last_name,company,website,title
[email protected],John,Doe,Acme Corp,https://acme.com,CEO
[email protected],Jane,Smith,TechCo,https://techco.io,CTO
[email protected],Bob,Johnson,Startup Inc,https://startup.com,Head of Sales

Automatic Column Mapping

Enrichabl automatically detects and maps your CSV columns to standard lead fields:

Standard Fields

  • email - Primary email address (required)
  • first_name - First name
  • last_name - Last name
  • company - Company name
  • website - Company website URL
  • title - Job title
  • phone - Phone number
  • linkedin_url - LinkedIn profile URL
Column names are case-insensitive and spaces are ignored. For example, "First Name", "first_name", and "FirstName" are all recognized as the first name field.

Custom Fields

Any columns that don't match standard fields are imported as custom fields. You can map these manually during import or keep them as-is for later reference.

Deduplication Logic

Enrichabl prevents duplicate leads using configurable deduplication rules:

Deduplication Methods

  • By Email (Recommended): Skip leads with duplicate email addresses. Most common and reliable method.
  • By Custom Field: Deduplicate by any field (e.g., phone number, LinkedIn URL).
  • No Deduplication: Import all leads, including duplicates.
Deduplication only applies within the current import. If you import the same leads multiple times, they will be added as duplicates unless you manually delete the previous batch.

Handling Large Files

For files with 50,000+ leads, follow these best practices:

  • Split files: Break very large files into smaller batches (50k leads each)
  • Remove duplicates first: Deduplicate locally before importing
  • Clean data: Remove empty rows and invalid emails
  • UTF-8 encoding: Ensure proper encoding to avoid import errors

Troubleshooting Import Errors

Common Errors

Error: "Invalid CSV format"

Cause: File is not a valid CSV or uses unsupported encoding.

Solution: Save your file as CSV UTF-8 in Excel or Google Sheets.

Error: "No email column detected"

Cause: CSV doesn't have an email column or it's named differently.

Solution: Ensure you have a column named "email" or manually map it during import.

Error: "File too large"

Cause: File exceeds 100MB or 100,000 rows.

Solution: Split your file into smaller batches.

Encoding Issues

If you see strange characters (�, �) in imported data:

  1. Open your CSV in Excel or Google Sheets
  2. Save As → CSV UTF-8
  3. Re-import the file

Next Steps

After importing your leads: