Keyword Research Template: Columns, Example, and Free Setup
A keyword research template that actually drives decisions: the columns to include, a priority formula, a worked example, and how to turn it into a plan.
A keyword research template is only useful if it ends in a decision: this keyword, on this page, at this priority. Most free templates give you columns to fill and stop there, so you end up with a tidy spreadsheet and no plan. This one is built to end in a plan.
Below is the column structure that drives decisions, a simple priority formula, a filled-in example so you can see it working, and the one column most templates leave out — the one that stops two of your pages from fighting each other in search. Grab the template, then use it alongside the keyword research method that fills it.
What the template includes
A working template needs columns for capturing data, judging it, and deciding what to do. Group them that way:
| Column | Type | Why it’s there |
|---|---|---|
| Keyword | Capture | The exact phrase you’re evaluating |
| Search volume | Capture | Rough size of the opportunity |
| Keyword difficulty | Capture | Can you realistically rank? |
| CPC | Capture | A proxy for commercial value |
| Search intent | Judge | Informational, commercial, transactional, navigational |
| SERP format | Judge | What page type already ranks (guide, tool, listicle) |
| Priority score | Decide | Your ranking of what to do first |
| Assigned page / URL | Decide | Which single page will target this keyword |
| Status | Decide | Idea, briefed, published |
| Notes | Decide | SERP observations, gaps to exploit |
Keep capture, judge, and decide visually separated. The point of the template is to move every row left-to-right from raw keyword to a committed page.
The column most templates skip: Assigned Page
The “Assigned page / URL” column is what turns a keyword list into a keyword map. Every keyword should map to exactly one page. When two rows point at the same URL, you merge them; when one keyword could justify its own page, you give it one.
This is how you prevent keyword cannibalization — two of your own pages competing for the same term and splitting your ranking strength. Most downloadable templates omit this column, which is exactly why so many sites end up with three thin posts targeting near-identical keywords. Fill this column and the cannibalization problem mostly solves itself.
A priority score you can actually compute
A “priority” column with no method just becomes a gut feeling. Score each keyword on three axes, 1–3, and multiply:
- Opportunity (1–3): search volume and number of related terms it covers.
- Winnability (1–3): how realistic ranking is, from difficulty and your site’s authority.
- Value (1–3): how close the keyword is to a sign-up, lead, or sale.
Priority = Opportunity × Winnability × Value (range 1–27). Sort descending and you have a publishing order, not a wish list. A high-volume keyword you can’t win (winnability 1) correctly drops below a smaller keyword you can.
A worked example
Here is the template in use for three keywords in this cluster:
| Keyword | Vol | KD | Intent | SERP format | O | W | V | Priority | Assigned page |
|---|---|---|---|---|---|---|---|---|---|
| how to do keyword research | 11,510 | med | Informational | how-to guides | 3 | 3 | 2 | 18 | /blog/how-to-do-keyword-research |
| keyword research template | 590 | low | Commercial | templates | 2 | 3 | 3 | 18 | /blog/keyword-research-template |
| keyword research tools | 20,740 | high | Commercial | tool pages | 3 | 1 | 3 | 9 | /blog/keyword-research-tools |
Notice the result: the 20,740-volume “tools” keyword scores below the 590-volume “template” keyword, because its SERP is dominated by tool products a content page can’t easily beat. The formula stops volume from hijacking your roadmap.
How to use the template, step by step
- Paste your raw keywords into the Keyword column (export from your tool or the keyword research tools you use).
- Fill capture columns: volume, difficulty, CPC.
- Judge each row: label intent, and note the SERP format after a quick look at page one.
- Score Opportunity, Winnability, and Value; let the Priority column calculate.
- Assign each keyword to one page in the Assigned Page column. Merge duplicates.
- Sort by Priority. The top rows are your next briefs.
- Update Status as pages move from idea to briefed to published.
Common mistakes with keyword templates
- Collecting without deciding. A filled sheet with no Assigned Page column is data, not a plan.
- One keyword on several pages. The fastest route to cannibalization. Enforce one keyword, one page.
- Scoring on volume alone. Without winnability, you queue keywords you can’t rank for.
- Never updating it. The template is a living map. Revisit quarterly as rankings and intent shift.
When a spreadsheet is enough — and when it isn’t
A template handles research and mapping for a site with up to a few hundred target keywords. Beyond that, or when several people edit at once, a dedicated tool with clustering and live metrics saves time. The logic stays the same; only the storage changes. For small and mid-size sites, the spreadsheet is not a downgrade — it is the clearest place to make the call.
FAQ
What columns should a keyword research template have?
At minimum: keyword, search volume, keyword difficulty, CPC, search intent, SERP format, a priority score, an assigned page/URL, status, and notes. The assigned-page column is what turns the list into a map.
Is a Google Sheets or Excel template better?
Either works; the columns matter more than the format. Use Google Sheets for easy sharing and collaboration, Excel if your team already lives there.
How do I prioritize keywords in the template?
Score each on opportunity, winnability, and value (1–3) and multiply for a single priority number, then sort. This keeps high-volume but unwinnable keywords from topping the list.
How is a keyword research template different from keyword mapping?
The template is the spreadsheet; keyword mapping is the act of assigning each keyword to one page within it. The Assigned Page column is where mapping happens.
Conclusion
A keyword research template earns its place when it ends in decisions: one keyword, one page, in priority order. Use the capture–judge–decide columns, compute priority instead of guessing it, and fill the Assigned Page column to keep your own pages from competing.
Download the template, fill it using how to do keyword research, and check your work against the keyword research checklist before you start writing.