.csv Import error / Selected column types invalid CSV-Header: Missing Header: Title

Shopify Discussion

Topic summary

Recurring CSV import errors when importing products, most often “Invalid CSV Header: Missing headers: Title” (also shown in German) and “Illegal quoting.” Root cause is frequently file formatting rather than missing data.

Key fixes and guidance:

  • Avoid Excel; it can alter characters on save. Use Google Sheets or Apple Numbers, then export as CSV. Copying the contents into a fresh CSV resolved several cases.
  • Use Shopify’s official product CSV template and ensure headers match exactly. UTF-8 alone isn’t sufficient if structure/formatting is off.
  • Variants/options: put Option 1 Name and the corresponding Option 1 Value on the same row; don’t list variant values on a new line. Remove Option 3 Name if Option 3 Value is empty.
  • Status column: if present, it must have values; otherwise omit it.
  • Handles (the product URL slug) must match existing products when updating; duplicates or mismatches cause skips and update failures.
  • Ensure image URLs are accessible.

Actions: Trevor tested and shared corrected CSVs, identified column/variant issues, and requested files/screenshots; some users received email follow-up.

Outcomes: Multiple users resolved issues by reformatting in Google Sheets/Numbers and aligning with the template. Latest post reports “Option value provided for unknown options”; thread remains open with ongoing troubleshooting.

Summarized with AI on January 8. AI used: gpt-5.
24

Hi, can you have a look on my csv file that isn’t importing but i think everything is ok, following the infos of the help and support pages.

I tried and tried but can’t import those 37 products!

Where could i send you this file Peter?

HELP

Thanks a lot!

Damien