Strange characters like é or ’ in your CSV — how to fix the encoding
Why accented letters turn into gibberish after export, and how to restore them before importing into your CRM or shop.
The message you see
é ë ’ strange characters in CSVFastest fix
Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.
Why this happens
- A UTF-8 file was opened as Windows-1252 (or the other way around).
- The file was saved and re-saved in different programs.
How to fix it
- 1Don't fix names by hand — repair the encoding of the whole file.
- 2Check that names like Müller and José look right in a preview.
- 3Save the result as CSV UTF-8 before importing.
Related guides
CSV
CSV opens in one column in Excel — how to split it correctly
CSVCSV error: “Expected N fields, saw M” / rows have the wrong number of columns
HubSpotHubSpot import error: “Make sure each column with data has a header”
Still stuck? Ask SheetFix Support