Fix CSV Encoding and Delimiter
A CSV that opens right: garbled accents and one-column files fixed, saved as UTF-8 with the separator you choose.
Want it to work exactly your way?
Keep this tool in your Mini-Apps to run it again in one click, or describe the job and AI builds an app of your own.
How to use Fix CSV Encoding and Delimiter
- 1Select your file, or drop it on the page
- 2Choose how, then run it
- 3Download fixed.csv
Your file is opened in an isolated sandbox with no internet access, processed and deleted with it. It is read the way people's spreadsheets really are — headers that are not on row 1, merged cells, totals pasted at the bottom, dates in two formats — and everything that is changed is listed back to you.
Questions
Why do accented letters show as strange symbols?
The file was saved in one encoding (often UTF-16 or a Windows code page) and opened in another. The tool detects the original and saves UTF-8 with the marker Excel needs.
Why does my CSV open in a single column?
Its delimiter is not the one your Excel expects. Choose commas or semicolons — whichever your Excel's region uses — and the columns open split.
Does it change my data?
No. Every cell is kept exactly as it was; only the encoding and the separator change.
Which encodings does it read?
UTF-8, UTF-16 and the common Windows and Latin code pages, including the Vietnamese one, detected from the file itself.