Your template, ready
Download it and open the “Example” tab first: you’ll see how to fill it in before you start.
We’ve received your request. We’ll review the information and contact you with the next step as soon as possible.
Keyword research template: find keywords and group them by intent
Free keyword research template in Excel: a spreadsheet to list your keywords, group them by intent and know which page to create, with a filled-in example.
The template in figures
What the keyword research template includes
From a list of searches to groups of keywords with the same intent, each with its own page.
The usual columns
Keyword, monthly searches, difficulty, what the searcher wants, topic, and the page that already answers it. The same metrics used by SEO tools.
Grouping by search intent
Searches that return the same Google results share intent: they go in the same group and on the same page. You write the same group name in their rows and the sheet joins them.
A summary by group
Your groups appear at the top from most to fewest searches, with the main keyword, what the searcher wants, what to create and whether you already have a page.
Create or improve
If a group already has a page, the sheet says “Improve”; if not, “Create”. One page per group: that way they don’t compete with each other on Google.
How to do keyword research in six steps
The method used in the template, with a completed example for a payroll firm.
Open a keyword research tool
Google Ads Keyword Planner is free with an account; Semrush, Ahrefs or Ubersuggest work too. Type in what you sell and copy the real searches it returns, not the ones you think people search for.
Add what Search Console already brings you
The queries you already rank for on Google are the first ones to work on.
Enter the volume
The monthly searches for each keyword, exactly as the tool gives them. They are what sorts the groups.
Mark the intent
Whether the person searching wants to learn something, compare options, or is already ready to buy or hire.
Group by intent
Search each keyword on Google: if two return the same results, they share intent. Give them the same group and they will have a single page.
Look at the groups
The sheet sorts them by search volume and tells you the main keyword, what to create and what to improve. Start with the buy-or-hire topics.
Frequently asked questions about keyword research
Answers to your most common questions
What is a keyword research template for?
To decide which articles and pages to write and in what order, choose the keyword for each page’s title and URL, stop two of your pages competing for the same thing on Google, and separate what brings customers from what only brings visits.
What is keyword research?
It is keyword research: finding out what your customer searches for on Google, how often, and with what intent, in order to decide which pages and articles to write.
How do you do keyword research step by step?
Take your keywords from a keyword research tool and from Search Console, with their monthly searches; mark the intent of each one, group the ones that return the same Google results and decide which page answers each group. The template follows these steps.
What is search intent?
What the searcher wants: to learn something, compare options, or buy (a product or service). Two searches with the same intent are answered on the same page; searches with different intents are answered on different pages.
How are keywords grouped?
By search intent: if searching two keywords returns the same Google results (or almost), they go together. In the template you just write the same group in both.
Where can I find search volume data?
From Google Ads Keyword Planner, which is free with an account, or from any SEO tool. The queries you already rank for are in Search Console.
What do I need to use the template?
Excel and your list of searches. It comes with instructions and a completed example.


