Why extract sitemap URLs
A sitemap is the closest thing to an official list of a site's pages. Pulling it into a spreadsheet is the quickest way to start a lot of SEO jobs:
- Content audits. List every page, then add traffic and rankings next to each one to find what to update, merge or delete.
- Migrations. Before you change URLs, export the old list so you can map each one to its new home and test the redirects afterwards with the redirect checker.
- Competitor research. See how many pages a competitor has in each section, and what they published recently from the lastmod dates.
- Bulk checks. Feed the list into a crawler, a broken link check or an indexing check.
How the extractor works
Enter a sitemap URL, or a domain and we find its sitemap from robots.txt, /sitemap.xml or /sitemap_index.xml. A plain <urlset> gives its URLs directly. A <sitemapindex> is followed into its child sitemaps, up to 10 per run. Gzipped .xml.gz files are decompressed on the fly. Duplicate URLs are removed.
Each run returns up to 5,000 URLs. For a larger site, paste the URL of one child sitemap at a time to export each section separately.
The CSV
The download has three columns: url, lastmod (blank when the sitemap does not give one) and sitemap, the file the URL came from. It opens in Excel, Google Sheets or Numbers as is.
To check the sitemap itself (structure, limits and lastmod coverage), use the sitemap checker.