Free SEO Templates: The Complete SEO & GEO Toolkit (40 Spreadsheets)

Free SEO & GEO resources

Free SEO Templates: The Complete SEO & GEO Toolkit (40 Spreadsheets)

All 40 Optimization Theory templates in one download: working Excel workbooks with dashboards and worked examples, PDF field guides (9 to 11 pages each), blank and worked CSV templates, and DataForSEO import scripts.

  • 40 Excel workbooks with dashboards
  • 40 PDF field guides
  • Blank and worked CSV templates
  • DataForSEO import scripts

Free, no email required. Version 3.0, updated November 2026.

OT-SEO-GEO-Toolkit

Complete SEO and GEO toolkit preview

All 40 templates connect to the DataForSEO API

Five DataForSEO API families feed the toolkit. Every template includes its endpoint, an example request and an offline import script.

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

17templates on On-Page APIon_page/task_post
8templates on Labs: Ranked Keywordsdataforseo_labs/google/ranked_keywords/live
7templates on Labs: Keyword Overviewdataforseo_labs/google/keyword_overview/live
4templates on AI Optimization: LLM Mentionsai_optimization/llm_mentions/search_mentions/live
2templates on SERP API: Google Organicserp/google/organic/live/advanced
1template on Backlinks APIbacklinks/backlinks/live
1template on SERP API: Google Mapsserp/google/maps/live/advanced

Working tools, not blank grids

Most free SEO templates are blank grids with a logo on top. These are working tools: every workbook has a dashboard, automatic checks, colour-coded results, an action list and a realistic worked example, so you can see what good output looks like before you paste in your own data.

The toolkit covers six areas of the job: keyword research, site migrations, technical SEO, content, AI visibility and GEO, and the business side of SEO. Each template answers one specific decision, and they're designed to hand off to each other.

Built to run on DataForSEO

Every one of the 40 templates is designed around a DataForSEO endpoint, with an example request, step-by-step instructions and an offline import script in its Automation folder.

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.
See the DataForSEO endpoint behind each template
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
Site Migration URL Inventory Template On-Page API
on_page/task_post
Page URL
Redirect Mapping Template On-Page API
on_page/task_post
Old URL, Source HTTP status, Final canonical URL
SEO Migration Checklist On-Page API
on_page/task_post
Audit trail; checks stay manual
Post-Migration SEO Monitoring Template Labs: Ranked Keywords
dataforseo_labs/google/ranked_keywords/live
Audit trail; checks stay manual
Indexability Audit Template On-Page API
on_page/task_post
Page URL, HTTP status, Declared canonical
Hreflang Audit Template On-Page API
on_page/task_post
Page URL
Technical SEO Prioritization Template On-Page API
on_page/task_post
Audit trail; checks stay manual
Crawl Budget Analysis Template On-Page API
on_page/task_post
Audit trail; checks stay manual
Core Web Vitals Tracker On-Page API
on_page/task_post
Page URL
Internal Linking Opportunity Template On-Page API
on_page/task_post
Source page
XML Sitemap Audit Template On-Page API
on_page/task_post
Page URL, Listed in sitemap, HTTP status, Canonical URL
Schema Markup Audit Template On-Page API
on_page/task_post
Page URL
SEO Content Brief Template Labs: Keyword Overview
dataforseo_labs/google/keyword_overview/live
Keyword
Content Audit Template On-Page API
on_page/task_post
Page URL
Content Decay Analysis Template Labs: Ranked Keywords
dataforseo_labs/google/ranked_keywords/live
Page URL
Keyword Cannibalization Checker Template Labs: Ranked Keywords
dataforseo_labs/google/ranked_keywords/live
Keyword, Landing page A
SEO Content Calendar Template Labs: Keyword Overview
dataforseo_labs/google/keyword_overview/live
Keyword
Title Tag CTR Test Calculator On-Page API
on_page/task_post
Page URL
AI Prompt Research Template Labs: Keyword Overview
dataforseo_labs/google/keyword_overview/live
Keyword, Monthly searches
AI Citation Tracker AI Optimization: LLM Mentions
ai_optimization/llm_mentions/search_mentions/live
Observation ID, Prompt or query, Platform / model
AI Share of Voice Calculator AI Optimization: LLM Mentions
ai_optimization/llm_mentions/search_mentions/live
Audit trail; checks stay manual
Answer Evidence Audit Template On-Page API
on_page/task_post
Page URL
Brand Entity Consistency Audit AI Optimization: LLM Mentions
ai_optimization/llm_mentions/search_mentions/live
Observed source URL
AI Referral Traffic Tracker AI Optimization: LLM Mentions
ai_optimization/llm_mentions/search_mentions/live
Landing page
SEO Forecast Template Labs: Keyword Overview
dataforseo_labs/google/keyword_overview/live
Keyword, Monthly searches
SEO ROI Calculator Labs: Ranked Keywords
dataforseo_labs/google/ranked_keywords/live
Audit trail; checks stay manual
SEO Split Test Calculator Labs: Ranked Keywords
dataforseo_labs/google/ranked_keywords/live
Audit trail; checks stay manual
Link Reclamation Template Backlinks API
backlinks/backlinks/live
Referring page, Linked target, Provider reports lost, Provider reports broken, Target HTTP status
Local Rank Grid Tracker SERP API: Google Maps
serp/google/maps/live/advanced
Grid point ID, Keyword, Business CID, Observed maps rank
Ecommerce SEO Prioritization Template Labs: Keyword Overview
dataforseo_labs/google/keyword_overview/live
Page URL, Keyword, Monthly searches
Programmatic SEO Checklist On-Page API
on_page/task_post
Page URL
DataForSEO Cost Calculator SERP API: Google Organic
serp/google/organic/live/advanced
Audit trail; checks stay manual
SEO Client Onboarding Checklist On-Page API
on_page/task_post
Audit trail; checks stay manual
SEO Roadmap Template On-Page API
on_page/task_post
Audit trail; checks stay manual

