How to fix it in four steps
- Drop or paste your file. Drop your CSV on the box above, or paste its text into the box. It stays in this tab.
- See the damage. Click the button under the box to see what Excel broke, then untick any repair you do not want.
- Repair and check. Click Repair & preview. Read the before and after table: each old value is struck through, with the new value beside it.
- Download the fixed file. Say where the file is going next, then click Download fixed file. Your original file is not changed.
A worked example
A contact list shows Renée in the name column. The bytes for é are intact, but they were read with the wrong encoding. The tool reverses that, so the cell reads Renée, and the table shows the old and new values side by side. The download is saved as UTF-8.
A different file might show accents correctly here while looking wrong in another program. That usually means it was saved as Windows-1252, often labelled ANSI. The tool detects that, names it above the results, and saves your copy as UTF-8.
What this cannot fix
- Question marks and replacement characters. If a file already contains
?or�where a letter should be, the original letter was thrown away when the file was saved. Export it again from the source. - Text that only looks wrong. The tool changes a cell only when reversing the damage gives valid text, so genuine characters are left alone. Check the before and after table for anything unexpected.
Prevent it next time
- In Excel, save with File → Save As → CSV UTF-8, not plain CSV.
- Open CSV files through Data → From Text/CSV and choose UTF-8 as the file origin.
- Ask whoever sends you the export to supply UTF-8, which most systems can do.
More help
Only want to know what encoding a file uses, without changing it? Use the CSV encoding checker. For the background, read how to change CSV encoding to UTF-8 and ANSI vs UTF-8.
Frequently asked questions
How do I change a CSV file to UTF-8?
Drop the file on this page and click Repair & preview, then Download fixed file. The tool detects the current encoding, reads the file with it and saves the download as UTF-8. Your original file is not changed.
Why does my CSV show strange characters like café?
The file was saved as UTF-8 and then read with a different encoding, so one letter was shown as two. The bytes usually survive, which is why this tool can reverse the damage and show you each repaired cell.
Can question marks in a CSV be turned back into letters?
No. A question mark or replacement character means the original letter was thrown away when the file was saved. Export the file again from its source and save it as UTF-8.
Is my file uploaded to fix the encoding?
No. The file is read and repaired in your browser tab, and nothing is sent to a server. You can switch off your Wi-Fi after the page loads, and it still works.