Convert Chinese CSV Files

Exported a spreadsheet in Traditional characters, or need a product list in Traditional? Drop in the CSV file. Every cell is converted, the table structure stays the same, and the download opens in Excel without garbled Chinese.

Direction
Standard
Engine not loaded yet
File name
BOM
A marker at the start of a UTF-8 file. Auto: added to CSV (Excel needs it); other formats follow the original file.
Advanced options by format

Drop files here, or click to choose

Subtitles, lyrics, documents and data files; you can pick several at once. Only the text is converted: timings, tags and structure stay as they are.

.txt .srt .ass .ssa .vtt .lrc .md .markdown .json .csv .html .htm

Text and files are processed in your browser and never uploaded.

CSV (comma-separated values) is the most widely used format for moving table data around. Excel, Numbers, databases and admin systems all import and export it. Each line is a record, and cells are separated by commas, or by semicolons or tabs in some regions and programs. A cell that contains the delimiter itself is wrapped in double quotes.

What is converted

The header row and the text of every cell. Digits, Latin letters and ASCII punctuation are never touched by OpenCC, so prices, IDs and dates stay as they are.

What stays the same

Delimiters (commas, semicolons, tabs), quotes and line endings are all kept. The number of rows and columns does not change, and the file can go straight back into the system it came from. In the examples below, the quoted cell with doubled quotes around 墨水 (ink) keeps its quoting exactly.

Garbled text and Excel

Excel, especially older versions, often shows Chinese as gibberish when it opens a UTF-8 CSV without a BOM, the byte order mark at the start of the file. That is why CSV files get a BOM by default, with BOM on Auto, and the file then opens correctly with a double-click. A GBK or Big5 original is detected, and the output is always UTF-8.

Conversion examples

OriginalResult
品名,數量,說明品名,数量,说明
軟件,3,"雲端版本, 專業版"软件,3,"云端版本, 专业版"
鼠標,10,無線鼠标,10,无线
打印機,2,"含""墨水""兩盒"打印机,2,"含""墨水""两盒"
顯示器,5,显示器,5,

Real output from OpenCC (t2s).

How to use

  1. If the table is open in Excel, save it as CSV first. Then drop the .csv file onto the page, or click Choose files.
  2. Choose the direction and standard, T→S to turn Traditional into Simplified or S→T for the reverse.
  3. Check the encoding and the preview on the card to make sure the headers and data are readable.
  4. Download the file and open it in Excel. With BOM left on Auto, the Chinese displays correctly.

Things to check

  • With General, T→S changes only the characters. 鼠標 (mouse) becomes 鼠标, but Taiwan's 軟體 (software) only becomes 软体. For the mainland word 软件, choose Taiwan under Standard and keep Convert regional terms on.
  • Columns used to match records, such as category or store names, will no longer match the values in your database once they are converted. Check before you import.
  • Personal names, brand names and addresses may have fixed spellings. Spot-check them after converting.

FAQ

Excel still shows garbled text. What now?

Make sure BOM is set to Auto or With, then check that the encoding shown on the card for the original file is right. A UTF-8 file with a BOM and a clean preview opens correctly in Excel.

Can I convert an Excel .xlsx file directly?

No. An .xlsx workbook is not plain text. Save it as CSV in Excel first, convert it, then open or import the result.

Do semicolon- or tab-separated files work?

Yes. Delimiters and quotes are kept as they are, so the number of rows and columns does not change.

Can I convert only some columns?

No, every cell is converted, including the header row. To convert only part of a table, copy those columns into the Text tab and convert them there.

I am importing into a database and do not want a BOM. What should I do?

Set BOM to Without. Some programs read the BOM as part of the first column name, so leaving it out is safer for imports.