CSV import issues

Import fails immediately after upload

This usually means the file format isn't valid. Check:

• File is .csv, .tsv, or .txt (not .xlsx or .numbers)
• File is UTF-8 or Latin-1 encoded (not UTF-16)
• File has a header row as the first row
• File is under 100MB

All rows are being skipped

Check that the email or customer_id column is mapped correctly. If the column containing emails is mapped to "Skip", all rows will fail validation. On the column mapping screen, make sure the email column is mapped to "Email ✦ Required".

Dates aren't being recognised

LiftSignals supports: YYYY-MM-DD, MM/DD/YYYY, DD/MM/YYYY. Formats like 14-03-25 or March 14, 2025 are not reliably detected. Convert your dates to ISO 8601 format (2025-03-14) for the best results.

Import completed but data looks wrong

Download the import report from the completion screen to see which rows encountered issues. The report shows the specific row number and the exact error for each skipped or warned row.