Shopify 'Missing headers: Title' error
This means Shopify can't find the column for product names. A header is just a column name in the top row of your spreadsheet.
Start with the top row
- Save a backup of your file.
- Open the spreadsheet and look for a column named Title.
- If it's missing, add it and enter a name for each new product. A product's extra size, color, or image rows can have blank titles.
- If Title is already there, click the cell and check for spaces before or after the word. Remove only those extra spaces.
- Check the other column names against Shopify's sample product file.
An example
| Column name before | After |
|---|---|
Title [space] | Title |
[space] shows an extra space you might not notice. It isn't text to type into your file.
Still getting the error?
If all the column names appear in one spreadsheet cell, check how the file was opened or saved. Shopify needs commas between columns. Don't replace every semicolon or comma in your product descriptions. Save a properly arranged spreadsheet as CSV UTF-8 instead.
Some files also have a hidden mark at the start. CSV Spruce can read files with this mark. A hidden mark isn't always an error.
Don't delete a column just because it looks similar
If you have both Title and Title with an extra space, compare their contents first. They may hold different information. CSV Spruce won't choose one and discard the other.
What we can fix
We can remove extra spaces around supported column names when the intended name is clear. We keep your product details unchanged. We don't invent missing product names or rename unfamiliar columns.
Older Shopify names such as Handle and Variant SKU can still be valid. They don't need changing just because a newer template uses URL handle and SKU.
All import errors · Quotation-mark errors · TRUE/FALSE answers · Sizes, colors, and product rows
More help from Shopify
Your report is free. Pay $3.99 only if you choose a corrected download.