Last Updated on
The first time I encountered this problem, I actually re-downloaded the file 3-4 times to make sure the file was not corrupted (silly me huh).
Let me show you how to open the file (or import the file I should say) so it will display these characters correctly.
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”
Step 2: Open the CSV file and the Text Import Wizard (image below) will pop up.
Step 3: Select “Unicode (UTF-8). Notice the preview will change to something readable.
Step 4: In Step 2, select “comma”. Notice now each item is separated in each cell instead of lumped together.
Step 5: Click finish and it’s all done.
Readable Chinese / Japanese encoding CSV file from GWMT
Now you have a readable import of the CSV file from GWMT!
Watch other Google Search Console guide videos