Convert XLS to CSV in Excel

T

Tony Liu

Hi,

When I convert Excel file from xls format to csv format, all Chinese
characters cannot display correctly. Why? How to solve it?

Computer Environment:
- Windows 2000 Pro (English, Default Locale: Trad. Chi.)
- Office 2000 (English)

Tony
 
R

rk_idiom

I haven't seen a better way to do this:

IN OFFICE 2000
1. Open Excel file.
2. Save the file as Unicode Text File xxx.txt.
3. Open the xxx.txt file in the Notepad.
4. Replace tab characters with comma (,) character. You can cut an
paste tab char into Replace box.
5. Save the file as UTF-8 xxx.csv file.
6. Open the xxx.csv file in an editor which does not understand
Unicode (VIM or Emacs will do). Take out first 3 bytes of the fil
(these are BOM chars looking like this: ).
7. Save the file

IN OFFICE XP
Office XP has a way to save the CSV file as UTF-8 directly from Excel
Do this and then do steps 6-7 above.

Regards,
Riz
 
Top