How to Organize Search Query Data from Google Webmaster Tools in Excel
Google Webmaster Tools top Search Query data Is very Useful to Know the Top performing Keywords for your Site.You can always Export Your top Queries data from Google Webmaster tools into Excel for further analysis.
Sure you can download your Search Query data from Google webmaster Tools as a CSV File (Comma separated values) but On opening the Data is not Well arranged and it becomes quite difficult to analyze your data and perform Actions.
Here is a More productive way to Work With Your Google Webmaster Tools Search Query data.
1.Open Your Top search Query Data in Google Webmaster Tools and Copy the URL.
2.Open Microsoft Excel ,select data from the Navigation and click on “From Web” in the Top left Corner as shown below.
3.A pop Up window will Open in Excel.Paste the URL that You copied in Step 1.Your Google Webmaster Tools Panel Will open In the Excel Window.Select The tables that you Wish to Import by clicking on the Yellow Arrow on top Of the tables.After that Click import.
4.Next, Select an Entire column In Excel where You wish to Keep the data.It would Be better If you use Different Sheets For different Months.This will Keep your Search data organized.
After the import is complete your imported data will look far More organized ,with each Attribute neatly arranged in Columns.See the Screenshot Below
When the data is Exported do not Change any attribute or Do not Modify the columns.Whenever You Open the Excel Sheet,MS-excel will try to connect with Your Google webmaster Tools reports and Update the data for you Automatically.
See the following Video Demo below :
Do you Know anything Better ? Please share With us In Comments
Related Articles
- None Found
great information. but can u tell me the process to download and organize the whole list and not just the top 20.
John I am glad that You Liked the article. To download all Your search queries Click The Link “Download all Query Stats for this site”. You can also Select The months and Download the query stats as a CSV file.
How about storing different months – to be able to create tend graphs for each keyword?
Good point Ivan. Never really Gave it a thought. Will try it soon and Update you !!
Great info. Thanks a lot, I did not know this method. I tried to download a table, and it was a mess. This way, I can keep track of the keywords much better.
Thanks.
@Chris : Glad you liked the resource
How can do it with opennoffice calc ?
@nus : Sorry but i do not use open office. I love Microsoft :)
Pretty darn laborious. There must be an easier way….. Or at least I should say, I wish thee was an easier way.
Oh wow! Hey…. this DOES work well! Not too laborious at all actual. Bless you for sharing this. The CSV import to excel has been driving me crazy! Many thanks!
Thanks Anthony. Good to know that it worked out well
Yes it really works great. You have the ONLY solution for this out there. Been searching for a method to organize the CSV data file that Google Webmaster Tools spits out but all the methods tried still results in a mess of data that you can’t really do anything with. This works beautifully :-) Very nice of you to share it!
@anthony glad that you liked it so much. Its our pleasure that we could deliver what you want, maybe not always, but as many times as possible. Thanks again.
I have been using Excel for years almost everyday and never knew about this feature. I love the fact that the data updates when you open again. This is one of the neatest features I have seen… now I am going to try to connect to Google Analytics :)
@Ben thanks for your kind words man.