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.
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.
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