SEO Audit Template: The 6 Columns That Make It Useful

An SEO audit template is a structured spreadsheet where every check carries evidence, a severity score, an effort estimate and an owner, so that the output is a ranked list of fixes and not a list of observations. Unlike a plain checklist, it forces a decision on every row.

According to Google Search Central (2024), Search Console keeps 16 months of performance data, which is the baseline every audit sheet should start from. According to web.dev (2024), a page passes Core Web Vitals when LCP is 2.5 seconds or less, INP is 200 ms or less and CLS is 0.1 or less at the 75th percentile. According to Screaming Frog (2026), the free crawler stops at 500 URLs, which is enough for most small-site audits.

The short answer: download any template you like, then add four columns it probably lacks. Evidence, severity, effort and owner. Without them you have a checklist. With them you have a backlog you can hand to a developer on Monday.

What an SEO Audit Template Should Actually Contain

An SEO audit template is not a list of 200 things to look at. It is a decision tool. Each row answers one question: what is wrong, how do I know, how much does it cost us, how hard is it to fix, and who fixes it.

Search the term and you will find dozens of free files. Most are good at the first column and silent on the rest. They tell you to check canonicals. They do not tell you what to do when 40 pages fail that check and the dev team has one sprint.

In my experience auditing sites for founders and in-house teams, the template is rarely the problem. The missing columns are. The client opens a 150-row sheet, sees 90 red cells and closes it. Nothing ships.

So I build the template backwards. I start with the output I want, a ten-row first sprint, and add only the columns and checks that can produce it.

Why Most Downloadable SEO Audit Templates Fail

Most free SEO audit templates fail because they optimise for completeness, not action. A long list feels thorough. It is also the fastest way to make sure a client does nothing.

Three failure modes show up again and again:

• No evidence field. A row says “duplicate titles: fail”. Which URLs? Without evidence the developer has to redo your work, and often will not.
• No ordering logic. Every failed check looks equally urgent. A noindex on the pricing page sits next to a missing alt attribute on a footer icon.
• No owner. SEO findings land in a shared sheet and belong to nobody. Fixes need a named person in dev, content or marketing.

There is a quieter fourth problem. Templates age. Many still check for things Google dropped, such as noindex rules inside robots.txt, which Google stopped supporting in 2019. They rarely include a pass for AI crawler access or for how a page reads when an answer engine quotes it.

If you want the sequence of checks itself, I cover it in the SEO audit checklist. This post is about the container that turns those checks into work.

The 6 Columns Every SEO Audit Template Needs

The six columns below are the whole difference between a checklist and an SEO audit template that gets implemented. Add them in this order so each one constrains the next.

1. Check. One specific, testable statement with a pass condition. “Every indexable URL self-canonicalises” is a check. “Canonicals” is a topic.
2. Evidence. The proof: a URL list, a Search Console export reference, a screenshot link. If you cannot attach evidence, you have an opinion, not a finding.
3. Severity. A score from 1 to 4 based on what the failure does to crawling, indexing, rankings or conversions. Define the scale on the sheet itself.
4. Effort. A score from 1 to 4 for how hard the fix is: 1 is a settings change, 4 is a template rebuild or cross-team project.
5. Owner. A named role: developer, content lead, marketing, agency. Not “the team”.
6. Status. Open, in progress, shipped, verified. The last state matters most. A fix is not done until you have confirmed the result in Search Console or a re-crawl.

Everything else is optional. Notes, links to documentation, estimated traffic upside. Useful, but they should never push the six core columns off the screen.

How to Score Severity and Effort in Your Audit Spreadsheet

Severity and effort scoring turns a long audit spreadsheet into a short ranked list. The scoring itself should take minutes per row, not hours. If it takes longer, the scale is too clever.

Here is the scale I use:

• Severity 4: blocks indexing or crawling. Noindex on money pages, robots.txt blocking key directories, broken canonicals, 5xx errors.
• Severity 3: suppresses rankings at scale. Duplicate or thin templates, redirect chains on internal links, failing Core Web Vitals on high-traffic templates.
• Severity 2: limits click-through or relevance. Weak titles, missing structured data, poor internal anchors.
• Severity 1: hygiene. Alt text gaps, minor markup errors.

Effort runs the other way: 1 is under an hour, 4 is a project. Then sort by severity descending, effort ascending. The top of the sheet is your first sprint.

A simple formula helps: priority = severity × 3 − effort. A severity 4, effort 1 fix scores 11. A severity 2, effort 4 rebuild scores 2. You do not need a weighted model with eleven inputs. You need a sort order people trust.

One caution. Score on measured impact where you can. If Search Console shows that the affected template drives 60% of your clicks, bump severity regardless of how minor the issue looks in isolation.

SEO Audit Template Structure: Tabs That Work

A good SEO audit template uses a handful of tabs, one per audit pass, plus a summary. More than eight tabs and nobody reads past the third.

This is the layout I give clients:

