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’s “Example” tab, completed using the case of a payroll firm.

The template in figures

300 keywords per sheet
3 intents: learn, compare and buy
1 one page per group, so you don’t compete with yourselves
Leave us these three details and the download will appear right here, instantly.
Name *
Business email *
Company *

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.