Guides / SEO audit template
Free SEO audit template in Excel, Sheets, Docs and PDF
24 checks in a 10-tab Excel workbook, with a dashboard that scores the audit, an action plan and a client report outline. It is also a ready Google Sheets template, and comes with report templates in Google Docs and Word and a filled-in sample PDF. Made for freelancers and agencies who want the audit, the fix list and the report in one place.
Excel workbook, 274 KB, plus Google Sheets, Google Docs, Word and PDF versions. No sign-up. By the SEOSage team. Updated November 2026.
Jump to: Get it · What is inside · Report outline · Questions
What you get
- 10 tidy tabs in SEOSage colours
- A dashboard that scores your audit
- 24 checks with a free tool for each
- Action plan, keyword and link trackers
- A client report outline
Excel workbook (.xlsx), 274 KB. Works in Excel, Google Sheets and Numbers. Free, with no sign-up and no email.
Also in other formats
- The audit templateGoogle Sheets CSV
- Audit report templateGoogle Docs Word
- Monthly report templateGoogle Docs Word
- Sample reportGoogle Docs Word PDF
- Technical checklistGoogle Docs Word PDF
What is in the spreadsheet
- Dashboard: a health score and progress by area that fill in by themselves.
- Checklist: 24 checks, each with why it matters, a free tool to test it, a priority and a Status drop-down.
- Free tools: links to every SEOSage checker, so you can test each row in one click.
- Action plan: turn problems into jobs with an owner, a date and a 30, 60 or 90 day slot.
- Keywords, Broken links, Competitors: trackers for rankings, 404s and redirects, and who ranks above you.
- Monthly numbers and Report outline: a 12-month tracker with a chart, and the seven sections of a client report.
How to use it
- Open it in Excel, Google Sheets or Numbers.
- Fill in the audit details on the Start here tab.
- Go down the list. Test each check with the tool named in the row.
- Set the status, and note the pages affected and the fix. The Dashboard updates by itself.
- Move the real problems to the Action plan tab.
Want to read the checks first? See the SEO audit checklist.
A look at the Checklist tab
Swipe the table sideways to see every column.
| Area | Check | How to test it | Priority | Status | Fix |
|---|---|---|---|---|---|
| Crawling and indexing | Important pages are not blocked by robots.txt | Robots.txt tester | High | Pass | – |
| Redirects and errors | No broken internal links | 404 checker | High | Fix needed | Fix 3 broken links in the footer |
| On-page basics | Every page has a unique title of about 30 to 60 characters | Title and meta description checker | High | In progress | Shorten 12 blog post titles |
The first 3 of the 24 rows, with the Status and Fix filled in as an example. The Checklist tab has 13 columns, including pages affected, owner and due date.
How to write the audit report
A good report is short and ordered by what matters. Use these seven sections. For a ready-made report in Word, with a filled-in sample PDF, use our website audit report template.
- Summary. Three or four sentences: how healthy the site is, the biggest problems, and what to do first. Write it last. Most readers stop here.
- Scope. The website, the date, how many pages were checked, and which tools you used.
- What is working. A short list of good news. It builds trust and shows you looked at the whole site.
- Issues by priority. A table with one row per issue: what it is, how many pages it affects, why it matters, how to fix it and how much work it is. Put the High priority issues first.
- Quick wins. The fixes that take under an hour and help straight away, such as a stray noindex tag or a broken link in the menu.
- Plan. Who does what and by when, for example the next 30 days, then 60, then 90.
- Next review. When you will check again, and which pages you will re-check after the fixes.
Copy this outline
# SEO audit report: [website] ## Summary ## Scope ## What is working ## Issues by priority | Issue | Pages | Why it matters | Fix | Effort | |---|---|---|---|---| ## Quick wins ## Plan ## Next review
Skip the typing
SEOSage crawls a website and builds the report from what it finds. Export it as PowerPoint, PDF, CSV or Markdown, and add your own logo and colours to the deck. Free for 14 days, no card needed.
Questions about the SEO audit template
What is in the SEO audit template?
It is a branded Excel workbook with ten tabs: a start page, a dashboard that scores your audit, the 24-check checklist, a list of our free tools, an action plan, a keyword tracker, a broken links list, competitor research, monthly numbers and a report outline.
Is there a Google Sheets version?
Yes. Open the Google Sheets template on this page and click Use Template: you get your own copy in your Google Drive, with the same ten tabs, dashboard and drop-down lists as the Excel file. If you only want the 24 checks, download the CSV file instead.
Does it include a client report?
Yes. The Report outline tab and the outline on this page give the seven sections of an audit report. For a ready-made report, use the audit report template on this page, in Google Docs or Word, with a filled-in sample PDF. For the reports you send every month after the audit, there is a monthly SEO report template in Google Docs and Word too.
What should an SEO audit report include?
A short summary, the scope of the audit, what is working, the issues sorted by priority with the pages affected and the fix, the quick wins, and a plan with who does what and by when.
Can SEOSage write the report for me?
SEOSage turns a crawl into a report for you. Export it as PowerPoint, PDF, CSV or Markdown, and add your own logo and colours to the deck.
Is the template free?
Yes. Download it straight away, with no sign-up and no email. Use it for your own sites or for clients.