Free SEO Audit Template for 2026 (Google Sheets + 10-Category Checklist)

A solid seo audit template covers ten categories, catches most of what a paid audit would surface, and tells you when the remainder genuinely needs expert help. This guide gives you the template, how to run it, and the escalation triggers. Writing the findings up for stakeholders is its own craft: our SEO audit report template covers that half.

You can pay an agency $5,000 for an SEO audit, or you can run the same 10-category check yourself in an afternoon with the right seo audit template. This guide gives you a free Google Sheets template, a 150-point checklist, and a clear rule for when to escalate to a paid engagement.

The template covers what 90% of agency audits charge for: crawlability, indexation, on-page signals, structured data, internal linking, Core Web Vitals, content quality, backlinks, local signals, and the new layer most templates skip, AI search visibility. By the end of this article, you will know what your site actually needs.

If you have ever opened a 60-page audit PDF and felt no closer to a fix, this is the antidote.

What is an SEO audit template?

An SEO audit template is a structured spreadsheet or document that lists every check an SEO professional runs against a website, paired with a status field, a severity score, and a recommended action. It turns auditing from a memory-based skill into a checklist anyone on your team can follow.

The best templates share five traits:

1. Categorized, not a flat list. Crawl issues sit separately from content issues.
2. Scored, so you can prioritize fixes by impact, not by which one you noticed first.
3. Action-bound. Every row ends in "what to do," not just "what is broken."
4. Tool-agnostic. The template tells you what to check; your tools (Search Console, Ahrefs, Screaming Frog) tell you the data.
5. Updated for 2026 reality. Older templates ignore AI search engines entirely.

Why use a template instead of paying for an audit?

Three reasons. First, most paid audits surface the same 80% of issues the template catches. Second, running the audit yourself forces you to understand your own site, which improves every future SEO decision you make. Third, you only need to pay for expert input on the 20% the template flags but cannot solve, like JavaScript rendering edge cases or entity disambiguation across AI engines.

Treat the template as triage. If it surfaces fewer than 10 critical issues, you can probably fix them in-house. If it surfaces 30+ critical issues across multiple categories, that is the signal to bring in a specialist. We explain the escalation thresholds in detail later.

The 10 categories every SEO audit must cover

A useful technical seo audit template is not just a list of meta-tag checks. The 10 categories below map to the actual ways a site loses search visibility in 2026, including AI search.

1. Crawlability and indexation

The first question for any audit: can Google (and now ChatGPT, Perplexity, Gemini) actually access and store your pages?

Check these items:

• robots.txt does not block important sections
• XML sitemap is submitted to Search Console and Bing Webmaster Tools
• Indexed page count in Search Console roughly matches your sitemap count
• No accidental noindex tags on revenue pages
• Canonical tags resolve to live, indexable URLs
• AI bot user agents (GPTBot, PerplexityBot, Google-Extended, ClaudeBot) are allowed where you want citations
• No infinite crawl traps from faceted navigation or session IDs

2. Site architecture and internal linking

Search engines and AI engines both follow internal links to understand what your site is about and which pages matter most.

Check:

• Every important page is reachable within 3 clicks from the homepage
• Orphan pages (no internal links pointing in) are flagged
• Anchor text varies (not 100% exact match, not 100% generic)
• Breadcrumbs render on category and detail pages
• Hub-and-spoke clusters are intact (pillar pages have at least 8 inbound cluster links)
• No broken internal links

3. On-page SEO signals

The basics that still account for a large share of ranking variance.

Check title tags, H1s, meta descriptions, headings hierarchy, image alt text, URL structure, and keyword targeting consistency. The template scores each page on a 0-100 readiness scale so you know where to focus.

4. Structured data and schema

Schema is the layer AI engines lean on most heavily, because it removes ambiguity. If your site does not emit Organization, Product, Article, FAQPage, and BreadcrumbList schema where appropriate, you are leaving citations on the table.

Run a schema audit using:

• Google's Rich Results Test (per URL)
• Schema.org validator (for syntax)
• Search Console's "Enhancements" tab (site-wide errors)

