Guides / SEO audit template
Free SEO audit template and report template
A colour-coded Excel workbook to run an SEO audit, with a dashboard, an action plan and trackers, and a simple outline for the report that goes with it. Use them for your own sites or for clients.
By the SEOSage team. Updated October 2026.
Jump to: Get it · What is inside · Report outline · Questions
Your template is ready
We have also emailed you the link, so you can find it later.
Sorry, that did not go through. Please check your email address and the tick box, then try again. Or email [email protected] and we will send it.
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 first rows
| Area | Check | How to test it | Priority | Status | Fix |
|---|---|---|---|---|---|
| Crawling and indexing | Important pages are not blocked by robots.txt | Robots.txt tester | High | ||
| Redirects and errors | No broken internal links | 404 checker | High | ||
| On-page basics | Every page has a unique title of about 30 to 60 characters | Meta description checker | High |
The Checklist tab in the workbook has 24 rows and thirteen columns.
SEO audit report template
A good report is short and ordered by what matters. Use these seven sections.
- 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, cancel any time.
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.
What file type is it?
It is an Excel file (.xlsx). It opens in Excel, Google Sheets and Numbers. The dashboard and the drop-down lists work in all three.
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. Enter your email and you can download it at once. We also email you the link, and we send an occasional SEO tip. You can unsubscribe at any time. Use the template for your own sites or for clients.