ShopifyGuide

Fix broken accents in a Shopify CSV (UTF-8 encoding)

Shopify expects product CSVs in UTF-8. When a file is saved in another encoding — or converted to UTF-8 twice — accented letters and curly quotes turn into sequences like "é" or "’". Shopify imports them as they are, and your storefront shows "Café Mug".

Why it happens

  • Excel on Windows saves "CSV" (not "CSV UTF-8") in Windows-1252.
  • A file that was already UTF-8 gets converted again by a script, a supplier portal or a text editor.
  • Copy-pasting from a web page or PDF brings curly quotes and non-breaking spaces.

Broken example

Handle,Title,Body (HTML),Option1 Name,Option1 Value,Variant Price
cafe-mug,Café Mug,<p>Stoneware mug</p>,Title,Default Title,12.50
creme-brulee-set,Crème brûlée Set,<p>Four ramekins</p>,Title,Default Title,24.00
womens-scarf,Women’s Scarf,<p>Merino wool</p>,Title,Default Title,35.00

Corrected file

Handle,Title,Body (HTML),Option1 Name,Option1 Value,Variant Price
cafe-mug,Café Mug,<p>Stoneware mug</p>,Title,Default Title,12.50
creme-brulee-set,Crème brûlée Set,<p>Four ramekins</p>,Title,Default Title,24.00
womens-scarf,Women’s Scarf,<p>Merino wool</p>,Title,Default Title,35.00

Check your own file in seconds

The fixer reads Windows-1252 files correctly, reverses double-encoded text when the original can be recovered with certainty, removes the byte-order mark and always exports UTF-8.

How to fix it

  1. In Excel, use File → Save As → "CSV UTF-8 (Comma delimited)", never plain "CSV".
  2. In Google Sheets, File → Download → CSV is always UTF-8.
  3. If the text is already garbled ("é"), re-saving will not help: the double encoding has to be reversed.
  4. Keep Handles in plain ASCII (cafe-mug, not café-mug): they become your product URLs.

Shopify documents the expected format in its common product import issues page. Checking is free and your file never leaves your browser; applying fixes and downloading the corrected file take CSV Viewer Pro or a one-time 2,99€ 24-hour pass.

Other Shopify CSV problems