Simple SEO Site Audit Tool

by Jaco

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:

Subscribe to get free SEO tool updates.

  • Bitcoin
Scan to Donate Bitcoin to 19gHVYrSygFuUKXhZ2fDcfmk1WD2t1Yoym

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!

Get this SEO tool for free!
You can also Make a Copy of this Google Sheet SEO tool, help fix and improve it for others.

Tutorial Video

Coming soon…

Know Issues

1. This tool needs to be updated to function correctly on all systems.

Leave a Comment


Swarna 2 July 2020 - 10:27 am

I didn’t knew you guys had your website. But thanks a lot for the good work. Keep it coming !

Rajesh Sharma 24 March 2020 - 1:26 pm

Nice website excellent service

Webbing 15 December 2017 - 12:43 pm

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!

StarterPad 10 December 2014 - 6:32 pm

Awesome tool, thanks so much for putting in all this effort and sharing it for free 🙂 You rock.

Alex 9 December 2014 - 8:53 pm

Every sitemap i insert after finish the report gives me an error #DIV/0!

What should i do?

Sean Malseed 9 December 2014 - 10:08 pm

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.

Appoint 15 September 2015 - 9:11 am

If you use sitemap url as, 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

Thank Ranktank with awesome SEO Sheet!

Alex 9 December 2014 - 8:25 pm

I think i found the problem, you should post the link like this:

Alex 9 December 2014 - 8:24 pm

I can’t too with Gmail logged in.

Sarah 9 December 2014 - 7:26 pm

This looks great. Thank you so much!

Derek 9 December 2014 - 5:29 pm

I opened the tool but can’t seem to find the File > Make a copy menu. Seems pretty locked down.

Sean Malseed 9 December 2014 - 5:51 pm

Hey Derek, it might be your Google Apps account actually. Do you have another Apps or Gmail account you could try from?

Free SEO Tools

RankTank uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More