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

Validate every hreflang relationship: alternate status, self-reference, return tags, canonical match and locale codes.

What it decides
  Which hreflang relationships pass every check and which need fixing, with the number of failed checks per alternate.

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

Quick start
  1. Export hreflang annotations: Crawl your site and export each page with its declared alternates and locale codes, from HTML, headers or sitemaps.
  2. Add one row per relationship: Each row is one page and one alternate, with the alternate's status code.
  3. Score the five checks: Mark self-reference, reciprocal, canonical match and locale valid as 1 or 0. Use the dropdown for common codes.
  4. Fix by pattern: Failures usually repeat by template or locale. Fix the template, then re-crawl.

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/hreflang-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
