Fix Garbled CSV Encoding for Excel
Fix Excel GarbleFix 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.
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ÐÕÃû,³ÇÊÐ,½ð¶î
ÕÅΰ,ÉϺ£,1280
ÀîÄÈ,±±¾©,2450
ÍõÀÚ,ÉîÛÚ,3690姓名,城市,金额
张伟,上海,1280
李娜,北京,2450
王磊,深圳,3690How 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.
- Drop unmodified CSV(s)Select your original .csv or .tsv export (don't save over garbled text in Notepad first).
- Verify detected encodingTxtTo auto-detects UTF-8, GB18030, Big5, Shift-JIS, EUC-KR, or Windows-1252 and lets you override manually if needed.
- 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.