SEO Audit Template: Free 46-Point Spreadsheet
By the PNext team · Updated 9 November 2026
A good SEO audit ends with the ten things to fix first, not a list of every problem. This template is built to get you there.
It has 46 checks, how to test each one, the tool to use and a priority score that sorts your fix list for you. Download it free below, with no email needed.
- ✓What a useful SEO audit covers
- ✓All 46 checks, by area
- ✓How to score and sort your fixes
- ✓Mistakes that waste an audit
- ✓How long an audit should take
What is an SEO audit template?
An SEO audit template, also called an SEO checklist, is a ready-made list for testing how well a website can rank. Ours has 46 checks across crawling, speed, on-page, content, links, schema, local and tracking. Mark each as pass or fail, score the effort, and it ranks your fixes.
Free, no email needed. Opens in Excel. In Google Sheets: File, Import, Upload. See all our free SEO templates.
What the SEO audit template covers
The spreadsheet has one row per check, and a Summary tab that adds up passes and fails by area.
| Area | Checks | What you are looking for |
|---|---|---|
| Crawl and index | 10 | Google can find and index the pages that matter, and nothing it should not |
| Performance | 6 | Core Web Vitals, image weight, server speed and phone layout |
| On-page | 8 | Titles, descriptions, headings, alt text, URLs and one main page per search |
| Content | 6 | Pages match the search, answer it early and stay accurate |
| Internal links | 4 | No orphan pages, and money pages get links from strong pages |
| Schema | 3 | Valid organization, page type and breadcrumb markup |
| Authority | 3 | Referring domains and link gaps against competitors, and no manual actions |
| Local | 3 | Business Profile, consistent contact details and reviews |
| Measurement | 3 | Leads tracked as key events, clean data and linked tools |
Here are ten of the 46 checks, so you can see the level of detail before you download it.
| Example check | Area | How to test it |
|---|---|---|
| Key pages are indexed | Crawl and index | Page indexing report and URL Inspection |
| No important page has noindex by mistake | Crawl and index | Crawl and filter by noindex |
| Redirects are single hops | Crawl and index | Crawl redirect chains report |
| LCP is 2.5 s or less on mobile | Performance | Core Web Vitals in PageSpeed Insights |
| Unique title of 30 to 60 characters | On-page | Crawl titles |
| One clear H1 per page | On-page | Crawl H1s |
| Each search has one main page | On-page | Search Console query and page report |
| Page matches the top 3 results | Content | Review the search results by hand |
| No orphan pages | Internal links | Compare crawl with sitemap |
| Forms, calls and chat are key events | Measurement | Test each in GA4 DebugView |
For the deeper technical steps behind these checks, see our technical SEO audit checklist.
How to run an SEO audit with this template
- Connect your data. You need Search Console, GA4, a crawler such as Screaming Frog, and PageSpeed Insights. A backlink tool helps but is not essential.
- Crawl the site. Export the results so you can filter by status code, title, canonical and depth.
- Work down the Audit tab. Mark each row Pass, Fail or N/A. Each one tells you how to check and which tool to use.
- Write what you found. For each fail, note the URLs affected and the fix in plain words.
- Score the effort from 1 to 5. The priority score fills in by itself: severity x 2, divided by effort.
- Sort by priority and give the top ten an owner and a date. That is your plan, and it can go straight into our SEO roadmap template.
How to decide what to fix first
This is the step that decides whether an audit gets acted on. Not every issue deserves the same attention, so sort by what it blocks. Need help reading the results? Explore SEO consulting services.
| Type of problem | Example | When to fix |
|---|---|---|
| Blocks everything | Key pages set to noindex, robots.txt blocking the site | Today |
| Stops measurement | Forms and calls not tracked | This week |
| Costs rankings on money pages | Two pages competing for one search, weak internal links | This month |
| Cosmetic | Missing alt text on old blog images | When you are already editing the page |
Common SEO audit mistakes
- Trusting the tool score. A crawler score of 95 says nothing about whether you match what people search for.
- Skipping the search results. The most useful check is looking at the top three results for your main terms by hand.
- Listing issues with no owner. An issue with no name and date beside it will not get fixed.
- Fixing what is easy instead of what matters. Alt text is satisfying. An unindexed service page costs money.
- Auditing once. Run the crawl and index checks monthly and the full template every six months.
Frequently Asked Questions
Try a different keyword, or ask our team directly.
A review of how well a website can be found and ranked by search engines. It covers technical health, content, links and tracking, and ends with a prioritised list of fixes.
Yes. Download it from this page with no email needed, and use it for your own site or for clients.
Yes. Open Google Sheets, choose File, Import, Upload, and pick the file. The formulas carry over.
A small site usually takes a day or two with this template. Large sites take longer because of the volume of URLs and the number of people involved.
Run the crawl and index checks every month and the full template every six months, and again after any redesign or migration.
Google Search Console, GA4 and PageSpeed Insights are free. A crawler such as Screaming Frog has a free version for sites up to 500 URLs. Ahrefs or Semrush are only needed for the link checks.
Ready to talk about your results?
Whether for your own site or your clients, tell us what you need and we will reply with next steps.
We work with businesses across the USA and the UAE. No pitch, no pressure, just an honest view of what we would do.
Or call and WhatsApp us on +971 50 298 5401.
- 01Audit
- 02Strategy
- 03White label options
- 04Timeline
Talk to us about SEO
Tell us about your website and goals.