Find URLs that should have a hreflang tag – Indexable URLs
Crawl the website with Screaming Frog
Download the “internal” report on first tab
Filter relevant columns to find all URLs that return 200 (Status Code), are indexable (Indexability)
Paste the filtered sheet into a new tab/sheet and delete irrelevant columns so you just have URL and Canonical columns
Use =Exact formula to find all URLs that match the canonical URL
Filter Canonical URL column to “true”
You should be left with all URLs that are indexable – i.e. 200 status codes and URLs that exactly match canonical URLs.
Copy all the URLs that remain
Find Missing Hreflangs – Paste Back into Screaming Frog in List Mode
Use List Mode and Copy the URLs into screaming frog and crawl.
Check the crawl and go to the hreflang tab – order by hreflang “Occurences”
Export hreflang
