Shopify CSV import error
“Strange characters such as é, ’ or � after a CSV import”: what it means and how to fix it
Why it happens
- Excel saved the file as “CSV (Comma delimited)”, which uses the computer's local encoding (often Windows-1252), not UTF-8.
- The file was opened and saved again in a program that changed the encoding.
- Text was pasted in from a PDF or a word processor with characters outside the file's encoding.
- The same file was converted twice, so “é” became “é” and was saved that way.
How to fix it
- Excel: File → Save As → “CSV UTF-8 (Comma delimited) (.csv)”.
- Google Sheets: File → Download → Comma-separated values. Sheets always writes UTF-8.
- Numbers: File → Export To → CSV, and choose Unicode (UTF-8) under Text Encoding.
- If the file already shows é in the cells, fix it at the source: export again from the original system rather than saving the broken file.
- Or open the file in a text editor and save it with UTF-8 encoding, as Shopify's help center suggests.
How Bulkvane handles it
Bulkvane reads CSV files as UTF-8, and its own CSV exports include the marker Excel looks for, so accents open correctly when you double-click the file. Uploading an Excel (.xlsx) file avoids encoding problems altogether: Bulkvane imports .xlsx directly, with a sheet per data type.
Every file is checked before anything changes, with problems named by row in plain words, and any import can be undone for 30 days. All of Bulkvane's messages are in Errors A–Z.
Questions
Why does my Shopify CSV show é instead of é?
The file was saved in one encoding and read in another. Save it as CSV UTF-8 and import again.
Does Shopify support other languages in CSV files?
Yes. Shopify supports any character in UTF-8, including accents and non-Latin scripts, as long as the file is saved as UTF-8.
How do I check a CSV's encoding?
Open it in a text editor such as VS Code or Notepad++: the encoding shows in the status bar, and you can save it again as UTF-8 from there.
Message, cause and fix from the Shopify Help Center: common product CSV import issues, checked . Still stuck? See Shopify CSV import not working? or ask us.
Preview every change.Undo any import for 30 days.
Install free