CleanCSV

Fix CSV Encoding and Garbled Characters

Repair text like “Café” and “It’s”, read files saved as Windows-1252 or UTF-16, and export UTF-8 that Excel and other apps display correctly.

Free, no sign-upFiles never leave your deviceCSV, Excel & JSON

CSV & Excel cleaning workspace

No account. No uploads. Just clean data.

100% in your browser
1

Upload your file

Drop your CSV or Excel file here

or browse your device. You can select several files at once.

CSV, TSV, TXT, XLSX, XLS, ODS and JSON · up to 50.0 MB and 250,000 rows

Your files never leave your device.

Step by step

How to use this tool

  1. 1

    Drop your file into the tool above. The encoding is detected automatically: UTF-8, UTF-8 with BOM, UTF-16 and Windows-1252 all work, and a note tells you which was used.

  2. 2

    Repair garbled characters is on. It fixes text that was already damaged by a wrong conversion before it reached you.

  3. 3

    Download as CSV with Excel-friendly UTF-8 (on by default) or as .xlsx, which never has encoding problems.

What garbled text means

Characters like é, ’ and € take more than one byte in UTF-8. When software reads UTF-8 as if it were Windows-1252, each byte becomes its own character, so “é” turns into “é” and a curly apostrophe into “’”. This is called mojibake. The original bytes are still there, so it can be reversed exactly, which is what Repair garbled characters does.

Safe by design

The repair only changes a value when the result is valid UTF-8, so genuine accented text like “Zoë” or “à la carte” is left alone. Text that was garbled twice (“é”) is repaired too.

Opening the result in Excel

Excel on Windows assumes a CSV file uses the computer's legacy encoding unless it starts with a byte order mark (BOM). Keep Excel-friendly UTF-8 ticked when you download and accents display correctly when you double-click the file. If the file goes to a developer or a database instead, you can untick it.

Read the guide to garbled characters in CSV files for more background and fixes in other tools.

Frequently asked questions

What encoding should a CSV file use?

UTF-8. Add a byte order mark if the file will be opened in Excel, and leave it out for databases and code that expect plain UTF-8.

Why does my CSV look fine in Notepad but broken in Excel?

Notepad detects UTF-8, but Excel does not without a byte order mark. Download from this tool with Excel-friendly UTF-8 on, or download as .xlsx.

Can it fix question marks or � symbols?

No. Those appear when the original characters were replaced and lost. Export the file again from its source as UTF-8.