Free SEO Worksheets: Keyword, On-Page & Local Templates

Free downloadable SEO worksheets your team can use today

Here are free SEO worksheets for keyword research, on-page optimization, and local SEO, built so a marketing coordinator can open them on a Tuesday and start working without a training session. Every field traces back to Google’s own documentation, not a vendor’s “best practices” blog. You download the pack, you fill it in, you ship the work. That is the whole promise.

Lead every worksheet with search intent and the live SERP format, treat keyword volume and citations as hygiene, and prioritize your Google Business Profile primary category, review recency, and location-page relevance over chasing directory count.

We have been building websites and ranking Charlotte businesses since 1998. Most of the worksheet packs floating around the internet are exports dressed up as strategy. They give you the columns the tool happened to spit out. We rebuilt ours around the columns that actually decide whether a page ranks. That is a different document, and the difference is the point.

What actually moves rankings, and what is just busy-work

Keyword research and citation building are hygiene. Necessary, not decisive. You do them so nothing breaks, the way you check that the plumbing is connected before you judge the kitchen. Skipping them hurts you. Obsessing over them does nothing.

The field that actually moves rankings is the one most worksheets bury at the bottom or skip entirely: intent. Not the keyword. What the keyword wants.

A query like “wordpress site slow” and a query like “fix wordpress site slow” look like a rounding error in a volume column. They are two different jobs. One wants a diagnosis. One wants a fix they can run in the next ten minutes. Map the page to the job, and the page wins. Map it to the keyword, and you have built a page that ranks for nothing because it answers no one.

Practical rule: intent is the lead column on every worksheet in this pack, not a note you tack on after the volume number. The job behind the query decides the page. Everything else is detail.

The place agencies torch the most hours is the local citation block. Spraying name, address, and phone across forty directories. That was real work years ago. It is a checkbox now. Past the first handful of canonical sources, the return is noise. You are not ranking anything. You are filling a spreadsheet so the report looks heavy.

The keyword research worksheet: two opinionated changes

The keyword research worksheet in this pack makes two changes that standard templates refuse to make. Both come from doing the work, not from reading about it.

We cut the keyword difficulty score. It is a vendor-invented composite dressed up as a measurement, and the false precision is worse than no number. “KD 42” tells you nothing you can act on, and it hands the client a figure to argue about. Two tools will give you two different difficulty scores for the same query. That alone should tell you what kind of number it is.

We added a Live SERP Format column. Before you write a word, you look at the query in Google and record what format is actually ranking. Local pack. Listicle. Video carousel. A product grid. Three forum threads. That single field tells you whether you can win at all, and what the page has to be if you try.

Sometimes the answer is you cannot win. The SERP is owned by formats you are not going to produce, and knowing that before you write saves the entire budget. The reason the standard template does not have this column: standard templates are built around what the tools export, and tools export volume and difficulty because those are easy to calculate at scale. Looking at the actual results page requires a human to look. That does not scale and does not sell as a feature, so it is not in the box. It is in ours.

Standard keyword template vs. the Four Eyes worksheet

The volume and search-trend columns stay, because they are useful hygiene. They just are not the headline. If you want a deeper read on how intent and SERP format shape the page you build next, our guide on SEO copywriting for content that ranks and converts pairs cleanly with this worksheet.

The on-page SEO worksheet: every field anchored to Google’s documentation

The on-page SEO worksheet covers title tags, meta descriptions, header structure, internal links, and image attributes in one pass per URL. What makes it different is the source. Every checkbox is anchored to Google Search Central documentation, not a recycled list of “best practices” that nobody can trace to a primary source.

That matters because half the on-page rules people repeat are folklore. “Put your keyword in the title exactly 2.4 times.” “Meta descriptions are a ranking factor.” Google has said in writing what titles do, what meta descriptions do, and what they do not do. The worksheet cites the doc next to the field so your team is not optimizing toward a rumor.

• Title tag: does it state the page’s actual subject and match the search intent you logged in the keyword sheet, or is it stuffed?
• Meta description: is it a click-earning summary, written for the human, with the understanding that Google rewrites it when it wants to?
• Header structure: one H1, descriptive H2s that ask or answer the real question, no skipped levels.
• Internal links: does the page link to and from the related pages it should, with anchor text that names the target?
• Image attributes: meaningful alt text, sane file names, compressed files that do not wreck your Core Web Vitals.
• Intent match: the lead row. Does the page do the job the query wants, or does it just contain the words?

Practical rule: fill the keyword worksheet first, then the on-page worksheet. The intent and SERP format you logged decide what the title, headers, and body have to be. Do them out of order and you optimize a page toward the wrong job.

If you want a broader audit pass on the same URL, the on-page worksheet sits well alongside our 10-step web page evaluation checklist, which adds speed, mobile, security, and conversion checks the on-page sheet deliberately leaves out.

The local SEO worksheets: the priority order most checklists get backwards

