Error Library · Shopify import errors in plain words
Illegal quoting on line …
On the line Shopify names, it found quote marks it cannot make sense of. A spreadsheet file uses straight quotes (") to wrap text; the bent quotes that word processors produce — “ and ” — break the pattern, and one stray quote can make a whole row unreadable.
Why it happens
The file passed through Word, Google Docs, an email, or a supplier’s system that replaced straight quotes with curly ones, or a product description contains a quote mark that was never closed properly.
Fix it by hand
- Open the file in a plain text editor (Notepad, TextEdit) — not a word processor.
- Find the line Shopify named and look for bent quotes or a lone quote mark in the text.
- Replace curly quotes with straight ones, and save the file as UTF-8 text.
- Or run the file through the fixer below: straightening curly quotes is one of its automatic fixes.
Or let the fixer read the file
Drop the file in — the check runs in your browser, your file never leaves your computer, and you get every problem listed with its line number.
Drop your Shopify product file here
A .csv spreadsheet file — the one Shopify refused, or the one you are about to upload.
Your file is read by your own browser, on this computer. Your file never leaves your device.
Questions
Why does one quote break a whole row?
The importer reads a quote as “text starts here” and the next quote as “text ends here”. A bent or extra quote makes everything after it look like one giant cell, so the row no longer lines up with the columns.
Where do curly quotes come from?
Word processors and some supplier systems swap them in automatically because they look nicer in documents. Spreadsheet files are not documents — they want the plain kind.