• Summary. The top ten findings, pulled from the other tabs by the priority score. This is the only tab an executive reads.
• Baseline. Search Console clicks and impressions, top landing pages, indexed page count, Core Web Vitals pass rate.
• Indexation and crawl. Page indexing report buckets, robots.txt, sitemaps, status codes, canonicals, orphan pages.
• On-page and intent. Titles, headings, internal links, search-intent fit for priority URLs.
• Content. Thin, duplicate and decayed pages, with a keep, merge, redirect or delete decision per URL.
• Links and authority. Referring domains, anchor distribution, competitor gap.
• AI visibility. AI crawler access, quotable facts on key pages, brand mentions in answer engines.

Every tab uses the same six columns. That consistency is what lets the summary tab pull from all of them. If you want to go deeper on the technical tabs, the technical SEO checklist lists the pass conditions I use.

A Worked Example: One Row Done Properly

One filled-in row shows how the six columns work together better than any explanation. Take a mid-sized e-commerce site where Search Console reports 1,200 URLs as “Duplicate without user-selected canonical”.

• Check: Every indexable product URL declares a self-referencing canonical.
• Evidence: Page indexing export, 1,200 URLs, mostly parameterised sort and filter URLs. Sample of five in the linked sheet.
• Severity: 3. The affected URLs eat crawl budget, and 18% of them receive internal links.
• Effort: 2. A rule in the template plus a parameter-handling change.
• Owner: Lead developer.
• Status: Open.

Priority: 3 × 3 − 2 = 7. That row lands in the first sprint. Compare that with a template row reading “Canonicals: check”, which tells the developer nothing.

The same logic applies in other contexts. For an in-house team presenting to a board, the summary tab becomes the executive page of the audit report. If you need the report format, see what makes an SEO audit report good.

Build Your Own SEO Audit Template or Download One?

Download one, then modify it. Building from scratch rarely pays off, because the check lists across good free templates overlap by roughly 80%. The value is in your scoring and your columns.

When picking a file, look for:

• A copy-friendly format: Google Sheets or Excel, not a PDF.
• Pass conditions written per check, not just topic names.
• Recent updates. Anything that does not mention INP, AI crawlers or Search Console’s current reports is stale.
• A reasonable length. Under 80 checks is plenty for most sites.

Then delete rows. This is the step people skip. A check that cannot change a ranking, an index status or a conversion on your site does not belong in your sheet. Add the six columns, set the scoring scale, and keep a changelog so you know why rows were removed.

If you want the sheet filled in by someone who has done it 200 times, that is what a professional SEO audit delivers. For what the price looks like, see how much an SEO audit costs and my SEO pricing page. Founders and marketing directors who want the technical tabs run end to end can start with technical SEO.

Running the Audit: From Template to First Sprint

A filled-in SEO audit template only matters if it ends in shipped fixes. The handover is where most audits die, so treat it as a step of the audit, not an afterthought.

Use this order:

1. Fill the baseline tab first. Export Search Console data for the last 16 months and record clicks, impressions and indexed page counts.
2. Run the passes in order. Indexation and crawl before on-page, on-page before content. A blocked page cannot benefit from a better title.
3. Score as you go. Severity and effort on the same day you find the issue, while the context is fresh.
4. Cut to ten. Sort by priority and copy the top ten rows to the summary tab. Ignore the rest until the first sprint ships.
5. Assign and date. Every top-ten row gets an owner and a target week.
6. Verify and rescore. After each fix, confirm it in Search Console or a re-crawl and set status to verified. Re-run the sheet in three months.

In practice, a team that ships ten well-chosen fixes beats a team that acknowledges 200. The second group has a report. The first has traffic.

Google’s own documentation is the right source for pass conditions on indexing and crawling. Start with the Search Central documentation and the Core Web Vitals guide on web.dev when writing your checks, and ignore blog claims that cannot be traced to either.

Frequently Asked Questions

Is a free SEO audit tool?

Many are free, but a tool is not an audit. Search Console, PageSpeed Insights and the free Screaming Frog crawl (up to 500 URLs) find problems. A template or a consultant decides which problems matter and in what order. Use the free tools for data and a template for the decisions.

How much does a website audit cost?

A basic automated report costs nothing to a few hundred dollars. A manual audit by a senior consultant for a small or mid-sized site typically runs from a few thousand to several thousand euros, depending on URL count and depth. The price buys judgement and a ranked fix list, not the crawl itself.

How do I write an audit report?

Start from your filled-in template. Lead with the ten highest-severity, lowest-effort findings, each with evidence, a recommended fix and an owner. Put the full sheet in an appendix. A report that opens with a 90-page crawl export will not get implemented.

How to create an audit checklist?

List only checks that can change a ranking, an index status or a conversion. Give each one a pass condition, an evidence field, a severity, an effort estimate and an owner. If you cannot say what a failed check would cost, delete it from the list.

What are the 7 steps in the audit process?

For SEO, a workable sequence is: baseline your data, check indexation, crawl the site, audit on-page and intent, review content, assess links, then test AI visibility. Score every finding by severity and effort as you go, so the output is a ranked backlog and not a pile of notes.