Shopify CSV import error

Shopify says "Line is invalid" or "Line 1 is invalid (No details)" — and gives you nothing else

You uploaded your product CSV and Shopify flagged a line as invalid — but the error message stops there. No field name, no hint about what's wrong. This is one of the most frustrating Shopify import errors because the message is technically accurate but practically useless.

import-shopify-products · xlsx-for-ai

How to track down the problem

If you can open the raw file as plain text (not in Excel — use Notepad or TextEdit in plain-text mode), search for the line number Shopify named and look at it directly. For Line 1 issues, look at the very beginning of the file for any odd characters before "Handle." For other lines, look for curly quotation marks or an unusual number of commas in that row.

If that's too involved, the faster path is to upload your file to the free Shopify product converter. It scans for all of these issues mechanically — invisible characters, wrong column names, mismatched quotes, column count mismatches — and tells you in plain language what it found and what it fixed. You get a repaired file back, ready to import.

One thing to rule out first

Before doing anything else: make sure you're uploading an actual Comma-Separated Values (CSV) file, not an Excel file. Excel files end in .xlsx or .xls. Shopify only accepts .csv. If you have an Excel spreadsheet, you need to export it to CSV first — in Excel, that's File → Save As → CSV (Comma Delimited). Our tool accepts both formats and does this conversion for you automatically.

Why "Line 1 is invalid" is almost always about your header row

When the error says Line 1, that's Shopify counting your very first row — the one with column names like Handle, Title, and Variant Price. Line 1 being invalid almost always means something is wrong with that header row, not with any of your actual product data.

The most common reason: a tiny invisible character got inserted at the very start of the file. If you saved your spreadsheet using Excel, it sometimes adds a hidden marker (called a byte-order mark) before the first letter of "Handle." Shopify reads the column name as something else, can't match it to what it expects, and calls the line invalid. You won't see anything wrong if you look at the spreadsheet — it only shows up when you look at the raw file in a plain text editor.

The second common reason: one or more of your column names is off. Shopify's column names are exact and case-sensitive. handle is not the same as Handle. Variant price is not the same as Variant Price. One wrong letter and Shopify rejects the line.

When it's not Line 1 — finding the broken row

If the error names a line further down — say, "Line 47 is invalid" — the problem is usually a stray quotation mark or a curly quote in that row. CSV files use straight double-quote characters (") to wrap cells that contain commas. If a product description or title has a curly quote (the typographic kind that Word and some spreadsheet apps add automatically, like or ), the CSV parser gets confused about where the cell ends. Shopify calls the line invalid but doesn't explain what the quote issue is.

Another cause at non-header lines: a row with a completely different number of columns than the rest of the file. If a cell in that row contained a comma and wasn't quoted properly, it looks like an extra column was added. Shopify expected 28 columns; this row looks like it has 29 — line invalid.

Getting a completely different error? Try "There was an error importing your CSV file" or head to the main import converter for the full fix.

Fix this free → Upload your CSV or spreadsheet to the Shopify product import converter. It finds the bad line, explains what's wrong in plain English, and hands you back a clean file.