The local SEO section is where this pack earns its keep, because almost every local checklist online encodes a priority order that is ten years out of date. They lead with citations. They should lead with your Google Business Profile.

Here is the order the local worksheets enforce, top to bottom, based on what is competitive in Charlotte service-area markets right now.

1. Primary category selection. More agencies get this wrong than you would believe. The wrong primary category caps your visibility before you do anything else, and no amount of citation work fixes it.
2. Review velocity and recency. A steady flow of recent reviews beats a static pile of old ones. Velocity over count.
3. Landing-page relevance. The page your profile points to has to actually be about the service and the place. A generic homepage is a wasted signal.
4. NAP consistency. Still matters. A wrong address in three places will hurt you. But it is hygiene, not a growth lever.

Citation volume is dead weight. Ten years ago, getting your name onto every directory with a pulse worked, because the index was thinner and Google leaned on third-party corroboration to trust you existed. That era is over. Consistency still counts. Volume does nothing. Directory eleven through forty is a week you will never get back, watching the rankings sit exactly where they were.

Practical rule: proximity you cannot fight. Relevance and the profile you can. Put your week into the Google Business Profile as a live ranking surface, not an afterthought you set up once and forget.

The local pack includes three worksheets that no national aggregator produces, because they require local judgment a template farm cannot encode.

• Primary Category Decision Worksheet: walks you through choosing the single primary category that matches what customers actually search and what you actually do, with worked Charlotte examples where the obvious category is the wrong one.
• Geo-grid “where you actually rank” logging sheet: you rank differently a mile from your pin than you do five miles out. This sheet logs your pack position across a grid of points so you stop trusting the single ranking number that lies to you.
• AI-search / GEO legibility worksheet: checks whether your pages are structured so AI answer engines can extract and quote them, which is fast becoming its own ranking surface.

Every local example in the pack is worked with Charlotte service-area scenarios, the kind a national library structurally cannot replicate. If your business depends on phone calls and foot traffic from nearby customers, our deeper coverage of why local SEO is the secret sauce for Charlotte businesses and our local SEO services page explain the strategy these worksheets execute.

Local SEO priority order: what to fix first

How to use these worksheets: a quick-start walkthrough for your team

Download the pack, then run it in this order. The order is not decoration. Skip it and you redo work.

1. Start with the keyword worksheet. For each target query, fill the intent column first, then look at the live SERP and record the format. Decide right there whether the query is winnable. Kill the ones that are not before they cost you a page.
2. Move to the on-page worksheet. One row per URL. Let the intent and SERP format you just logged dictate the title, headers, and body. Check each field against the Google doc cited beside it.
3. Run the local worksheets in priority order. Primary category first, then review velocity, then landing-page relevance, then NAP. Do not touch directory eleven until the top three are clean.
4. Log your geo-grid baseline. Record where you actually rank across the grid before you change anything, so you can prove the work moved the needle later.
5. Review monthly, not daily. Rankings and reviews move on a slower clock than a dashboard refresh. Set a recurring date, update the sheets, watch the trend.

Shared admin logins and a single un-owned spreadsheet are how this falls apart. Give each worksheet an owner. A worksheet with no name on it gets filled in once and abandoned, and then you are back to guessing. If your team uses AI to speed the research, our AEO prompts for Charlotte teams show how to keep the output answer-ready instead of bloated.

One consolidated download bundle

All three pillars live on this one URL on purpose. Keyword, on-page, and local are not separate projects. They are one decision chain. The intent you log in the keyword sheet flows into the on-page sheet, and the page relevance you fix on-page is the third local signal. Splitting them across three downloads is how teams lose the thread.

The bundle is free. There is no upsell hiding inside the cells. Use it, copy it, hand it to a junior marketer, fork it for your own clients. The worksheets are the product, not bait. If you want to see how the whole approach fits into a current search strategy, our guide to SEO in 2025 is the companion read.

When a worksheet stops being enough

A worksheet structures the work. It does not do the work, and it cannot make the judgment call when the data is ambiguous. When your geo-grid shows you losing ground you cannot explain, or your primary category options all look wrong, or your pages are technically fine and still invisible, that is the point where a template runs out of road.

That is the harder problem to sell, because the value shows up later, not on the first afternoon. It is also the one we do. We have been cleaning up other people’s SEO messes from our Charlotte web design studio since 1998, and the pattern is almost always the same: the busy-work was immaculate and the three signals that matter were never touched.

Download the pack, run it in order, and lead with intent and the live SERP. If you fill in the local worksheets and the priority order surfaces a problem you cannot solve with a spreadsheet, tell us what you are seeing and we will tell you whether it is worth fixing. A second set of eyes on the geo-grid is usually the cheapest next step you can take.

Sources

• On-page worksheet fields should trace to Google’s own published guidance on titles, meta descriptions, and structure rather than vendor folklore.
• Image weight and page performance are governed by Core Web Vitals thresholds Google publishes.