One of the most important aspects of managing a blog or website is analyzing keyword data. You’ll find that everyone handles their keyword data differently based on their goals and perspective on SEO. No matter how you use your keyword data, you must have some knowledge about what keywords are bringing people to your site.

Since I mostly work in the blogging industry, as a ghost blogger for hire, I will discuss this topic as it pertains to bloggers. For business owners out there reading this, I’m confident my tips will help you too.

Spoiler Alert – if you don’t want to follow along with my text tutorial, scroll down to my video screen capture tutorial below.

How to Export Keyword Data from Google Search Console

For starters, you should already have an established Google Search Console account. If you do not have an account, then you’re going to have to head to their website and create an account. Follow their instructions to insert the code into your blog and wait until it starts propagating data.

When You First Log into Google Search Console

When you first log into your account, you’ll see the above screen. Typically the main screen is showing the “overview” section. For the purpose of this tutorial, please click on the performance tab located on the left-hand side of the screen.

I have the above performance tab set to “search type: web” and “date” last 12 months”. You can pick the date you want to evaluate, but I’ve found 12 months to be a helpful overview when first starting this process.

After you’ve done this once, you can then go to evaluate every 3 months, changing the “date: last 12 months” dropdown menu to 3 months (just click that little pencil icon beside that option in purple above).

Downloading the Right Keyword Data with Correct Date in Google Search Console

Since I’m focused on updating old blog posts and removing content, I tend to focus on 3 months while I revisit the results of how my SEO practices are helping my site advance. To put it bluntly, SEO wasn’t something I focused on when I first entered the blogging world in 2008. That’s a story for another day, though!

Final Thoughts on How to Export Keyword Data in Google Search Console

Now that you have the screen open, scroll down to see something that looks like the above screenshot. This is where you can evaluate your queries (keywords/phrases that people have searched & your site showed up in the search results). The clicks are how many people clicked and the impressions are how many times a page that uses that keyword was seen.

As shown above, friend finder is a popular keyword, I get 148 clicks, but have been shown over 15K times in search results. I’m not amazingly happy with that result, but using brands as a ranking method in search engines doesn’t work anyway.

Go one step below and you see that I’m relatively OK with the folios brand keywords – 142 clicks out of 770 and 113 clicks out of 642. Again, not the focus on my “niche” site but I’ve only started rebranding my focus in 2020.

You can click on each of the various options to evaluate the data, a tutorial for another day.

For the purpose of today, you’re going to be looking for the export button. This is located in the upper right-hand corner when you’re logged into your Google Search Console account. See below …

Whether you click to export in Google Sheets or download in Excel is completely up to you. I’m addicted to using Excel spreadsheets, and so I typically choose Download Excel but occasionally use Google Sheets when sharing data with team members. See the screen capture video below to see how it works when you download using either sheets or Excel.

That’s a wrap for today! I hope that you can use this video and screenshot tutorial on how to export keyword data in Google Search Console with ease. Knowing what keywords bring people to your site can help you narrow down your blogging niche to develop and write content that your audience enjoys reading.