Free SEO Templates: The Complete SEO & GEO Toolkit (40 Spreadsheets)
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.

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.
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
on_page/task_postdataforseo_labs/google/ranked_keywords/livedataforseo_labs/google/keyword_overview/liveai_optimization/llm_mentions/search_mentions/liveserp/google/organic/live/advancedbacklinks/backlinks/liveserp/google/maps/live/advancedWorking 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.
dataforseo_import.py turns the saved JSON response into the template's input CSV. It runs offline and never touches your credentials.See the DataForSEO endpoint behind each template
| 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 |
| Site Migration URL Inventory Template | On-Page APIon_page/task_post |
Page URL |
| Redirect Mapping Template | On-Page APIon_page/task_post |
Old URL, Source HTTP status, Final canonical URL |
| SEO Migration Checklist | On-Page APIon_page/task_post |
Audit trail; checks stay manual |
| Post-Migration SEO Monitoring Template | Labs: Ranked Keywordsdataforseo_labs/google/ranked_keywords/live |
Audit trail; checks stay manual |
| Indexability Audit Template | On-Page APIon_page/task_post |
Page URL, HTTP status, Declared canonical |
| Hreflang Audit Template | On-Page APIon_page/task_post |
Page URL |
| Technical SEO Prioritization Template | On-Page APIon_page/task_post |
Audit trail; checks stay manual |
| Crawl Budget Analysis Template | On-Page APIon_page/task_post |
Audit trail; checks stay manual |
| Core Web Vitals Tracker | On-Page APIon_page/task_post |
Page URL |
| Internal Linking Opportunity Template | On-Page APIon_page/task_post |
Source page |
| XML Sitemap Audit Template | On-Page APIon_page/task_post |
Page URL, Listed in sitemap, HTTP status, Canonical URL |
| Schema Markup Audit Template | On-Page APIon_page/task_post |
Page URL |
| SEO Content Brief Template | Labs: Keyword Overviewdataforseo_labs/google/keyword_overview/live |
Keyword |
| Content Audit Template | On-Page APIon_page/task_post |
Page URL |
| Content Decay Analysis Template | Labs: Ranked Keywordsdataforseo_labs/google/ranked_keywords/live |
Page URL |
| Keyword Cannibalization Checker Template | Labs: Ranked Keywordsdataforseo_labs/google/ranked_keywords/live |
Keyword, Landing page A |
| SEO Content Calendar Template | Labs: Keyword Overviewdataforseo_labs/google/keyword_overview/live |
Keyword |
| Title Tag CTR Test Calculator | On-Page APIon_page/task_post |
Page URL |
| AI Prompt Research Template | Labs: Keyword Overviewdataforseo_labs/google/keyword_overview/live |
Keyword, Monthly searches |
| AI Citation Tracker | AI Optimization: LLM Mentionsai_optimization/llm_mentions/search_mentions/live |
Observation ID, Prompt or query, Platform / model |
| AI Share of Voice Calculator | AI Optimization: LLM Mentionsai_optimization/llm_mentions/search_mentions/live |
Audit trail; checks stay manual |
| Answer Evidence Audit Template | On-Page APIon_page/task_post |
Page URL |
| Brand Entity Consistency Audit | AI Optimization: LLM Mentionsai_optimization/llm_mentions/search_mentions/live |
Observed source URL |
| AI Referral Traffic Tracker | AI Optimization: LLM Mentionsai_optimization/llm_mentions/search_mentions/live |
Landing page |
| SEO Forecast Template | Labs: Keyword Overviewdataforseo_labs/google/keyword_overview/live |
Keyword, Monthly searches |
| SEO ROI Calculator | Labs: Ranked Keywordsdataforseo_labs/google/ranked_keywords/live |
Audit trail; checks stay manual |
| SEO Split Test Calculator | Labs: Ranked Keywordsdataforseo_labs/google/ranked_keywords/live |
Audit trail; checks stay manual |
| Link Reclamation Template | Backlinks APIbacklinks/backlinks/live |
Referring page, Linked target, Provider reports lost, Provider reports broken, Target HTTP status |
| Local Rank Grid Tracker | SERP API: Google Mapsserp/google/maps/live/advanced |
Grid point ID, Keyword, Business CID, Observed maps rank |
| Ecommerce SEO Prioritization Template | Labs: Keyword Overviewdataforseo_labs/google/keyword_overview/live |
Page URL, Keyword, Monthly searches |
| Programmatic SEO Checklist | On-Page APIon_page/task_post |
Page URL |
| DataForSEO Cost Calculator | SERP API: Google Organicserp/google/organic/live/advanced |
Audit trail; checks stay manual |
| SEO Client Onboarding Checklist | On-Page APIon_page/task_post |
Audit trail; checks stay manual |
| SEO Roadmap Template | On-Page APIon_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.
02Keyword Mapping TemplateLabs: Ranked Keywords
Assign every keyword to exactly one URL and catch conflicting assignments before they become cannibalization.
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.
04Keyword Gap Analysis TemplateLabs: Ranked Keywords
Find the queries your competitors rank for that you don't, and size each gap in potential clicks.
05Search Seasonality PlannerLabs: Keyword Overview
Turn monthly search volume into a seasonal index, season-adjusted click targets and a publish-by month.
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.
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.
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.
09SEO Migration ChecklistOn-Page API
Every pre-launch, launch-day and post-launch control with an owner, evidence and automatic launch-blocker flags.
10Post-Migration SEO Monitoring TemplateLabs: Ranked Keywords
Compare each migrated segment with an untouched control so you can tell real migration loss from seasonality.
11Indexability Audit TemplateOn-Page API
Check status, robots, noindex and canonical on every page you want indexed, then see exactly what to fix first.
12Hreflang Audit TemplateOn-Page API
Validate every hreflang relationship: alternate status, self-reference, return tags, canonical match and locale codes.
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.
14Crawl Budget Analysis TemplateOn-Page API
Group verified Googlebot requests by URL pattern, measure crawl waste and pick the right fix for each pattern.
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.
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.
17XML Sitemap Audit TemplateOn-Page API
Reconcile sitemap URLs against status, canonical, robots and noindex to see what to add, remove or fix.
18Schema Markup Audit TemplateOn-Page API
Check presence, syntax, required fields, visible-content match and policy for every structured data type you ship.
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.
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.
21Content Decay Analysis TemplateLabs: Ranked Keywords
Separate lost impressions, lower CTR and falling demand, so you refresh the pages that really decayed.
22Keyword Cannibalization Checker TemplateLabs: Ranked Keywords
Find queries splitting clicks across two URLs, check whether intent really overlaps and decide whether to consolidate.
23SEO Content Calendar TemplateLabs: Keyword Overview
Track owners, due dates and estimated vs completed hours, and flag overdue work automatically.
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.
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.
26AI Citation TrackerAI Optimization: LLM Mentions
Log answers from ChatGPT, Perplexity, Gemini and AI Overviews, and measure your citation rate by platform.
27AI Share of Voice CalculatorAI Optimization: LLM Mentions
Compare citation rate and share across competitor domains inside one fixed set of AI answers.
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.
29Brand Entity Consistency AuditAI Optimization: LLM Mentions
Compare your official brand facts with Wikidata, LinkedIn, GBP, Yelp and more, and log every correction request.
30AI Referral Traffic TrackerAI Optimization: LLM Mentions
Measure sessions, conversion rate and contribution per session from ChatGPT, Perplexity, Gemini, Copilot and Claude.
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.
32SEO ROI CalculatorLabs: Ranked Keywords
Turn incremental sessions into revenue, contribution, net return and a break-even month against real SEO costs.
33SEO Split Test CalculatorLabs: Ranked Keywords
Estimate ratio-adjusted lift and difference-in-differences against matched control pages, with a pre-trend check.
34Link Reclamation TemplateBacklinks API
Find lost and broken backlinks worth fixing and rank them by expected referrals per hour of outreach.
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.
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.
37Programmatic SEO ChecklistOn-Page API
QA every generated page for verified data, unique value, indexability, links and rendering before release.
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.
39SEO Client Onboarding ChecklistOn-Page API
Track every access, definition and baseline export a new SEO engagement needs, with owners and blockers.
40SEO Roadmap TemplateOn-Page API
Sequence 90 days of SEO and GEO work by weighted opportunity per hour, dependencies and acceptance criteria.
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.
Built by Jourdan Rombough, technical SEO and GEO consultant. About Jourdan.






