← All tools

Fix CSV character encoding

Repair broken-looking letters and download a CSV that opens correctly in Excel. Your file never leaves this computer.

Drop your CSV file here or click to choose. To paste text instead, use the link below.

Why strange characters like "é" appear

Computers store letters as numbers, and the "character encoding" decides which number means which letter. Two families are common: older Windows encodings such as Windows-1252 and Windows-1254, and UTF-8, which is used almost everywhere today. When a file saved in one encoding is opened as the other, accented letters such as é, ü, ş or ñ turn into "é", "ü" or question marks.

The most common case: a CSV downloaded as UTF-8 from a website or app, then opened by double-clicking in Excel. If Excel does not see a special marker (a BOM) at the start of the file, it reads it with the old encoding and the accented letters break.

How this tool fixes it

It detects the file's encoding automatically, reads the text correctly and saves it again in the format you choose. If you will open the file in Excel, keep "Add UTF-8 BOM" on; when Excel sees that marker it shows accented letters correctly. If the file goes to a web system, a database or other software, UTF-8 without BOM is usually safer.

The preview table lets you check that the letters look right before you download. If detection gets it wrong, you can choose the reading encoding yourself.

Before you save a broken file

Do not save a file in Excel while its letters look broken. If you do, the broken characters are written into the file permanently and become very hard to fix. Run the original file through this tool first, then open it in Excel.

Privacy

Your file is processed in your browser and never sent to a server, so it is safe for customer lists and accounting data.

How to use it

  1. Drop your CSV file into the box. The encoding (UTF-8 or Windows-1254) is detected automatically.
  2. Check in the preview that the letters look right. If not, pick the encoding by hand in the Reading section.
  3. In the Output section the UTF-8 BOM for Excel option is on. Download the CSV.

Frequently asked questions

Why do accented letters look broken?

The encoding of the file does not match the encoding the program expects. Older Turkish Excel uses Windows-1254 while most modern programs expect UTF-8. The tool detects the encoding automatically.

Which output should I choose?

If you will open the file in Excel, keep Add UTF-8 BOM on. If you hand it to another program or system, UTF-8 without BOM is usually safer, so turn the box off.

What if automatic detection is wrong?

In the Reading section you can pick UTF-8 or Windows-1254 by hand from the Character encoding list.

Related guide

Related tools