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.00Corrected 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.00Check 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
- In Excel, use File → Save As → "CSV UTF-8 (Comma delimited)", never plain "CSV".
- In Google Sheets, File → Download → CSV is always UTF-8.
- If the text is already garbled ("é"), re-saving will not help: the double encoding has to be reversed.
- 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.