Fix a CSV file with broken characters
Drop the CSV: the tool recognises its encoding and delimiter, repairs damaged characters, and gives you a file Excel opens right the first time, as CSV or XLSX.
What this tool does
- The encoding recognised: UTF-8, Windows-1252, Mac, DOS code page, UTF-16.
- Double-encoded characters ("é", "’") repaired one by one, with examples on screen.
- The delimiter detected from how regular the columns are, not from how many commas there are.
- Quoted fields, line breaks inside a cell, quotes that were never closed.
- In XLSX, numbers and dates recognised column by column, and codes with leading zeros kept as text.
What it does not do: A file that is not text (an old .xls renamed .csv, for example) is refused with an explanation. A number a spreadsheet already truncated at its 16th digit cannot be repaired: the lost digits are no longer in the file.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Remove duplicates : On the columns you choose, optionally ignoring case, spaces and accents.
- Near-duplicates : "Smith Ltd" and "SMITH LTD.": the almost-identical duplicates, reviewed one by one.
- Clean text : Extra spaces, non-breaking spaces, line breaks, invisible characters, case.
- Convert text to numbers : "1,234.56 $", "(45.00)", "12.5-": real numbers that add up.
- Fix dates : Dates as text, day and month swapped, "20260315": real dates.