Fix Shopify CSV Encoding and Illegal Quoting Errors

What the error actually means

Shopify requires CSV imports to use UTF-8. Its product-import guidance also groups some illegal quoting failures with non-UTF-8 or misplaced quotation marks. Encoding conversion can restore readable characters, but it will not correct a structurally misplaced quote or an incorrect Shopify header.

Likely causes

• The CSV was saved in a legacy Windows or regional encoding.
• Smart quotation marks were introduced while editing text.
• A quote inside a field was not escaped correctly.
• The file exceeds the limit for the Shopify import type or does not use the expected template.

A safe repair workflow

1. 1Keep the original export and preview it with the encoding fixer.
2. 2Choose the source encoding that restores known names and symbols, then export UTF-8.
3. 3If Shopify still reports illegal quoting, run the repaired copy through a CSV structural diagnostic.
4. 4Compare the header with Shopify’s current template and test a small import before replacing existing products or customers.

How to verify the result

A file that downloads successfully is not automatically a correct file. Check the result at both the structural and business-data levels:

• Accents, apostrophes and currency symbols display correctly.
• Every row has the expected number of fields.
• The header matches the intended Shopify import type.
• A small Shopify import succeeds without overwriting unintended records.