← ImportSift

Shopify CSV garbled characters? Convert it to UTF-8 free

Shopify reads product CSVs as UTF-8. Excel's plain "CSV" save uses Windows-1252, so curly quotes, dashes, accents and symbols come through as ’, –, é or � in your titles and descriptions.

This converter fixes the whole file at once. It re-encodes Windows-1252 and UTF-16 ("Unicode Text") saves to UTF-8 and repairs text that was already double-encoded (’ → ’). Then you download the fixed CSV. It runs in your browser: nothing is uploaded, no signup, free.

Why it happens

Two different mistakes look the same. 1. Wrong encoding: the file was saved as Windows-1252, so Shopify misreads every byte above plain ASCII. 2. Double encoding: a UTF-8 file was opened and re-saved as Windows-1252 once (or more), so ’ was stored as the three characters ’. Re-saving in Excel fixes the first but not the second. This tool fixes both and lists every cell it changed.

Avoid it next time

  1. In Excel use File → Save As → "CSV UTF-8 (Comma delimited)", not "CSV (Comma delimited)".
  2. Or edit in Google Sheets and use File → Download → CSV (always UTF-8).
  3. Don't open and re-save the same CSV in Excel several times. Each save can add another layer of garbling.

Encoding is one of about 30 things that break a Shopify import. Run the free checker for handles, variants, image URLs, inventory and price columns too. See also: garbled characters after import · split a CSV over 15 MB · clean product CSV template.

ImportSift is independent and not affiliated with Shopify. · support@importsift.com