Keyword Research Toolkit

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. See the keyword research toolkit.

01Keyword Prioritization TemplateLabs: Keyword Overview

Rank every keyword by the profit it could add per hour of work, not by search volume alone.

Download

02Keyword Mapping TemplateLabs: Ranked Keywords

Assign every keyword to exactly one URL and catch conflicting assignments before they become cannibalization.

Download

03SERP Overlap Keyword Clustering TemplateSERP API: Google Organic

Decide whether two keywords belong on one page or two by measuring how much their Google results overlap.

Download

04Keyword Gap Analysis TemplateLabs: Ranked Keywords

Find the queries your competitors rank for that you don't, and size each gap in potential clicks.

Download

05Search Seasonality PlannerLabs: Keyword Overview

Turn monthly search volume into a seasonal index, season-adjusted click targets and a publish-by month.

Download

06SEO Visibility Score CalculatorLabs: Ranked Keywords

Weight rankings by search volume and CTR to see real visibility gains and losses across a fixed keyword set.

Download

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. See the SEO migration toolkit.

07Site Migration URL Inventory TemplateOn-Page API

Inventory every legacy URL with its traffic, profit and links, assign a destination and catch risky retirements.

Download

08Redirect Mapping TemplateOn-Page API

Map every old URL to its new home and verify each redirect: one permanent hop, a 200 page, no noindex, matching canonical.

Download

09SEO Migration ChecklistOn-Page API

Every pre-launch, launch-day and post-launch control with an owner, evidence and automatic launch-blocker flags.

Download

10Post-Migration SEO Monitoring TemplateLabs: Ranked Keywords

Compare each migrated segment with an untouched control so you can tell real migration loss from seasonality.

Download

11Indexability Audit TemplateOn-Page API

Check status, robots, noindex and canonical on every page you want indexed, then see exactly what to fix first.

Download

12Hreflang Audit TemplateOn-Page API

Validate every hreflang relationship: alternate status, self-reference, return tags, canonical match and locale codes.

Download

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. See the technical SEO toolkit.

13Technical SEO Prioritization TemplateOn-Page API

Turn a technical SEO audit into a ranked fix queue by recovered clicks, profit and profit per hour of dev time.

Download

14Crawl Budget Analysis TemplateOn-Page API

Group verified Googlebot requests by URL pattern, measure crawl waste and pick the right fix for each pattern.

Download

15Core Web Vitals TrackerOn-Page API

Log p75 LCP, INP and CLS by URL and device, test against Google's good thresholds and see what fails.

Download

16Internal Linking Opportunity TemplateOn-Page API

Score each source-to-target internal link by expected visits and contribution per hour, then verify it went live.

Download

17XML Sitemap Audit TemplateOn-Page API

Reconcile sitemap URLs against status, canonical, robots and noindex to see what to add, remove or fix.

Download

18Schema Markup Audit TemplateOn-Page API

Check presence, syntax, required fields, visible-content match and policy for every structured data type you ship.

Download

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. See the content SEO toolkit.

19SEO Content Brief TemplateLabs: Keyword Overview

A content brief built for Google and AI answers: real questions, original evidence, sources and a three-step approval workflow.

Download

20Content Audit TemplateOn-Page API

