Keyword Research Templates: 6 Free SEO Planning Workbooks

Free SEO & GEO resources, 6 templates

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.

Keyword Research Toolkit

Keyword Research Toolkit preview

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.

How the connection works

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

3templates on Labs: Ranked Keywordsdataforseo_labs/google/ranked_keywords/live
2templates on Labs: Keyword Overviewdataforseo_labs/google/keyword_overview/live
1template on SERP API: Google Organicserp/google/organic/live/advanced

What 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.

Step 1, template 01

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.

Step 2, template 02

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.

Step 3, template 03

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.

Step 4, template 04

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.

Step 5, template 05

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.

Step 6, template 06

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.

1. Pull the dataEach template names the exact DataForSEO endpoint and includes an example request. Labs, SERP, On-Page, Backlinks and AI Optimization (LLM Mentions) are all covered.
2. Run one commandThe included dataforseo_import.py turns the saved JSON response into the template's input CSV. It runs offline and never touches your credentials.
3. Paste and decideAdd the business inputs the API can't know, paste at Workspace cell A13, and the dashboard, checks and action list update.
Template DataForSEO source Columns it fills for you
Keyword Prioritization Template Labs: Keyword Overview
dataforseo_labs/google/keyword_overview/live
Keyword, Monthly searches
Keyword Mapping Template Labs: Ranked Keywords
dataforseo_labs/google/ranked_keywords/live
Keyword, Target URL, Search intent, Monthly searches
SERP Overlap Keyword Clustering Template SERP API: Google Organic
serp/google/organic/live/advanced
Query A, Query B, Unique URLs A, Unique URLs B, Shared URLs, Review cutoff
Keyword Gap Analysis Template Labs: Ranked Keywords
dataforseo_labs/google/ranked_keywords/live
Keyword, Monthly searches, Own organic rank
Search Seasonality Planner Labs: Keyword Overview
dataforseo_labs/google/keyword_overview/live
Keyword, Month number, Searches in month, 12-month searches
SEO Visibility Score Calculator Labs: Ranked Keywords
dataforseo_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.

Complete SEO & GEO Toolkit

All 40 templates and the field handbook in one download.

Jourdan Rombough

Built by Jourdan Rombough, technical SEO and GEO consultant. About Jourdan or see SEO services.

More on digital marketing in our blog

See all posts