If you need to generate schema, our schema markup generator handles Organization, Product, Article, FAQPage, HowTo, and BreadcrumbList types.

5. Core Web Vitals and performance

Page experience signals influence Google rankings and affect bounce rates across all referral sources, including AI engines.

Check Largest Contentful Paint (target under 2.5s), Interaction to Next Paint (under 200ms), and Cumulative Layout Shift (under 0.1). Pull data from Search Console's Core Web Vitals report, not just lab tests in Lighthouse.

6. Content quality and depth

This is where most templates oversimplify. Content quality is not word count. It is whether the page answers the query better than the current top results.

The template forces you to score every key page against four signals: query coverage, unique insight, citable claims (numbers, dates, sources), and freshness (when was it last updated).

7. Backlink profile

Look at referring domains, anchor-text distribution, the spam score of your backlink mix, and whether you have lost high-value links over the past 12 months.

You do not need a 10,000-link spreadsheet. You need to know: are you gaining quality links faster than you are losing them, and are your top competitors pulling away?

8. Local SEO signals (if applicable)

For local businesses, check Google Business Profile completeness, NAP (name, address, phone) consistency across citations, review velocity, and local content depth.

9. International and hreflang (if applicable)

For multi-language sites, verify hreflang tags resolve correctly, locale URLs do not duplicate content unintentionally, and the language switcher links use canonical locale paths.

10. AI search visibility

The category most older audit templates ignore. In 2026, a large and growing share of B2B research queries starts with an AI engine. If your brand does not appear in those responses, you are invisible to half your funnel.

Check:

• Is your brand mentioned by ChatGPT, Perplexity, Gemini for buyer queries?
• Do you have a /llms.txt file at the root?
• Is your Organization schema complete (sameAs, knowsAbout, brand)?
• Do your top pages emit FAQPage schema with question-format H2s?
• Are competitor brands cited where you are not?

For a live audit of your AI visibility, run our AI visibility checker or the GEO readiness checker.

What does the free SEO audit template include?

The Google Sheets template contains seven tabs, mapped to the 10 categories above (some categories share a tab because they share data sources).

Every row has a severity column (Critical, High, Medium, Low), an effort column (S, M, L, XL), and an action column where you write the next step. Sorting by Severity then Effort gives you your quick-win list in under a minute.

The template is intentionally plain. No macros, no hidden formulas, no required add-ons. It opens in Google Sheets, Excel, or any LibreOffice spreadsheet. If you prefer seo audit template excel format, the same file downloads cleanly as .xlsx. A seo audit template pdf export works for sharing with stakeholders who do not need to edit.

How do you actually use the template?

Step by step.

Step 1: Crawl the site

Run Screaming Frog (free up to 500 URLs) or Sitebulb on your domain. Export the crawl. Paste the URL list into the On-Page tab. This populates 60% of the rows you need to evaluate.

Step 2: Pull Search Console data

Export the last 90 days of performance data, the indexation report, and the Core Web Vitals report. Drop the data into the relevant tabs. Match URLs by exact path.

Step 3: Score schema coverage

For each template (homepage, blog post, product page, service page, category), open one example URL and check what schema is emitted. Use the Rich Results Test. Fill in the Schema tab.

Step 4: Run AI visibility prompts

Pick 10 buyer-intent prompts that should mention your brand. Example for a SaaS analytics company: "best product analytics tools for B2B SaaS." Run each prompt in ChatGPT, Perplexity, and Gemini. Record whether you appear, where, and with what context.

Step 5: Score severity and triage

Sort each tab by Severity. The Critical rows are what you fix first. Anything Medium or Low can wait until the next quarter unless effort is Small.

Step 6: Build the fix-it roadmap

The final tab in the template (Roadmap) is a simple list: issue, owner, due date, status. Move the Critical and High items into the Roadmap with assignees and ship dates.

When should you escalate from template to agency?

The template is enough for most teams in most situations. Here is when it is not.

