01 // SITEMAP → CSV
Sitemap to CSV.
Turn any XML, HTML or text sitemap into a spreadsheet-ready CSV. Sitemap-index files are followed automatically — you get one flat, deduped file.
Supports XML sitemaps, sitemap-index files (auto-followed), HTML site indexes and plain-text URL lists.
Why CSV?
CSV is the universal "give me the URLs" format. Spreadsheets, BI tools, BigQuery, dbt, Screaming Frog list mode, custom scripts — they all ingest it without fuss. If you want richer typing pick Excel or JSON, but CSV is the easiest thing to pipe into anything else.
Common use cases
- Bulk-importing a competitor's URL set into Ahrefs / Screaming Frog
- Diffing old vs. new sitemap snapshots
- Feeding URLs into a content audit spreadsheet
- Sending to Google Sheets via a paste / Drive upload
- Building a custom crawler queue
Frequently asked
FAQ
What columns does the CSV include?
At minimum:
URL. If the sitemap includes lastmod, changefreq or priority, those become extra columns. For sitemap-index conversions an additional Source Sitemap column is added so you can trace each URL back to the child sitemap it came from.Can I open the CSV in Google Sheets or Excel?
Yes — UTF-8, comma-separated, fields with commas/quotes properly escaped. Drop it straight into Sheets, Excel, Numbers or any database tool.
What if my sitemap is a sitemap-index?
It's auto-followed: we fetch every child sitemap (up to 50 in parallel) and merge all URLs into the same CSV.
Is there a row limit?
No row limit — only the 25 MB upload limit per file or fetched sitemap. For multi-million-URL crawls, point at the index.