Create Account

CSV Import

Import addresses in bulk using CSV files. Learn about the expected format, column mapping, and how to handle duplicates during import.

Import addresses in bulk using CSV files. This is the fastest way to add a large number of leads to your account at once.

Accessing CSV Import

You can start a CSV import from two places:

  • From Leads — Click Add Lead > Import CSV
  • From Campaign Leads — Use the import option within a campaign

CSV File Requirements

Your CSV file must meet the following requirements:

RequirementDetails
File Type.csv
EncodingUTF-8 or ANSI (auto-detected)
DelimitersComma (,) or semicolon (;) — auto-detected
HeadersFirst row should contain column names
QuotingValues containing commas or special characters should be wrapped in double quotes (")
Empty LinesEmpty lines are skipped automatically

Expected CSV Columns

ColumnRequiredDescription
street_addressYesThe street address
cityYesCity name
countryYesCountry name or code
stateNoState or province
postal_codeNoZIP or postal code
nameNoContact or building name
building_unitsNoNumber of units (for apartment buildings)
Custom FieldsNoAny custom fields configured for your team — mapped via the UI during import

Example CSV

street_address,city,country,state,postal_code,name
"123 Main St",Springfield,US,IL,62701,"John Doe"
"456 Oak Ave",Springfield,US,IL,62702,"Jane Smith"
"789 Pine Rd",Chicago,US,IL,60601,""

Import Steps

The import follows a 3-step wizard:

Step 1: Upload

  1. Select your CSV file
  2. The delimiter is auto-detected from the file content
  3. Optionally enable AI mapping suggestions to automatically match columns

Step 2: Mapping

  1. Map each CSV column to an address field
  2. Combine columns if needed (e.g., separate first name and last name columns into a single name field)
  3. Map any custom fields configured for your team
  4. Unmapped columns are ignored during import

Step 3: Defaults

  1. Set default values for any optional fields that are not mapped
  2. These defaults apply to all imported rows where the field is empty or unmapped

AI-Powered Mapping

When enabled, the system analyzes your CSV column headers and suggests mappings automatically. This is especially useful when your CSV uses non-standard or localized column names. You can review and adjust the suggestions before proceeding.

Duplicate Handling

During import, the system checks for duplicate addresses. For each detected duplicate, you can choose:

  • Skip — Do not import the duplicate row
  • Merge — Combine the new data with the existing address
  • Create — Import as a new address regardless

Import Progress

The import runs in the background. A progress indicator shows:

  • Total rows to process
  • Successfully imported count
  • Errors or skipped rows

You can continue using Sellfaster while the import completes.

Troubleshooting

Import Fails to Start

  1. Verify the file is a valid .csv file
  2. Check that the file is not empty
  3. Ensure the file size is within limits

Rows Not Importing

  1. Verify required columns (street_address, city, country) are mapped
  2. Check for missing values in required fields
  3. Review error messages for specific rows

Wrong Data in Fields

  1. Review your column mapping in Step 2
  2. Check that the CSV delimiter matches the file content
  3. Ensure quoted values are properly closed

Encoding Issues

If you see garbled characters:

  1. Re-save your CSV as UTF-8 encoded
  2. Most spreadsheet applications offer UTF-8 as an export option