An imported file has the wrong values in the wrong fields

Short answer

The importer has to be told which column is which. The column headings in the file did not match closely enough to be matched automatically, so the mapping needs setting by hand.

What it means

The importer has to be told which column is which.

Why it happens

The column headings in the file did not match closely enough to be matched automatically, so the mapping needs setting by hand.

How to fix it

1. Re-run the import and check each column mapping against the sample rows shown.
2. Set any column explicitly where the suggestion is wrong — an explicit choice is always kept.
3. Import a small test file first to confirm the mapping before importing everything.

Other ways this is described

• csv import wrong columns
• import mapping wrong
• csv headers not matching

Still stuck?

If none of the steps above match what you are seeing, open a ticket from Support > My Tickets with the exact message, the page and a screenshot. Guessing at a different cause only costs you time.