"Illegal quoting in line 2" — what broke and how to fix it

The fix

Every double-quote (") that appears inside a field value needs to be written as "". And the field itself needs to be wrapped in outer quotes too. A description that says Fits a 10" frame needs to appear in the Comma-Separated Values (CSV) file as "Fits a 10"" frame" — two double-quotes in the middle, one pair on the outside.

Finding and repairing every instance across hundreds of rows by hand is error-prone. Upload your file to the repair tool above and it handles the escaping for every affected field automatically, then shows you a list of the exact cells it touched before returning a clean file. Once your file is quoting-clean, the full Shopify products CSV repair tool catches any other issues — price formatting, duplicate handles, header mismatches — before you upload to Shopify.

What Shopify actually means by this

CSV files use double-quote characters (") to wrap fields that contain commas. When a field also contains a literal double-quote — like a product title that says 8" LED Panel or a description quoting a measurement — CSV rules say that inner quote has to be written twice ("") so the parser knows it's part of the data, not the end of the field.

If that doubling didn't happen — which is common after editing in Excel, Google Sheets, or any tool that applies its own quoting logic on save — Shopify's parser sees an unexpected " in the middle of a field and immediately rejects the entire file with "Illegal quoting in line 2." It says "line 2" because line 1 is the header row; the parser fails on the very first product row.

Three things that cause it

• A product description with inch marks or quoted words. Any " in a body field that wasn't doubled-up becomes an escape problem when the file is saved.
• Excel re-saved the file. When you open a Shopify CSV in Excel and save it back as CSV, Excel applies its own quoting rules. If the description already had quotes, Excel can produce a malformed result where those quotes are no longer correctly escaped.
• The file was concatenated or edited in a text editor. Manually joining two CSV files or fixing things in Notepad can introduce a raw " that breaks the format.

Why it blocks the whole import

Unlike per-row errors that let the rest of the file through, bad quoting breaks the CSV parser's ability to know where one field ends and the next begins. Once it hits the bad quote, it can't recover — every subsequent row is ambiguous. That's why Shopify rejects the entire file rather than skipping the problem row.