TEXT🔧Encoding Fix
Encoding detection + mojibake repair to UTF-8
Excel and VBA tutorials from basics to practice — use the tools above as you go.
Encoding Fix: Auto-Detect Among 8 Encodings + Convert
This tool auto-detects the real encoding of garbled text (GBK/GB18030/Big5/UTF-8/UTF-16, etc.) and converts it to a target encoding. The most common case is: a GBK file exported from Windows is opened as UTF-8 and all Chinese text becomes garbled.
Typical scenarios: ① fix garbled Chinese CSV exported from a spreadsheet (most common); ② convert a scraped GBK web page to UTF-8; ③ convert Big5 traditional Chinese to GBK/UTF-8 simplified (combine with a simplified/traditional tool); ④ fix old database backups with mislabeled encodings.
How to use: ① paste the garbled text; ② the tool tries multiple encodings and suggests the most likely one based on garbling severity; ③ choose the target encoding and click Convert — copy the result.
Notes: ① detection is less reliable for very short text (under 200 characters) — add a longer sample and try again; ② pure English/numeric text is valid under every encoding, so the tool reports "cannot determine" — use the file-header marker as a guide; ③ if information was already lost in the source, conversion can only "guess" — try several combinations for the best result.
Related Tools
← Home