Score every URL by lost clicks, conversions and links, choose keep, refresh, merge or retire, and catch the risky calls.

Download

21Content Decay Analysis TemplateLabs: Ranked Keywords

Separate lost impressions, lower CTR and falling demand, so you refresh the pages that really decayed.

Download

22Keyword Cannibalization Checker TemplateLabs: Ranked Keywords

Find queries splitting clicks across two URLs, check whether intent really overlaps and decide whether to consolidate.

Download

23SEO Content Calendar TemplateLabs: Keyword Overview

Track owners, due dates and estimated vs completed hours, and flag overdue work automatically.

Download

24Title Tag CTR Test CalculatorOn-Page API

Compare two CTRs with a 95% interval and plain-English verdicts, so you don't ship a title change that was just noise.

Download

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. See the AI visibility & GEO toolkit.

25AI Prompt Research TemplateLabs: Keyword Overview

Turn real customer tasks and keywords into a weighted prompt panel for ChatGPT, Perplexity, Gemini and AI Overviews.

Download

26AI Citation TrackerAI Optimization: LLM Mentions

Log answers from ChatGPT, Perplexity, Gemini and AI Overviews, and measure your citation rate by platform.

Download

27AI Share of Voice CalculatorAI Optimization: LLM Mentions

Compare citation rate and share across competitor domains inside one fixed set of AI answers.

Download

28Answer Evidence Audit TemplateOn-Page API

Check every claim for a supporting source, original value, clarity and freshness, so AI answers can quote and cite it.

Download

29Brand Entity Consistency AuditAI Optimization: LLM Mentions

Compare your official brand facts with Wikidata, LinkedIn, GBP, Yelp and more, and log every correction request.

Download

30AI Referral Traffic TrackerAI Optimization: LLM Mentions

Measure sessions, conversion rate and contribution per session from ChatGPT, Perplexity, Gemini, Copilot and Claude.

Download

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. See the SEO business & delivery toolkit.

31SEO Forecast TemplateLabs: Keyword Overview

Project added clicks and contribution per keyword cluster with CTR, attainment and seasonality you can defend.

Download

32SEO ROI CalculatorLabs: Ranked Keywords

Turn incremental sessions into revenue, contribution, net return and a break-even month against real SEO costs.

Download

33SEO Split Test CalculatorLabs: Ranked Keywords

Estimate ratio-adjusted lift and difference-in-differences against matched control pages, with a pre-trend check.

Download

34Link Reclamation TemplateBacklinks API

Find lost and broken backlinks worth fixing and rank them by expected referrals per hour of outreach.

Download

35Local Rank Grid TrackerSERP API: Google Maps

Log rankings across a geo grid, see a colour heatmap and measure weighted top-3 coverage for any local keyword.

Download

36Ecommerce SEO Prioritization TemplateLabs: Keyword Overview

Rank product pages by potential orders, unit contribution and profit per hour, and catch out-of-stock or noindex SKUs.

Download

37Programmatic SEO ChecklistOn-Page API

QA every generated page for verified data, unique value, indexability, links and rendering before release.

Download

38DataForSEO Cost CalculatorSERP API: Google Organic

Estimate monthly DataForSEO API spend by endpoint from tasks, cycles, row pricing and retries before you run a job.

Download

39SEO Client Onboarding ChecklistOn-Page API

Track every access, definition and baseline export a new SEO engagement needs, with owners and blockers.

Download

40SEO Roadmap TemplateOn-Page API

Sequence 90 days of SEO and GEO work by weighted opportunity per hour, dependencies and acceptance criteria.

Download

Frequently asked questions

Do these templates work with DataForSEO?

Yes. Every template is built around a specific DataForSEO endpoint (Labs, SERP, On-Page, Backlinks or AI Optimization), with an example request, step-by-step instructions and an offline import script in its Automation folder.

Are these SEO templates really free?

Yes. No email, no account, no trial. Download the ZIP and use the templates for your own work or client work.

Do they work in Google Sheets and Excel?

Yes. They're XLSX files tested in Microsoft Excel, Google Sheets and LibreOffice Calc. Upload to Google Drive to use them in Sheets.

What's the difference between the toolkit and the category packs?

The complete toolkit contains all 40 templates. Each category pack contains just the six (or ten) templates for that area. The files are identical.

Is the example data real?

No. Every workbook uses data from Northbeam Outdoor, a fictional outdoor-gear retailer, so the examples are realistic without exposing anyone's real numbers.

Can I use these templates for clients?

Yes. Use and adapt them in client work. Please don't resell the templates themselves.

Jourdan Rombough

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

More on digital marketing in our blog

See all posts