Salesforce CSV How to retain Chinese Characters

Sales Force CSV work around for Chinese characters. This Work around may work if you need  to do Japanese / Korean etc.

Scenario

Microsoft Excel xls file saved as file as a CSV looks ok, however when close and open the CSV file up again it looks different with something else.

MARUBENI	UNIQLO	China (CH)	香港
MARUBENI	UNIQLO	China (CH)	香港
MARUBENI	UNIQLO	China (CH)	香港

Ie after you reopen with MS Excel it looks like this

MARUBENI	UNIQLO	China (CH)	??
MARUBENI	UNIQLO	China (CH)	??
MARUBENI	UNIQLO	China (CH)	??

**I have tried changing system language local in the OS, still does the same.**

I used OpenOffice Calc to open the XLS file to text CSV,

However when I open the file CSV file saved with OppenOffice in Excel, it still looks like this

MARUBENI	UNIQLO	China (CH)	香港
MARUBENI	UNIQLO	China (CH)	香港
MARUBENI	UNIQLO	China (CH)	香港

The Trick is :

Open the CSV file you just created with OpenOffice in Notepad. Then save the file as a CSV ( encoding as UTF-8 ) – you can save as something else or replace.

 

 When you open theCSV file with MS Excel, you should be able to retain the characters.

MARUBENI	UNIQLO	China (CH)	香港
MARUBENI	UNIQLO	China (CH)	香港
MARUBENI	UNIQLO	China (CH)	香港

Ps, took me 2 days to figure out. Site depends on Banner adds. Googling didnt help. Now hopefully googleing will help get you to this page.