Keyword Research Templates: 6 Free SEO Planning Workbooks
Keyword Research Templates: 6 Free SEO Planning Workbooks
Six connected spreadsheets that take you from a raw keyword export to a ranked, mapped, season-aware plan: prioritization, keyword mapping, SERP clustering, gap analysis, seasonality and visibility tracking.
- 6 Excel workbooks with dashboards
- 6 PDF field guides
- Blank and worked CSV templates
- DataForSEO import scripts
Free, no email required. Version 3.0, updated November 2026.

Every Keyword Research template connects to DataForSEO
Each workbook names its endpoint, ships with an example request and converts the saved response with one command.
DataForSEO APILabs, SERP, On-Page, Backlinks and AI Optimization endpointsapi.dataforseo.com/v3/
Save the JSON responseYour untouched source of truth.response.json
Run one commandThe included script maps it to the template's columns.dataforseo_import.py import
Paste and decideDashboard, checks and action list update.Workspace!A13
dataforseo_labs/google/ranked_keywords/livedataforseo_labs/google/keyword_overview/liveserp/google/organic/live/advancedWhat this toolkit is for
Keyword research usually ends with a long export and a short attention span. The hard part isn't finding keywords; it's deciding which ones deserve a page, which page should own them, when to publish and how to tell whether it worked.
This keyword research toolkit splits that job into six decisions, each with its own workbook. They share the same layout and the same fictional example brand, so the output of one feeds the next: score opportunities, cluster them by SERP overlap, map each cluster to a URL, check what competitors cover that you don't, time it to seasonal demand, then track visibility across the set.
The 6 templates, in the order to use them
Work through them in order the first time. After that, most teams revisit the prioritization and visibility sheets monthly and the rest quarterly.
Keyword Prioritization Template
Rank every keyword by the profit it could add per hour of work, not by search volume alone.
Which keywords deserve your next hours of work, ranked by the monthly profit each could add per hour invested, with every assumption visible and editable.
Keyword Mapping Template
Assign every keyword to exactly one URL and catch conflicting assignments before they become cannibalization.
Which single URL should own each keyword, and where your map assigns the same query to two different pages.
SERP Overlap Keyword Clustering Template
Decide whether two keywords belong on one page or two by measuring how much their Google results overlap.
Whether two queries should be targeted by one page or separate pages, based on how many ranking URLs their SERPs share.
Keyword Gap Analysis Template
Find the queries your competitors rank for that you don't, and size each gap in potential clicks.
Which competitor-ranked queries you have no coverage for, how big each opportunity is, and which ones need a new page.
Search Seasonality Planner
Turn monthly search volume into a seasonal index, season-adjusted click targets and a publish-by month.
When demand for each keyword peaks, how much to scale traffic expectations month by month, and when to start production so content is ranking before the peak.
SEO Visibility Score Calculator
Weight rankings by search volume and CTR to see real visibility gains and losses across a fixed keyword set.
Whether your visibility for a stable keyword set went up or down, and which keywords drove the change, measured in modeled clicks rather than average position.
Built to run on DataForSEO
Every template in the Keyword Research Toolkit is designed around a DataForSEO endpoint. Pull the data, convert it with the included script, add the inputs only you know, and paste.
dataforseo_import.py turns the saved JSON response into the template's input CSV. It runs offline and never touches your credentials.| Template | DataForSEO source | Columns it fills for you |
|---|---|---|
| Keyword Prioritization Template | Labs: Keyword Overviewdataforseo_labs/google/keyword_overview/live |
Keyword, Monthly searches |
| Keyword Mapping Template | Labs: Ranked Keywordsdataforseo_labs/google/ranked_keywords/live |
Keyword, Target URL, Search intent, Monthly searches |
| SERP Overlap Keyword Clustering Template | SERP API: Google Organicserp/google/organic/live/advanced |
Query A, Query B, Unique URLs A, Unique URLs B, Shared URLs, Review cutoff |
| Keyword Gap Analysis Template | Labs: Ranked Keywordsdataforseo_labs/google/ranked_keywords/live |
Keyword, Monthly searches, Own organic rank |
| Search Seasonality Planner | Labs: Keyword Overviewdataforseo_labs/google/keyword_overview/live |
Keyword, Month number, Searches in month, 12-month searches |
| SEO Visibility Score Calculator | Labs: Ranked Keywordsdataforseo_labs/google/ranked_keywords/live |
Keyword, Monthly searches, Current rank |
Each template page walks through its exact request, and each ZIP includes HOW-TO-USE-WITH-DATAFORSEO.txt, an example request file and the import script. Estimate costs first with the DataForSEO pricing calculator.
What's in every workbook
- Start Here: the decision it answers, a four-step setup and a colour key.
- Dashboard: KPI cards, a result breakdown or Top 10 chart, and an automatic action list of the rows that need attention.
- Workspace: the working table with dropdowns, Yes/No fields, range checks and colour-coded results.
- Delivery QA: a sign-off register that only counts a check as Verified with evidence, an owner and a date.
- Field Guide: every input defined and every formula written out in plain English.
Each ZIP also includes the PDF field guide, blank and worked CSV templates, and an offline script that turns saved DataForSEO API responses into the input CSV.
Frequently asked questions
What's the best free keyword research template?
One that ends in a decision, not a list. These templates score keywords by profit per hour, cluster them by real SERP overlap and map each cluster to one URL, so the output is a plan you can act on.
Do these keyword templates work in Google Sheets?
Yes. Upload any XLSX to Google Drive and open it with Google Sheets. Every formula uses functions supported by Excel, Google Sheets and LibreOffice.
Where does the keyword data come from?
Any keyword tool export works: Google Keyword Planner, Search Console, Semrush, Ahrefs or the DataForSEO API. Each ZIP includes a script that converts saved DataForSEO responses into the input CSV.
Do I need all six templates?
No. Each one stands alone. Most people start with the keyword prioritization and keyword mapping templates.
The other five toolkits
SEO Migration Toolkit
Everything a site migration needs to keep its traffic: a URL inventory, a redirect map with built-in QA, a launch checklist with blocker flags, control-adjusted post-launch monitoring, and indexability and hreflang audits.
Technical SEO Toolkit
Turn crawl findings into a ranked fix queue, then validate the work: fix prioritization, crawl budget and log analysis, Core Web Vitals, internal links, XML sitemaps and schema markup QA.
Content SEO Toolkit
Six free content SEO templates for the full content lifecycle: brief new pages for search and AI answers, audit and prune what exists, diagnose decay, fix cannibalization, schedule production and test titles honestly.
AI Visibility & GEO Toolkit
Measure and improve how AI answer engines see you: prompt research, an AI citation tracker, AI share of voice, an answer evidence audit, a brand entity audit and AI referral tracking.
SEO Business & Delivery Toolkit
The business side of SEO in ten workbooks: forecasting, ROI, split testing, link reclamation, local rank grids, ecommerce prioritization, programmatic SEO QA, API budgeting, client onboarding and a 90-day roadmap.
Built by Jourdan Rombough, technical SEO and GEO consultant. About Jourdan or see SEO services.






