How to convert Korean CSV files to Excel without garbled text
CSV stores table text but does not always identify its encoding. If Korean characters look garbled, keep an untouched copy and check the input encoding before saving over anything. Switching between UTF-8 and CP949 can fix a decoding mismatch.
Worked example
The values below are fictional examples that illustrate the workflow.
Input and settings
CSV text: ID,Name 001,김하늘 For a file saved as CP949, choose CP949 as the input encoding
Expected result
XLSX output: ID 001 is saved as text Name: 김하늘 CSV output includes a UTF-8 BOM
Steps
- Choose a file in Convert CSV ↔ Excel. If reading Korean text fails, switch the input encoding to CP949 / EUC-KR and inspect it again.
- If data ends up in one column, check the delimiter. Select comma, semicolon, or tab to match the source.
- Choose Excel (.xlsx) for CSV-to-Excel conversion. For XLSX-to-CSV, choose the desired source sheet and CSV output.
- Check Korean text and leading zeros in the result preview before downloading.
What to check
Encoding selection cannot restore text that was already corrupted when saved, or leading zeros that no longer exist in the source value or display format.
Another program may infer numeric types when reopening CSV. To keep leading zeros, use XLSX output or explicitly import those CSV columns as text.
CSV output prefixes potentially executable formula values with an apostrophe. Formula calculation and original formatting preservation are not supported.
Processing and saving
Files are processed in your browser without uploads. Download the result before closing the tab and compare it with your original. Learn more in the privacy and file-processing notice.