Sitemap extractor
Extract page URLs, count entries, and export a CSV you can open in Excel.
Pasted and uploaded XML is processed in your browser. It is not sent to the server.
How to extract sitemap URLs
- Enter the exact public XML sitemap URL, or paste/upload its XML.
- For a sitemap index, load the direct children to collect page URLs.
- Filter the results and choose whether to remove exact duplicate URLs.
- Download the matching rows as CSV.
Limits and what the count means
A remote file is limited to 2 MB; local XML to 5 MB. Extraction supports the standard XML sitemap namespace, up to 50,000 combined entries and up to 10 direct child files per batch. Nested indexes, gzip files, feeds, and text sitemaps are not expanded. Failed or skipped children make the result partial.
Counts describe extracted entries, not Google's index and not every page on a site. The tool does not crawl the listed pages or check their canonical targets. Uploaded and pasted files stay in your browser. URL fetching sends the selected sitemap URL to the server.
Fix a sitemap before counting it
Sitemap could not be read: response and XML diagnosis
Astro sitemap configuration and child files
Sitemap submitted but pages not indexed
Frequently asked questions
Does this submit URLs to Google? No. It reads the XML and exports a list. Submitting is a separate step in Search Console or through the sitemap report.
Why does the count not match Search Console? The tool counts entries it could parse from the files you loaded. Search Console reports what Google fetched and processed, which can differ after redirects, blocks, or child failures.
What if a child sitemap fails? The result is partial. Open the failing child directly; see sitemap index child errors.
Where do the common sitemap errors go? Can be read but has errors, could not fetch, and 0 URLs discovered each explain one status.