Fix Garbled CSV Encoding for Excel

Fix Excel Garble

Fix garbled CSV encoding for Excel—decode GBK, Shift-JIS, Big5, EUC-KR, or UTF-8 and emit Excel-ready UTF-8 with BOM (EF BB BF) + CRLF locally.

100% Client-Side — Verify 0 bytes uploaded in Network tabVerify 0 bytes sent in Network tab

or drop files here · Ctrl V to paste · or drop .csv / .tsv files · supports batch repair
  • 0 bytes uploaded
  • Real 0xEF 0xBB 0xBF BOM
  • Fixes CJK & accented mojibake

Instant Before & After Preview

UTF-8 BOM (EF BB BF) + CRLF
Before (Input)customers-gbk.csv
ÐÕÃû,³ÇÊÐ,½ð¶î
ÕÅΰ,ÉϺ£,1280
ÀîÄÈ,±±¾©,2450
ÍõÀÚ,ÉîÛÚ,3690
After (Output).csv
姓名,城市,金额
张伟,上海,1280
李娜,北京,2450
王磊,深圳,3690

How it works

How to fix garbled Excel CSV files in 1 click

Why Windows Excel mangles UTF-8 CSVs and how byte-level encoding repair keeps every column intact.

  1. Drop unmodified CSV(s)Select your original .csv or .tsv export (don't save over garbled text in Notepad first).
  2. Verify detected encodingTxtTo auto-detects UTF-8, GB18030, Big5, Shift-JIS, EUC-KR, or Windows-1252 and lets you override manually if needed.
  3. Download Excel-safe CSVDownload the repaired UTF-8 BOM + CRLF CSV (or ZIP batch) and double-click straight in Excel.
Format specs:CSV (.csv)

FAQ

Frequently asked questions

Why does double-clicking a UTF-8 CSV in Windows Excel show gibberish?

Windows Excel requires the 3-byte UTF-8 Byte Order Mark (EF BB BF) at the start of a CSV; otherwise it decodes bytes using your local ANSI/CJK code page.

Will this preserve leading zeros on phone numbers and ZIP codes?

Yes! Unlike opening and re-saving inside Excel, byte-level encoding repair never alters cell text or converts long IDs to scientific notation.

Can I fix a whole folder of exported CSVs at once?

Yes. Drop multiple CSVs together to repair all of them in browser RAM and download a clean ZIP.