Fix garbled CSV

Drop a garbled CSV and we read it again in the right encoding and show it as a table. Edit it in the sheet editor, or save it so Excel opens it cleanly.

No upload

Drop a garbled CSV here

We pick the right encoding and show it as a table. The file never leaves this browser.

How to fix a garbled CSV

  1. 1

    Drop the CSV

    Drop the garbled .csv, .tsv or .txt file, or press Choose a CSV.

  2. 2

    Check the table

    It opens in the encoding we picked. If the text still looks wrong, choose another under Change encoding.

  3. 3

    Edit or save

    Press Open as a table to edit to go to the sheet editor. To just save it again, choose CSV for Excel (UTF-8 with BOM) or the original encoding.

Why CSV text gets garbled

Excel guesses the encoding of a CSV

A CSV file doesn’t say which encoding it was written in. Excel opens a CSV without a BOM in your system’s legacy encoding, so a UTF-8 file turns ü into ü and Japanese or Korean into nonsense. The opposite happens when an old Windows-1252 or Shift_JIS file meets a UTF-8 program.

This page looks at the bytes and picks the encoding. Besides UTF-8 it reads Shift_JIS, EUC-JP, CP949, GBK, Big5, Windows-1251, Windows-1252, ISO-8859-2, Windows-874, Windows-1254 and Windows-1258.

Leading zeros and dates stay as they are

Opening a CSV in Excel can turn a postcode like 01067 into 1067, a product code 00125 into 125, and change how dates look. Here every cell is read as text, so nothing changes.

Saving as .xlsx stores every cell as text, so leading zeros and dates survive when you open it in Excel.

Common questions

Is the encoding fixed automatically?+

Usually. We read the file again in the encoding the bytes point to. If the guess is wrong, pick another one under Change encoding.

How do I make a CSV that Excel opens correctly?+

Save it as CSV for Excel (UTF-8 with BOM). The BOM marker at the start tells Excel the file is UTF-8.

I need the file in its old encoding.+

Choose CSV (original encoding) to save it in the encoding it came in. If some characters can’t be written in that encoding, we list the cells first and let you replace them with ? or cancel.

My leading zeros disappear.+

Not here. Cells are read as text. If the file will be opened in Excel, saving as .xlsx is the safest.

The file was already saved garbled once.+

Try Undo text that was saved garbled (experimental). It works when the original bytes can still be recovered, and tells you when they can’t.

Does my file leave my device?+

No. Reading, detecting the encoding and saving all happen in your browser.