Template
Technical SEO Template
Record crawl and indexing checks URL by URL: status codes, indexability, canonicals, sitemap coverage and fixes.
TemplateSpreadsheetAdvanced
Description
Technical issues are easiest to fix when each one is tied to a URL and a clear next step. Export your crawler results into this layout to keep findings consistent.
Use case
Use it after a site crawl, during a migration, or when pages are not showing up in search.
Instructions
- Crawl the site with your crawler of choice and export all HTML URLs.
- Flag non-200 status codes, noindex tags and canonicals that point elsewhere.
- Compare against the XML sitemap: indexable pages should be in it; redirects and 404s should not.
- Check Search Console’s page indexing report for URLs Google could not index.
- Write one fix per row and set priority by how important the page is.
Preview
Column headers with example rows. Replace the examples with your client’s data.
Example rows use a fictional client. Replace them with real data from your tools.
| Row | URL | Status code | Indexable? | Canonical | In sitemap? | Robots meta | Issue | Priority | Fix |
|---|---|---|---|---|---|---|---|---|---|
| 2 | /shop/blue-mug/ | 200 | Yes | Self | Yes | index, follow | None | ||
| 3 | /shop/blue-mug?color=navy | 200 | No | /shop/blue-mug/ | No | index, follow | Parameter duplicate (handled by canonical) | Low | No action |
| 4 | /sale/ | 404 | No | Yes | Broken page listed in sitemap | High | Remove from sitemap and redirect to /shop/ | ||
| 5 | /old-shipping/ | 301 | No | No | Redirect chain (301 > 301 > 200) | Medium | Point the redirect straight to the final URL |
Download
A CSV file that opens in Google Sheets, Excel or Numbers. Keep the header row, delete the example rows and add your own.
Download template (CSV)SOPs that use this template
- SOP SOP: Technical SEO Crawl Check Crawl a site, find the issues that block crawling and indexing, and turn them into a…
Practice with it
- Assignment Audit a small online store for crawl errors Use a crawl export to find broken links, redirect chains, and indexing problems, then write a…
My notes
Keep private notes next to anything you read or practice.
Log in to take notes