Contact Import Failed

    What to check when a CSV import does not work.

    Beginner2 min readUpdated 13 Sep 2026

    1. Is it really a CSV?

    .xlsx is not CSV. In your spreadsheet program use Save as → CSV (comma delimited).

    2. Is there a header row?

    The first row must name the columns so you can map them during import.

    3. Are the columns mapped?

    Unmapped columns are skipped silently. Check the mapping step before confirming — this is the most common reason a "successful" import is missing data.

    4. Are email addresses valid?

    Rows with a malformed address are rejected. Common culprits are trailing spaces, a comma instead of a full stop, and two addresses in one cell.

    5. Have phone numbers survived the export?

    Excel strips a leading + or 0 from anything it decides is a number. Format the phone column as text before exporting.

    6. Would this exceed your contact limit?

    The import stops at your plan's cap. Check the current count on the contacts screen.

    7. Is the file encoded correctly?

    Non-English names arrive mangled if the file is not UTF-8. Choose UTF-8 when saving.

    Try a small file first

    Export five rows and import those. Fixing the shape of a small file is much faster than debugging four thousand rows.

    Import Contacts.

    CSV

    Was this article helpful?

    Still need help?

    Tell us what you were trying to do and we will get back to you.

    Contact SurveyKar support