← Guides

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

  1. Choose a file in Convert CSV ↔ Excel. If reading Korean text fails, switch the input encoding to CP949 / EUC-KR and inspect it again.
  2. If data ends up in one column, check the delimiter. Select comma, semicolon, or tab to match the source.
  3. Choose Excel (.xlsx) for CSV-to-Excel conversion. For XLSX-to-CSV, choose the desired source sheet and CSV output.
  4. Check Korean text and leading zeros in the result preview before downloading.
Convert CSV ↔ Excel →

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.

More guides