Free simple SEO site audit tool!
This simple free site audit tool is completely made out of a Google Sheets doc! It uses ONLY Google Sheets formulas to analyze an entire website in one go. You can enter a sitemap URL, or paste a list of URLs, and it will check each page for Schema usage, titles, meta descriptions, heading issues, and some duplication issues. It even gives you a numeric grade for the site! It also offers a full, detailed report of each URL in the sitemap, showing what micro-data/schema is used on each page, number of H1/H2 tags, content of each H1/H2 tag, page title and length, and meta description.
This tool is a collaboration between RankTank’s @seanmalseed, and @billsebald of Green Lane SEO. Use this tool as-is, or modify the formulas and create your own beast!
Get this SEO tool for free!
Click the "Free Download" button below...
Instantly receive a link to access this free SEO tool.
Send download link to:
Bitcoin
Donate Bitcoin to support RankTank
Scan the QR code or copy the address below into your wallet to send some Bitcoin to keep RankTank free forever!
Tutorial Video
Coming soon…
Know Issues
1. This tool needs to be updated to function correctly on all systems.
12 comments
I didn’t knew you guys had your website. But thanks a lot for the good work. Keep it coming !
Nice website excellent service
Just tried and working pretty well. Using a couple of different programs to audit SEO is a must to make a good report, I would recommend it to my colleagues. Good job RankTank!
Awesome tool, thanks so much for putting in all this effort and sharing it for free 🙂 You rock.
Every sitemap i insert after finish the report gives me an error #DIV/0!
What should i do?
Could you email me an example of a sitemap that doesn’t work? [email protected]
Also, make sure that the sitemap is for pages, and not a sitemap that’s an index of other sitemaps.
If you use sitemap url as http://www.domain.com/sitemap.xml, but you use wordpress plugins that create automatic xml, usually will error #DIV/0!
I used Google XML Sitemap wordpress plugin for my website, and I type sub-sitemap for sitemap url field as http://domain.com/sitemap-tax-post_tag.xml
Done!
Thank Ranktank with awesome SEO Sheet!
I think i found the problem, you should post the link like this: https://docs.google.com/spreadsheets/d/1MTQyFYSoAfABQY7V0lToPzwdHDYjoaF9Wylw7BvIvxg/edit
I can’t too with Gmail logged in.
This looks great. Thank you so much!
I opened the tool but can’t seem to find the File > Make a copy menu. Seems pretty locked down.
Hey Derek, it might be your Google Apps account actually. Do you have another Apps or Gmail account you could try from?