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
| Original | Result |
|---|---|
| 品名,數量,說明 | 品名,数量,说明 |
| 軟件,3,"雲端版本, 專業版" | 软件,3,"云端版本, 专业版" |
| 鼠標,10,無線 | 鼠标,10,无线 |
| 打印機,2,"含""墨水""兩盒" | 打印机,2,"含""墨水""两盒" |
| 顯示器,5, | 显示器,5, |
Real output from OpenCC (t2s).
How to use
- If the table is open in Excel, save it as CSV first. Then drop the .csv file onto the page, or click Choose files.
- Choose the direction and standard, T→S to turn Traditional into Simplified or S→T for the reverse.
- Check the encoding and the preview on the card to make sure the headers and data are readable.
- 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.