If your audit returns 30+ Critical issues across more than three categories, that is structural debt, not a quick-fix list. Hiring a specialist for execution is cheaper than another six months of declining traffic.

What does a "free seo audit template" usually miss?

Most free templates floating around the web were written between 2015 and 2022. They miss three layers that matter now.

AI search citations. Not a single mainstream template from a major SEO blog includes a section for measuring whether your brand appears in ChatGPT or Perplexity responses. Yet that is now a buying signal.

Entity clarity. Older templates check schema syntax. They do not check whether your Organization entity is disambiguated across Wikidata, your sameAs links resolve, and your knowsAbout properties match your actual content clusters.

Content extraction quality. Old templates check word count. They do not check whether your H2s are phrased as questions (the format AI models extract), whether your FAQ blocks include answer-first paragraphs, or whether your tables are machine-readable.

AY Rank's template ships with all three layers. You can also pair it with our geo audit checklist for a deeper dive on the AI visibility layer specifically.

How does this template compare to paid agency audits?

A side-by-side comparison helps set expectations.

The trade-off is real. A paid audit hands you a polished deliverable and a stranger's expert opinion. The template hands you the same data and forces you to build the opinion yourself. For teams with an SEO lead in-house, the template wins on time-to-action. For teams without one, the paid audit is the smarter starting point.

If you want the middle ground (template structure plus expert validation), our SEO audit service runs the template against your site and delivers the prioritized roadmap in 5 business days.

How often should you re-audit?

Quarterly is the floor for any site doing meaningful SEO. Monthly is overkill unless you are running a programmatic site with thousands of new URLs each month.

A simpler rule: re-audit any time you (a) launch a major site change, (b) lose more than 15% of traffic in a month, (c) launch new template types, or (d) shift content strategy. Between events, run the abbreviated 30-minute version (just Critical-severity rows from the template) every 4-6 weeks.

FAQ

What should an SEO audit template include in 2026?

A 2026 SEO audit template should cover 10 categories: crawlability, site architecture, on-page signals, structured data, Core Web Vitals, content quality, backlinks, local SEO, hreflang, and AI search visibility. The AI search category is the most common omission in older templates and the most important to add for B2B and SaaS sites.

Is there a free SEO audit template that works for B2B SaaS?

Yes. A general SEO audit template works for B2B SaaS as long as it includes structured data for SoftwareApplication, FAQPage schema for buyer-intent pages, and an AI citation tracking layer. Our free template includes all three. For a deeper SaaS-specific view, pair it with our SEO audit service.

How is a technical SEO audit template different from a content audit template?

A technical SEO audit template focuses on crawlability, indexation, schema, performance, and rendering. A content audit template focuses on topical coverage, content gaps, keyword targeting, and refresh cadence. The full audit needs both, which is why our template combines them into a single spreadsheet with separate tabs.

Can I use an SEO audit template in Excel instead of Google Sheets?

Yes. The template uses no Google-specific functions or scripts, so it exports to .xlsx cleanly. The same applies to a PDF export if you only need to share results with stakeholders rather than have them edit cells.

What is the difference between an SEO audit and an AI visibility audit?

A traditional SEO audit measures whether your site can rank on Google search results. An AI visibility audit measures whether your brand appears in ChatGPT, Perplexity, Gemini, and Google AI Overview responses. Both matter, and our template covers both in the same document so you stop treating them as separate disciplines.

How long does it take to complete the template?

For a site under 500 pages, plan 4 hours. For sites between 500 and 5,000 pages, plan a full day. Sites over 5,000 pages should sample by template type (one example per page template) rather than auditing every URL, which keeps the audit completable in a day.

When should I hire an agency instead of using the template?

Hire an agency when the template surfaces more than 30 Critical issues across multiple categories, when you have JavaScript rendering issues the template flags but you cannot fix, or when AI engines never cite you despite a clean technical foundation. AY Rank handles all three scenarios as part of a GEO programme.

---

Sources: Google Search Central documentation, Schema.org official docs, OpenAI GPTBot documentation