The Coverage Map: A Topical Map Template That Measures Coverage
Every topical map template you can download answers one question: what should I write next? None of them answer the two that actually decide whether you have won a subject — what do I already cover, and am I finished?
This one does. It is free, it is a spreadsheet, and there is no form in front of it.
Download the Coverage Map (.xlsx)
Works in Excel and Google Sheets · no signup · nothing expires
Why another topical map template exists
The category has settled into three shapes. AI generators that produce 800–1,200 keywords in clusters in sixty seconds. Three-column sheets — cluster, long-tail, article title. Done-for-you services that deliver a mind map in fifteen business days.
All three answer the same question, and it is the easy one. Generating a list of things to write about has not been hard for years. The hard question is the one that comes after: of everything this subject actually contains, how much have I covered, where am I competing with myself, and at what point should I stop publishing and move on?
A list cannot answer that, because a list has no idea what you have already done. So this topical map template is built as a measuring instrument rather than a list.
Three things it measures
All three are live formulas, not instructions you are trusted to follow.
- Coverage. Every real search in your subject is one row; every row gets one page committed to it. The dashboard reads out the percentage with a page against it. That number is the subject's actual state, not a plan.
- Cannibalization, before you publish. Commit two rows to the same URL and it says so immediately, naming how many rows are fighting. List the same search twice and it flags the duplicate. Both faults are cheap to fix in a spreadsheet and expensive to fix after six months of publishing. If you want the underlying problem in depth, see keyword cannibalization.
- Orphans. Each row records how many lateral links its page has — links to its neighbours in the subject, not up to a hub and back. Under two and the page is flagged, because depth that is not connected never reads as a body of work. The reasoning is in our guide to internal linking strategy.
It tells you when to stop
This is the part no other template has, and it is the one worth having.
The dashboard carries a stop condition. Once every row has a committed page, every page is verified live, no two rows share a page and nothing is orphaned, the subject is covered — and more posts about it add overlap rather than coverage. The file says so in plain words.
Knowing when to stop is worth more than knowing what to write next, because it is what frees the budget to go and win a second subject. Most content programmes never get that signal, so they keep spending on the subject they already own.
It works outside in
Rows are tiered: Q for a specific question, SUB for a subtopic term, HEAD for the term you actually want. The priority column ranks Q above SUB above HEAD, and anything uncommitted above anything already committed — so the sheet hands you one row at a time, in the order a subject actually concedes.
That ordering is deliberately counterintuitive. The head term falls last, which makes it the worst place to start. Building the page you most want to rank before the questions around it exist is the commonest way to spend a year on a term that was never winnable yet. This template will not let you start there; it keeps handing you the questions first. Why that is true is set out in our guide to topical authority, and the structural half of it in topic clusters.
What is in the file
- Dashboard — coverage, faults, the single next action, and the stop condition. All computed.
- Map — the working sheet. 200 rows, dropdowns on tier and status, one starter row to overwrite.
- Worked Example — a real narrow subject mapped end to end, deliberately carrying a cannibalization conflict and two orphans so you can watch the instrument fire before trusting it with your own.
- Reference — what each tier and status means, why two lateral links is the floor, keyword density bands, and an honest account of what the file cannot tell you.
- Start Here — the method in five steps.
Excel, Sheets, and the columns themselves
The download is a topical map template Excel workbook — one .xlsx, five sheets, no macros and nothing to install. Because every formula was restricted on purpose to functions both applications evaluate, the same topical map spreadsheet opens and calculates identically in Google Sheets, and the dropdown validation on the tier and status columns survives the round trip. There is no separate Sheets edition to keep in step, and no cut-down version that quietly loses the dashboard.
The columns are deliberately few. Each row carries the search itself, its tier, the single URL committed to it, that page’s live status, its count of lateral links, and a priority the sheet computes rather than one you assign. Every extra column we tried made the file easier to fill in and worse at measuring, which is the trade most planning sheets make without noticing.
If you would rather read one than read about one, the Worked Example tab is a complete topical map example: a narrow subject mapped end to end, carrying a real cannibalization conflict and two orphaned pages, so you can watch the dashboard fire on faults you can see before you trust it with a subject of your own.
Where it comes from
This is not a spreadsheet designed for a blog post. It is the data structure our own deployment engine runs on, shrunk to something one person can work by hand. Module 3 of the SEO Deployment Engine holds a keyword universe of several thousand rows, measures coverage on the rendered page, refuses to close a page whose assignment is too thin, and deploys against it on a schedule. The columns in this topical map template are that system's columns, and the stop condition is its stop condition.
Or have it done for you
Module 4 — Cluster Mesh™
Your whole site mapped into topic clusters, every link mesh scored 0–100, orphans found and wired in. Topical authority, engineered and re-measured.
Everything this spreadsheet does by hand, for one subject, Cluster Mesh does automatically, across a whole site: every page mapped into topic clusters, every link mesh scored 0–100, orphans found and wired in, then re-measured so the movement is visible rather than assumed. The workbook gives you the method and one subject’s worth of it. The module runs it over the entire estate, and keeps running it.
The two modules are the ends of the same job. Cluster Mesh decides which pages should exist and how they connect. Precision Page Deployment then takes them one at a time and builds each to depth.
You need neither in order to use the file. It is yours, it is complete on its own, and nothing in it stops working if you never speak to us.
What it will not do
Three honest limits, because a tool that oversells itself wastes your time before it wastes your money.
- Coverage is measured against your map, not against reality. A four-row map can read 100%. The percentage only means something once the map honestly lists the demand — which is work the file cannot do for you.
- No tool measures topical authority, including this one. There is no such score in any Google product. What this measures is the inputs you control: coverage, structure, connection. Vendor authority scores are proxies built on link and content data, not readings of anything Google exposes.
- It does not find your keywords. It is the instrument, not the research. Bring demand from Search Console, People Also Ask, and the questions competitors answer that you do not — a content gap analysis is how you build that list.
Frequently asked questions
Is the topical map template really free?
Yes - no email, no account, no trial. Download it and it is yours. We would rather you use it and remember where it came from than trade it for an address you did not want to give.
Does it work in Google Sheets?
Yes. Upload the .xlsx to Drive and open it with Sheets; every formula is deliberately built from functions both applications support. The dropdown validation on the tier and status columns carries across too.
How many rows should a topical map have?
However many real searches the subject contains - there is no target number. A narrow subject might be a dozen rows; a broad one runs to hundreds. Publishing more pages than the demand supports produces thin overlap, not coverage, which is exactly what the stop condition exists to prevent.
What is the difference between a topical map and a content calendar?
A calendar is finished when the quarter ends. A map is finished when the subject is accounted for. The map tells you what remains; the calendar only tells you what is scheduled.
How is this topical map template different from a topical map generator?
A generator produces candidate topics. This measures what you have done about them. They solve adjacent problems and there is no reason not to use both - generate the list somewhere, then bring it here to be committed, connected and counted.
What columns should a topical map have?
Six, if it is going to measure rather than list: the search itself, its tier, the one page committed to it, that page’s live status, how many lateral links the page has, and a priority the sheet computes for you. Anything beyond that — word counts, writers, due dates — describes production rather than coverage, and belongs on a calendar instead.
How do you know when a topical map is complete?
When four things are true at once: every row has a page committed to it, every one of those pages is verified live, no two rows point at the same URL, and nothing is orphaned. The dashboard says so in plain words when that happens. The honest limit is that a map is only complete against the demand you listed, so the stop condition is worth exactly as much as the rows you put in.
Is a topical map the same as a topic cluster?
No, and conflating them hides the gap between them. A topic cluster is a structure — a hub page and the spokes that link to it. A topical map is the accounting of a subject: what it contains, what you have covered, and what is left. You can have a tidy cluster covering a third of a subject, and a fully covered subject whose cluster is broken. Our guide to topic clusters handles the structural half; this file measures the coverage half.
The free topical map template is a single .xlsx file — no macros, no add-ons, nothing to install.
Download the Coverage Map (.xlsx)
That was one check on one page. The free audit runs the full set across your site and ranks what to fix first.
Keep exploring this topic
This tool is one of the free SEO tools.