Indexability Audit Template (Optimization Theory, v3.0, November 2026)
=================================================================

Check status, robots, noindex and canonical on every page you want indexed, then see exactly what to fix first.

What it decides
  Which pages that should be indexed have a technical conflict, which are technically fine but still not indexed, and which were never meant to be indexed.

Files
  Indexability Audit Template.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  Indexability Audit Template - Field Guide.pdf  the illustrated guide
  Input-Template-blank.csv ..... column headers in paste order
  Input-Template-example.csv ... the worked example (Northbeam Outdoor, fictional data)
  HOW-TO-USE-WITH-DATAFORSEO.txt step-by-step: request, save, convert, complete, paste
  Automation/ .................. import script, example request, field mapping (python3 Automation/dataforseo_import.py --help)

Built to run on DataForSEO
  Source: DataForSEO On-Page API
  Fills automatically: Page URL, HTTP status, Declared canonical
  Full steps: HOW-TO-USE-WITH-DATAFORSEO.txt (also in the Automation folder), with example-request.json

Quick start
  1. List URLs and your intent: Include pages you want indexed and the ones you don't. Mark intended indexable as 1 or 0.
  2. Crawl for technical signals: Record status code, whether robots.txt allows crawling, whether the page has noindex, and its canonical URL.
  3. Add indexing status: Use URL Inspection or the page indexing report to record whether Google has indexed the URL (1/0).
  4. Work the queue in order: Fix technical conflicts first, then investigate indexing on technically ready pages, then confirm exclusions.

Works in Microsoft Excel, Google Sheets (upload, then open with Sheets) and LibreOffice Calc.
Paste values only at Workspace cell A13. Lime cells are inputs; blue cells are formulas.

Full tutorial: https://optimizationtheory.com/download-view/indexability-audit-template/
Part of the SEO Migration Toolkit: https://optimizationtheory.com/download-view/seo-migration-toolkit-6-planning-and-qa-workbooks/
All 40 templates: https://optimizationtheory.com/download-view/free-seo-geo-toolkit-40-spreadsheets-and-field-guides/

Free to use in your own and client work. Please don't resell the templates themselves.
Built by Jourdan Rombough, optimizationtheory.com
