Error Library · Shopify import errors in plain words
Weird symbols in product titles after a Shopify import
Your products imported, but the names came out wrong: accents turned into strings like é, apostrophes into gibberish. The text was saved in one character encoding and read in another. The products are fine — the letters were translated badly on the way in.
Why it happens
The file was saved as plain “CSV” by Excel, which uses a Windows encoding, while Shopify reads UTF-8. Any letter outside plain English — é, ñ, ü, curly apostrophes — is written one way and read another.
Fix it by hand
- In Excel, save with “CSV UTF-8 (Comma delimited)” — the UTF-8 part is the whole point. In Google Sheets, downloads are UTF-8 already.
- Delete the garbled products from Shopify before re-importing, or re-import with overwrite ticked, so the bad text is replaced rather than duplicated.
- Check names with accents first after the new import.
- The fixer below writes its fixed file as clean UTF-8 every time, and warns you when a file’s text already looks garbled.
Or let the fixer read the file
Drop the file in — the check runs in your browser, your file never leaves your computer, and you get every problem listed with its line number.
Drop your Shopify product file here
A .csv spreadsheet file — the one Shopify refused, or the one you are about to upload.
Your file is read by your own browser, on this computer. Your file never leaves your device.
Questions
Can garbled text be repaired in place?
Sometimes the original letters can be guessed back, but not reliably for every character. Re-saving the source file as UTF-8 and re-importing is the fix that always works.
Why did only some products garble?
Only text containing letters beyond plain English is affected. A store whose names are all plain ASCII can import a wrongly-encoded file and never notice.