Free Resource

Website Audit Spreadsheet: Free Template to Track Every Issue and Fix

A multi-tab website audit spreadsheet that catalogs URLs, flags technical issues, scores on-page quality, and organizes action items by priority. Built for teams running audits on sites with 50 to 50,000 pages.

Last updated: March 2026 · Reading time: 9 min

What’s in this template

What is a website audit spreadsheet?
Who should use it?
Template preview: all 5 tabs
What each tab contains
How to run an audit with this spreadsheet
Mistakes that waste your audit
Download
FAQ

About This Template

What is a website audit spreadsheet?

A website audit spreadsheet is a structured document that records every page on your site, the technical and content issues found on each page, and the specific actions needed to fix them. It’s the working document that turns a vague “our site needs work” into a prioritized task list your team can execute against.

Website audit spreadsheet: A multi-tab document that inventories all URLs on a site, records technical health signals (status codes, load speed, mobile usability), evaluates on-page SEO elements (titles, metas, headings), and organizes fixes into a scored action plan.

Asana, Backlinko, and Trackingplan all published website audit templates in 2025-2026, but most of them are simple checklists. They tell you what to check. They don’t give you a place to record what you found on every URL. This spreadsheet is different. It’s the actual working document we use inside our analytics and audit practice, stripped down to the structure any team can adopt. Here’s why that matters: a 2024 Screaming Frog study of 6.3 million URLs found that 42% of sites had duplicate title tags, 25% had missing meta descriptions, and 17% had broken internal links. Those issues don’t surface unless you crawl systematically and record results in a format your whole team can act on.

Who It’s For

Who should use this website audit spreadsheet?

Any team responsible for maintaining or improving a website with more than 20 pages.

In-House SEO and Marketing Teams

Use it as the backbone of your quarterly site health review. The URL inventory tab becomes your single source of truth for what exists on your domain and what condition it’s in.

Freelance SEO Consultants

Hand it to clients as a deliverable they can understand. Each tab is labeled plainly. No jargon, no proprietary tool access required. Your clients see every issue and every recommendation in one place.

Development Teams Receiving SEO Tickets

The technical issues tab gives developers exact URLs, HTTP status codes, load times, and mobile-pass/fail verdicts. No ambiguity. Each row is a ticket.

Preview

What does this website audit spreadsheet contain?

Five tabs, each covering a distinct layer of your website’s health.

Tab	Purpose	Key Columns
1. URL Inventory	Complete crawl of every page	URL, Page Type, Status Code, Indexable (Y/N), Last Modified, Word Count
2. Technical Issues	Server and performance problems	URL, HTTP Status, TTFB (ms), LCP (s), CLS Score, Mobile Usable, Issue Type
3. On-Page SEO	Title, meta, heading review	URL, Title Tag, Title Length, Meta Description, Meta Length, H1, H1 Count, Canonical
4. Content Quality	Content depth and relevance scoring	URL, Word Count, Reading Level, Target Keyword, Keyword in Title, Internal Links In, Internal Links Out, Quality Score (1-10)
5. Action Items	Prioritized fix list	URL, Issue, Priority (P1/P2/P3), Owner, Status, Due Date, Notes

What’s Included

What does each tab of the website audit spreadsheet cover?

Every tab answers a specific question about your site’s health.

URL Inventory: Start every audit here. Paste your Screaming Frog or Sitebulb crawl export. The tab captures every URL on your domain with page type classification (blog, product, category, landing page), HTTP status, indexability flag, and content length. Conditional formatting highlights any page returning a non-200 status code. For a 500-page site, this tab alone tells you which 15-20% of pages are dead weight.
Technical Issues: Pull in Core Web Vitals data from Google PageSpeed Insights or CrUX. Each row shows one URL’s Time to First Byte, Largest Contentful Paint, Cumulative Layout Shift, and mobile usability pass/fail. The tab auto-flags URLs where LCP exceeds 2.5 seconds (Google’s “good” threshold) or CLS exceeds 0.1. Google’s 2024 Core Web Vitals report showed that only 43% of mobile pages pass all three CWV thresholds.
On-Page SEO: Every URL gets reviewed for title tag presence and length (target: under 60 characters), meta description presence and length (target: 150-160 characters), H1 presence and uniqueness, canonical tag correctness, and Open Graph completeness. Columns auto-highlight titles over 60 characters and missing metas. A VonClaro audit found that 38% of sites they reviewed had at least one page with a missing or duplicate title tag.
Content Quality: This is where you score the actual content. Word count, reading grade level, target keyword presence in the title and first 100 words, internal links pointing in and out, and an overall quality score from 1 to 10. We use a scoring rubric included in the template: 1-3 is thin content that should be consolidated or removed, 4-6 needs improvement, 7-10 is performing.
Action Items: Everything from tabs 2-4 feeds into this tab. Each issue becomes a row with a priority label (P1 = blocks indexing or causes errors, P2 = impacts ranking, P3 = optimization opportunity), an assigned owner, a status column (Open, In Progress, Done), and a due date. Sort by priority to create your sprint backlog.

