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.
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
Comments
Be the first to comment.