Last Updated on October 31, 2022 by Jake Sheridan
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.
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.
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.
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.
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.
Meta Data Audit Template
Use this template (+ Search Console, Slack & some writing skills) to improve your CTR by optimising your page titles and descriptions.
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.
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.
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 →