How To Use

How do you run a website audit using this spreadsheet?

Five steps. Budget 4-8 hours for a site with 200-500 pages.

Crawl your site and populate the URL Inventory tab. Use Screaming Frog (free for up to 500 URLs) or Sitebulb. Export the crawl as CSV and paste it into Tab 1. The template’s column headers match Screaming Frog’s default export, so alignment takes under 5 minutes.
Run PageSpeed Insights on your top 50 pages and populate the Technical Issues tab. Use Google’s PageSpeed Insights API or the bulk testing feature in tools like Sitebulb. Record TTFB, LCP, CLS, and mobile usability for each URL. The template auto-flags anything outside Google’s “good” range.
Audit on-page elements for every indexable URL. Screaming Frog exports title tags, meta descriptions, H1s, and canonicals directly. Paste those into Tab 3. The conditional formatting does the rest: red for missing titles, yellow for titles over 60 characters, red for duplicate H1s.
Score content quality on your top 100 traffic pages. You don’t need to score every page on day one. Start with the pages that drive 80% of your organic traffic (check Google Search Console). Grade each one using the 1-10 rubric included in the spreadsheet.
Build the Action Items tab and assign owners. Filter tabs 2-4 for any row with a red or yellow flag. Copy each issue into Tab 5, assign a priority, assign an owner (SEO team, dev team, content team), and set a due date. You now have a project plan, not just an audit.

Expert Context

What mistakes ruin a website audit?

We’ve run over 200 site audits at ScaleGrowth.Digital since 2019. The spreadsheet structure above comes from what we’ve learned about what works and what doesn’t. Here are the patterns that separate useful audits from shelf-sitters:

Auditing without a URL inventory first. If you don’t know how many pages you have and what types they are, you’re auditing blind. We’ve found sites that thought they had 200 pages but actually had 1,400 (including parameter URLs, pagination pages, and tag archives that nobody knew existed). Tab 1 prevents this.
Recording issues without recording severity. “Title tag is too long” and “page returns a 404” are not the same level of problem. Without P1/P2/P3 labels, dev teams treat every ticket equally and fix the easy stuff first. The action items tab forces prioritization.
Running the audit once and never updating it. A website audit spreadsheet should be a living document. Re-crawl quarterly. Re-check Core Web Vitals after every major deployment. The Backlinko 2026 audit checklist recommends monthly spot-checks on your top 50 URLs.

“The audit itself is worth nothing. The action items tab is worth everything. If your spreadsheet doesn’t end with a prioritized list of fixes assigned to specific people with specific deadlines, it’s a report, not an audit.”
Hardik Shah, Founder of ScaleGrowth.Digital

Inside our analytics practice, every audit we deliver uses this exact 5-tab structure. Clients get the spreadsheet alongside a narrative report, but it’s the spreadsheet that drives the implementation. The narrative explains why. The spreadsheet tells you what to do, in what order, and who should do it.

Download the Website Audit Spreadsheet

Get all 5 tabs with conditional formatting, scoring rubrics, and pre-built column headers that match Screaming Frog exports. Download Free Spreadsheet →

Google Sheets format. No spam. Instant access.

Technical SEO Checklist

A 30+ point checklist for the technical layer of your audit: crawlability, indexation, page speed, schema, and server configuration. Get Checklist →

SEO Report Template

Turn your audit findings into a client-ready or stakeholder-ready report with this structured narrative template. Get Template →

On-Page SEO Checklist

47 specific checks for every page you publish or optimize. Pairs with the on-page tab of this audit spreadsheet. Get Checklist →

FAQ

Frequently Asked Questions

How often should I run a full website audit?

Run a full audit quarterly for active websites with regular content publishing. After major site changes (redesign, CMS migration, domain move), run an immediate full audit. Between full audits, do monthly spot-checks on your top 50 pages using the technical issues and on-page tabs.

What free tools do I need to populate this spreadsheet?

At minimum: Screaming Frog SEO Spider (free up to 500 URLs) for the crawl, Google PageSpeed Insights for Core Web Vitals data, and Google Search Console for indexation and search performance data. For sites over 500 pages, you’ll need Screaming Frog’s paid license ($259/year as of 2025) or a tool like Sitebulb ($35/month).

How long does a website audit take?

For a site with 100-500 pages, plan 4-8 hours for data collection and 2-4 hours for analysis and action item prioritization. A site with 1,000+ pages takes 2-3 full days. The crawl itself runs in 15-30 minutes for most sites; the time is in reviewing results and scoring content quality.

Can I use this template for a client audit deliverable?

Yes. The spreadsheet is designed as both an internal working document and a client deliverable. Each tab is labeled in plain language, and the action items tab gives clients a clear picture of what needs fixing and why. Add your branding to the header row and you have a professional audit document.