troubleshootingimportcsvmappingduplicateserrors

Import Failed or Produced the Wrong Rows

Validate the source file, mapping, sample, and duplicate handling.

Last updated

Import Failed or Produced the Wrong Rows

Import problems usually come from file structure, field mapping, unexpected formatting, or assumptions about duplicates.

Where to find it: the relevant Import screen

What to do

  1. Keep the original file and make a working copy.
  2. Check the header row, blank rows, date formats, phone numbers, and email columns.
  3. Use a small sample file to reproduce the issue.
  4. Review every field mapping and duplicate option.
  5. Capture the import summary and row-level errors before trying again.

Good to know

  • Do not re-import the full file until you know whether the first attempt created records.
  • Spreadsheet applications can silently change dates and long numbers.

Was this article helpful?