On-page Duplication Analysis (Google Sheets Template)

Duplicate and near-duplicate titles, meta descriptions and headings make it harder for search engines to tell your pages apart, and page query overlap means several pages compete for the same searches. This Google Sheets template by Lazarina Stoy combines a Screaming Frog crawl with Search Console query data (exported with the Search Analytics for Sheets add-on) to surface all three in one place.

Paste in your Screaming Frog internal HTML export, which includes titles, meta descriptions, H1s and H2s with their lengths, indexability and canonicals, plus your Search Console page and query data, and the template helps you identify:
‧ Page query overlap: pages ranking for the same queries
‧ Exact duplication of on-page elements such as titles and headings
‧ Near duplication of those elements, where pages differ only slightly

Use this for:
‧ Duplicate content audits and cannibalisation checks
‧ Prioritising which titles, meta descriptions and headings to rewrite first
‧ Building a case for consolidating or differentiating overlapping pages

This is perfect for SEO consultants running technical or content audits who want a quick, spreadsheet-based duplication check before moving to similarity scoring with fuzzy matching or embeddings.