Skip to main content

CSV import issues

L
Written by Levon Adamyan
Updated this week

Common problems when importing CSV files and how to fix them.

File not uploading

  • Make sure the file is in .csv format (not .xlsx or .xls).

  • Check that the file size is within limits.

  • Try saving the file with UTF-8 encoding if you see garbled characters.

Columns not mapping correctly

  • Ensure your first row contains column headers.

  • Use standard names like "First Name", "Last Name", "Email", "Company", "LinkedIn URL" for best auto-detection.

  • You can always manually adjust the column mapping in the import wizard.

Missing data after import

  • Check that your CSV does not have empty rows or inconsistent formatting.

  • If columns appear empty, verify the data is not shifted (wrong delimiter).

  • Cleanlist uses comma as the default delimiter. If your file uses semicolons or tabs, try converting it first.

Duplicate leads

Cleanlist will flag duplicate leads within the same list based on LinkedIn URL or email address. You can choose to skip or overwrite duplicates during import.

Did this answer your question?