Garbled text in CSV files: UTF-8, CP949, and how to open them
Garbled text comes from an encoding mismatch
Characters in a CSV file are stored using an encoding. Reading them with another encoding can turn accented or non-Latin text into unreadable characters. The bytes may still be intact; the interpretation can be wrong.
Two common encodings
UTF-8 is widely used by web services. CP949 is a Korean Windows encoding that extends EUC-KR. Depending on the system and Excel version, opening a CSV by double-clicking may interpret UTF-8 as CP949 and garble accented or non-Latin text. Conversely, a CSV saved using CP949 can look garbled on a site expecting UTF-8.
How to open the file correctly
In Excel, use Data → From Text/CSV and select the file encoding while checking the preview. If accented or non-Latin characters look garbled, try UTF-8. To export UTF-8, choose CSV UTF-8 under Save As. A BOM marker at the start of a UTF-8 file also helps Excel recognize its encoding.
An encoding is difficult to identify by eye. Use Loopyti’s Prevent Excel Data Loss: CSV Value Check to inspect the encoding before opening your file.