Free monthly SEO report template for Excel.
A clear, simple workbook for reporting SEO results every month. Enter your numbers once and get a ready summary of traffic, rankings, technical checks and next steps.
What is inside
- Summary with a chart
- Traffic, month by month
- Rankings and changes
- 20 technical checks
- Work done and next month
Six tabs that fit together.
The Summary tab fills itself in from the others.
Summary
This month against last month for clicks, impressions, CTR, position and leads, with a chart.
Traffic
One row per month. CTR, lead rate and the change from last month are worked out for you.
Rankings
Track your keywords, see which moved up or down and how many places.
Technical checks
Twenty common checks, each with a status and a priority.
Work done
A log of what you did, so the report shows the work behind the numbers.
Next month
A short plan with owners, due dates and a status.
Made for people who report on SEO.
- Freelancers and agencies who send monthly reports to clients
- Small business owners who want to see if SEO is working
- In-house marketers who report to a manager or team
Three steps.
Download and open it
Open the file in Excel. Start on the Start here tab, then fill in Settings.
Add your numbers
Copy clicks, impressions and positions from Search Console. Add leads from your analytics or forms.
Read the Summary
Check the Summary tab, add a few notes on the work you did, and share it.
Is the template really free?
Yes. It is free to download, with no signup. You can use it for your own site and for your clients. Please do not resell it.
Which numbers do I need?
Clicks, impressions, CTR and average position come from the Performance report in Google Search Console. Leads or conversions come from your analytics tool, call tracking or contact forms.
Does it work in Google Sheets?
It is built for Excel. It should also open in Google Sheets and LibreOffice (in Google Sheets, use File, then Import), but check the formulas and the chart after importing.
Can I change it?
Yes. The cells you type into are blue on a pale yellow background. Formulas are black, so you can see what to leave alone.
Want someone to do the SEO and the report?
Request a free SEO audit and we will send you a ranked list of fixes in plain language.