← All guides

Shopify CSV import: “Illegal quoting on line …”

What the Shopify “Illegal quoting” error means and how to repair the product CSV so it imports.

Fastest fix

Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.

Validate my CSV →

Why this happens

How to fix it

  1. Open the line number from the error and look for quotes inside text.
  2. Write a quote inside a field as two quotes (""), or replace it with ″ or the word inch.
  3. Save the file as “CSV UTF-8”, not plain “CSV”.
  4. Validate the file before uploading it again.

Still stuck? Ask SheetFix Support