Free SEO Keyword Mapping Template
Turn your keyword research into a clear content plan. This free keyword mapping template assigns every target keyword to a single page — so you stop pages competing with each other and always know what to write next.
Opens in Excel, Google Sheets or Numbers. 10 ready-made columns.
One keyword, one page
Prevents keyword cannibalisation by giving every keyword a single home.
Prioritised by demand
Sort by search volume and intent so you work on what matters most first.
Your whole plan in one sheet
Keywords, pages, status and notes together — no more scattered docs.
What is inside the template
The template is a ready-to-use spreadsheet with ten columns and a few example rows to show you how it works. Delete the examples and fill in your own keywords.
Target Keyword
The primary keyword the page should rank for. One keyword (or tight cluster) per row.
Monthly Search Volume
Estimated monthly searches, so you can prioritise by demand.
Search Intent
Informational, Commercial, Transactional or Navigational — match the page to the intent.
Target Page URL
The single page that owns this keyword. This is what prevents keyword cannibalisation.
Page Title (H1)
The working headline for the page, built around the target keyword.
Content Type
Landing page, blog post, tool page, resource — helps you plan the format.
Priority
High / Medium / Low, so you always know what to work on next.
Current Ranking
Where you rank today. Leave blank for brand-new pages.
Status
New, Planned, Optimising, Published — track progress at a glance.
Notes
Anything else: internal links to add, competitors to beat, ideas to remember.
How to use the keyword mapping template
- 1
List your keywords
Drop every keyword you are targeting into the Target Keyword column. Pull them from your keyword research, Search Console, or our AI Keyword Ideas tool.
- 2
Add volume and intent
For each keyword, record the estimated monthly search volume and the search intent. This is where you decide what deserves a page and what does not.
- 3
Map one keyword to one page
Assign each keyword a single Target Page URL. If two keywords mean the same thing, map them to the same page — never split them across competing pages.
- 4
Prioritise and track
Set a priority, note the current ranking, and update the status as you write and optimise. Your whole content plan now lives in one sheet.
Fill your template faster with our free tools
The template is just the framework — use these free tools to populate it with real keywords, volumes and priorities.
Keyword mapping template — FAQ
What is a keyword mapping template?
A keyword mapping template is a simple spreadsheet that assigns each of your target keywords to a specific page on your website. It stops two pages competing for the same keyword (cannibalisation), makes sure every important keyword has a home, and turns your keyword research into a clear content plan.
How do I use this SEO keyword mapping template?
Download the CSV, open it in Excel, Google Sheets or Numbers, then fill one row per target keyword: the keyword, its search volume and intent, the single page that should rank for it, and a priority. Update the status column as you create and optimise each page.
Is the template really free?
Yes. It is a free CSV download with no sign-up and no email required. Open it in any spreadsheet app and adapt the columns to suit your workflow.
Why is keyword mapping important for SEO?
Without a keyword map it is easy to accidentally target the same keyword with several pages, which splits your ranking signals and confuses search engines. Mapping each keyword to one page concentrates your authority, improves internal linking, and makes your content strategy far easier to manage.