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.

Ie after you reopen with MS Excel it looks like this

**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

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.

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.