Follow

Step by step guide to open (import) Chinese / Japanese encoding CSV

Step 1: Open Excel, select “DATA” tab then choose “From text” option under “Get External Data”

mceclip0.png

Step 2: Open the CSV file and the Text Import Wizard (image below) will pop up.

mceclip2.png

Step 3: Select “Unicode (UTF-8). Notice the preview will change to something readable.

mceclip3.png

Step 4: In Step 2, select “comma”. Notice now each item is separated in each cell instead of lumped together.

mceclip4.png

 

Step 5: Click finish and it’s all done.

mceclip5.png

Have more questions? Submit a request