“Invalid CSV header: missing headers”: fixing the first row of a Shopify CSV

What the message means

The first row of a product CSV must contain column names Shopify recognizes. The message lists what it couldn’t find, most often Title. Shopify’s help center says the first line of the file doesn’t match the required format and warns about trailing spaces in the header row.

Common causes

• The header row isn’t the first row. Supplier sheets often start with a logo, a company name or a blank line.
• Translated or renamed columns, such as Product name or Ürün Adı instead of Title.
• Spaces or invisible characters: Title with a trailing space, or a non-breaking space copied from a web page.
• A different delimiter. Files saved with semicolons (common with European Excel settings) arrive as one long column name.
• Not actually a CSV, for example an .xlsx file renamed to .csv.

How to fix it

1. Open the file in a text editor and look at line 1. It should start with column names separated by commas, such as Title,URL handle,Description,Vendor.
2. Delete any rows above the header.
3. Rename columns to Shopify’s names exactly. Compare with the free Shopify CSV template.
4. Remove trailing spaces from every column name.
5. If the columns are separated by semicolons, re-save the file with commas: CSV UTF-8 (Comma delimited) in Excel, or download from Google Sheets.
6. Import again.

Shopify accepts both its current column names and the older ones (Handle, Body (HTML), Variant Price and so on), but use one naming style consistently and never column names in another language.

When your file is a supplier price list

A supplier sheet with its own headings can’t be imported by renaming a column or two: the prices, variant rows and handles also have to be rebuilt. Sheet2Store’s Excel to Shopify converter recognizes common supplier headings (including Turkish ones like Ürün Adı and Stok Kodu), lets you map them, and writes a file with Shopify’s exact header row.