SEO Audit Spreadsheet Template – On-Page SEO Analysis in Excel & Google Sheets

SEO audits don’t need to cost hundreds of dollars. Tools like Screaming Frog or Ahrefs are great, but small businesses and freelancers often just need a simple, structured audit sheet.

The SEO Audit Spreadsheet Template is your offline, easy-to-use alternative. Designed for SEO consultants, freelancers, and editors, this sheet helps you track and score on-page SEO issues across your site.

Features (100+ Checks Covered):

General Page Info

• URL

• Status Code (200/301/404)

• Canonical URL

• Indexability (Y/N)

• HTTPS (Y/N)

• Load Time (manual entry / tool export)

• Mobile-Friendly (Y/N)

Title & Meta

• Title Present (Y/N)

• Title Length (char count with conditional formatting → red if <30 or >65)

• Meta Description Present (Y/N)

• Meta Length (conditional formatting → red if <70 or >160)

• Duplicate Titles (check across sheet with conditional formatting)

• Duplicate Metas

Headers & Structure

• H1 Present (Y/N)

• Multiple H1s (Y/N)

• H1 Length Check

• H2 Count

• Missing Alt Text (image audit column)

Content Quality

• Word Count (conditional formatting → red if <300 = thin content)

• Keyword Present in Title (Y/N)

• Keyword in H1 (Y/N)

• Keyword in First 100 Words (Y/N)

• Duplicate Content Flag (manual note or Copyscape export)

Links & Crawlability

• Internal Links Count

• External Links Count

• Broken Links (manual check/export)

• Orphan Page Flag (Y/N)

• Redirect Chains (Y/N)

Technical SEO

• Robots.txt Allowed (Y/N)

• Sitemap Listed (Y/N)

• Canonical Matches URL (Y/N)

• Schema Present (Y/N)

• Open Graph Tags Present (Y/N)

• Twitter Cards Present (Y/N)

UX & Performance

• Page Speed Category (Fast/Medium/Slow)

• Core Web Vitals: LCP, CLS, FID (manual entry or from PageSpeed export)

• Mobile Usability Issues (Y/N)

• SSL Certificate Valid (Y/N)

Scoring System

• Automatic conditional formatting for Pass/Fail columns

• Weighted scoring system for each URL (Total SEO Health %)

• Color-coded audit dashboard (Green = Good, Yellow = Warning, Red = Critical)

---

📚 Usage Guide

1. Enter your URLs into the sheet.

2. Use free tools like Screaming Frog (free crawl up to 500 URLs), Google PageSpeed Insights, or Ahrefs free tools to pull in data (copy-paste into sheet).

3. The template auto-flags issues with conditional formatting (red/yellow/green).

4. Track progress as you fix issues → SEO Health % improves.

5. Export/share with clients as a professional SEO audit report.