Import failed or won't start
- File format — save as CSV (not XLSX). Check for corrupted rows or merged cells.
- Size — very large files may need splitting; import in batches.
- Encoding — save as UTF-8 so accented characters survive.
Fields imported wrong
- Column mapping — the most common cause. Re-check the mapping step: name → name, email → email, and so on.
- Shifted columns — commas inside field values shift data. Quote fields containing commas in your CSV.
- Custom fields missing from mapping — create the custom field in account settings before importing.
Emails look wrong
- Trim spaces; lowercase addresses.
- One email per row — extra columns don't count as additional addresses.
- Validate format:
[email protected]. Malformed addresses bounce later.
After a bad import
Don't leave broken records in the database — filter for the affected import (Imported From activity filter), fix or delete, and re-import corrected. Bad data compounds: every campaign built on it inherits the problem.