Skip to main content

Leads Not Importing

How to fix CSV upload errors, character encoding issues, and column mapping failures.

Updated over 2 months ago

The "Upload Failed" Error

Importing a CSV seems simple, but data formatting is often messy. If SendScale rejects your file or imports "0 Leads," follow this protocol.

Common Formatting Fixes

1. File Format Must be CSV

  • SendScale cannot read .xls or .xlsx (Excel) files.

  • Fix: Open your file in Excel/Google Sheets, go to File > Download/Save As > Comma Separated Values (.csv).

2. UTF-8 Encoding

  • If your file contains special characters (accents like é, emojis, or non-English symbols), a standard CSV save might corrupt them.

  • Fix: When saving, select "CSV UTF-8 (Comma delimited)". This ensures special characters are readable.

3. Header Rows

  • The first row of your file must contain headers (e.g., "Email", "First Name").

  • If Row 1 contains data (e.g., [email protected]), the importer will get confused.

The Mapping Screen

When you upload, SendScale asks you to "Map" columns.

  • Essential: You must map a column to "Email". Without an email address, the row is rejected.

  • Variables: Ensure you map "Company" to the {{companyName}} variable, not a custom variable, if you want it to work with our AI features.

Did this answer your question?