How to open a CSV file containing foreign characters e.g. Chinese

The default Excel conversion from CSV containing non english characters doesn’t often work.

This is what we suggest.

  1.  Download and install Libre Office from here http://www.libreoffice.org/
  2. Open Libre Office and click ‘Spreadsheet’
  3. Click Open and select your CSV file
  4. On the following screen make sure the following options are ticked
    1. Seperated by > Comma
    2. Character Set > Unicode (UTF-8)
    3. Language > Language you require e.g. chinese

See the screen shot below

libreoffice

That should work for you.

 

Category Tags: Data Analysis