How To Open Chinese Or Japanese Encoding GWMT CSV Files?
If your site has international presence, most likely you have encountered some funny characters when opened the Google Webmaster Tools (GWMT) export file for Search Queries.
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 videosBack to Google Webmaster Tools Guide Home Page
- How To Track Keyword Ranking? - April 27, 2020
- Is Updating Old Content For SEO Worth It? - March 30, 2020
- What Is Remote Desktop Access (a.k.a RDP Or VPS) For SEO? - March 27, 2020
Leave a ReplyWant to join the discussion?
Feel free to contribute!