Korean text turns garbled when I open a CSV in Excel

Built!

CSV Korean Fix checks the file's encoding and saves a version Excel can open, as UTF-8 BOM or CP949.

Current workflow

Open a marketplace settlement file, an order export, or survey results in Excel with a double-click, and the Korean text often turns into gibberish. People usually work around it by opening the file in Notepad and re-saving it with a different encoding, or by going through Excel's multi-step "Get Data from Text/CSV" wizard. LibreOffice opens these files correctly, but most people ultimately need the file in Excel. The file isn't damaged — it's an encoding interpretation mismatch. When a CSV has no BOM marker, Excel reads it in the legacy local encoding (CP949 on Korean systems), so a file saved as UTF-8 comes out garbled.

Solution

Fix Broken Korean in CSV

How to use

1. Add the CSV file with garbled text. If the file was already saved over in its garbled state, recovery is limited — add the original file as-is. 2. Check in the preview that the Korean text looks right, then choose UTF-8 BOM or CP949 and save. 3. Download the converted file and open it directly in Excel. 4. When you save the converted file again, be careful not to change the encoding back.

Example

- Input: a CSV file saved as UTF-8 — product names appear garbled when opened in Excel - Result: the same file with the encoding diagnosed and a BOM attached — the text displays correctly in Excel.

Open tool
View details
Limits
- A file that was already saved in its garbled state can only be recovered in a limited way. - If the data itself contains delimiter characters (commas or tabs), columns can shift for reasons unrelated to encoding. - Files with mixed encodings (only some rows differ) can be detected incorrectly.
Cost type
Free

Looking garbled and being damaged are two different things. If the text only displays incorrectly while the underlying data is intact, reopening or converting with the correct encoding restores it. But if the file was saved over while garbled, the original encoding information is gone and recovery is limited. So when you receive a garbled file, don't save it first — open a copy. Encoding defaults also differ between Excel on Mac and Windows, so a file that's fine on Windows can appear garbled on a Mac.

Support

I have this problem too · 0 people

Sign in to support or ask a question

Comments

Be the first to comment.

Additional information

Delete a post made without signing in