Skip to content

Fix CSV Encoding

Drop a CSV with strange characters

Turns “é” back into “é”. CSV, TSV or TXT.

How it works and FAQ

How it works

  1. Drop the CSV with strange characters.
  2. Check the before and after. The encoding is detected for you; change “Read as” if needed.
  3. Download the fixed UTF-8 file.

Questions

Why do my accents show as é or ’?

The file was saved in one character encoding and opened as another, often UTF-8 opened as Windows-1252 and then saved again. Each accented letter turns into two or three wrong characters. This tool reverses that.

What does “Excel-friendly” do?

It adds an invisible marker at the start of the file (a byte order mark) that tells Excel the file is UTF-8, so accents open correctly when you double-click it.

Related: Spreadsheet Cleaner, Compare CSV