On-Page SEO Templates

Last Updated on October 31, 2022 by Jake Sheridan

Want to spend less time checking on-page SEO and more time actually making optimisations? Try these on-page Google Sheets templates.

On-page optimisation sounds cooler than obsessing over character length, improving user engagement and messing with formatting.

Put the things that don’t matter to one side and tackle the things that will move the needle with these on-page SEO tools.

Google Sheets On-Page Optimisation Templates

Checkout these Google Sheets On-Page Optimisation Templates:

HTML Table of Contents Generator

Generate a simple HTML table of contents to add to WordPress posts to help improve the UX of guides, FAQ pages or any long form content.

Grab the sheet

Rich Snippet & Live Meta Testing Tool

Use this sheets tool to quickly see how rich snippets and meta data are being indexed in Google for any site.

Grab the sheet

Title and Meta Tag Verifier

Using this Google Sheets tool, you can paste in URLs and automatically pull the title tags and meta descriptions for them.

Grab the sheet

On-Page SEO Checklist Automation Template

This Google Sheets template automates most of the boring on-page SEO checks so you can optimize what is important and automate the rest.

Grab the sheet

Title & Description Low Hanging Fruit Template

This sheet shows queries and landing page combinations that receive a high number of impressions but have a low CTR. It also pulls in title tag, meta description and character counts, so you can quickly see which search snippets can be improved to increase CTR.

Grab the sheet

Meta Data Audit Template

Use this template (+ Search Console, Slack & some writing skills) to improve your CTR by optimising your page titles and descriptions.

Grab the sheet

Title Pixel Length Checker

This sheet helps you identify page titles that under-optimised or too long for SERPs by working out the real meta title length.

Grab the sheet

SEO Optimization Verification Template

Use this sheet to track any URL you want to optimize, including the character count of titles and descriptions and when optimizations don’t match the data on the site.

Grab the sheet



On-Page Optimisation Sheets for Marketers 🔥

Think I’ve missed a Google Sheets On-Page Optimisation Template? Or maybe you’ve built something yourself that isn’t on the list? Just let me know and I’ll add it.

‼️ I did not make these templates, I only collected them & presented them here. The creators are the ones linked to. Again, I do not own (or claim to) any of these sheets.‼️

Don’t forget to go check out the other Google Sheets Templates →