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

Reconcile sitemap URLs against status, canonical, robots and noindex to see what to add, remove or fix.

What it decides
  Which URLs should be removed from your XML sitemap (or fixed), which eligible URLs are missing from it, and which are fine.

Files
  XML Sitemap Audit Template.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  XML Sitemap 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, Listed in sitemap, HTTP status, Canonical URL
  Full steps: HOW-TO-USE-WITH-DATAFORSEO.txt (also in the Automation folder), with example-request.json

Quick start
  1. Parse your sitemaps: Extract every URL from the sitemap index and child sitemaps. Mark in_sitemap = 1.
  2. Add crawled URLs not in the sitemap: From a full crawl, add indexable URLs that aren't listed. Mark in_sitemap = 0.
  3. Record observed signals: Status code, canonical, robots allowed, noindex and whether you intend the page to be indexed.
  4. Fix at the generator: Most sitemap errors come from the generator logic. Fix the rule, not the file.

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/xml-sitemap-audit-template/
Part of the Technical SEO Toolkit: https://optimizationtheory.com/download-view/technical-seo-toolkit-6-audit-and-validation-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
