Free sitemap to CSV converter
Paste a sitemap or upload the file, and get a CSV in your browser. Nothing is sent to us. To get the file, open the sitemap in your browser (try /sitemap.xml, or the Sitemap line in /robots.txt), then copy all of it or save it.
Have a sitemap index with dozens of child files, many sites, or want it to run every week? That is what the paid Sitemap URL Extractor below is for.
How to export a sitemap to CSV
- Open the Sitemap URL Extractor on Apify.
- Enter the website's homepage, or the sitemap address if you already know it. You can add several sites at once.
- Leave sitemap discovery on. The tool reads robots.txt and tries the common sitemap paths.
- Optionally set a maximum number of URLs, or patterns to keep or drop.
- Run it, then export the results as CSV, Excel or JSON.
Why not just open the sitemap in a browser?
For a small site you can. But big sites rarely have one simple file. A store might have a sitemap index that points to product, category and blog sitemaps, some of them gzip compressed, each holding thousands of entries. Copying those by hand is slow and it is easy to miss a file. The extractor walks the whole tree, removes duplicates, and keeps the lastmod date and the sitemap each URL came from, so you can see what changed recently and where it lives.
What you get for each URL
- url: the page address.
- lastmod, changefreq and priority: whatever the site put in its sitemap, or empty if it left them out.
- sourceSitemap: the exact sitemap file the URL was found in.
- status: ok, or an error row explaining why a sitemap could not be read. Error rows are free.
A real sample
A run on November 11, 2026 against sitemaps.org and crawlee.dev returned 40 URLs from three sitemap files. These are the first rows as CSV:
url,lastmod,changefreq,priority,sourceSitemap
https://www.sitemaps.org/,2016-11-21,,,https://www.sitemaps.org/sitemap.xml
https://www.sitemaps.org/protocol.html,2022-12-15,,,https://www.sitemaps.org/sitemap.xml
https://www.sitemaps.org/faq.html,2016-11-21,,,https://www.sitemaps.org/sitemap.xml
https://crawlee.dev/blog,,weekly,0.5,https://crawlee.dev/sitemap.xml
https://crawlee.dev/blog/archive,,weekly,0.5,https://crawlee.dev/sitemap.xml
https://crawlee.dev/python/blog,,weekly,0.5,https://crawlee.dev/python/sitemap.xmlNotice that the two sites fill in different fields. sitemaps.org gives a lastmod date and nothing else, while crawlee.dev gives changefreq and priority but no dates. The extractor keeps whatever is there and leaves the rest blank, so your columns always line up.
What people do with the list
Common next steps are checking every page for speed with the bulk Core Web Vitals checker, auditing them with the SEO audit, planning redirects before a site migration, or comparing a competitor's pages month to month.
How it compares
| Tool | What it handles | Price |
|---|---|---|
| Our free converter above | One pasted or uploaded file, in your browser | Free |
| SitemapForge | Paste, upload or fetch by URL (4 MB per fetched file), follows up to 40 child sitemaps | Free |
| GSCTool sitemap extractor | Up to 200,000 URLs a run | Free |
| Sitemap URL Extractor (we built it) | Finds the sitemap through robots.txt, follows every nested index, unpacks .gz, many sites per run, filters, API and schedules | $0.50 per 1,000 URLs kept |
Prices and limits are from each company's public page, checked November 11, 2026. If one has changed, email [email protected] and we will fix it.
Our honest take: for one sitemap, use a free tool, ours above included. The paid extractor is worth it when you need many sites at once, include and exclude filters, or a list that refreshes on a schedule and feeds another tool, like our bulk PageSpeed or SEO audit tools.
What it costs
$0.50 per 1,000 URLs kept. A 2,000 URL site costs $1.00. URLs you filter out, and sitemaps that fail, are free. Set a maximum number of URLs if you want a hard cap.
Open the Sitemap URL Extractor
Questions
Where do I find a website's sitemap?
Look at the site's robots.txt file, for example example.com/robots.txt. It usually has a line that starts with Sitemap: and gives the address. If not, try /sitemap.xml or /sitemap_index.xml. The extractor checks all of these for you.
What is a sitemap index?
Large sites split their sitemap into many files and list them in an index file. Opening the index only shows you more sitemap addresses, not pages. The extractor follows every nested file until it reaches the page URLs.
Can it read .xml.gz files?
Yes. Gzip compressed sitemaps are unpacked automatically.
Can I keep only some URLs?
Yes. Add include or exclude patterns, for example only URLs under /blog/, and the rest are dropped before you are charged.
Does every page appear in the sitemap?
Not always. A sitemap lists what the site owner chose to list. Our guide on finding every page on a website covers ways to catch the rest.
Is there a free way to convert a sitemap to CSV?
Yes. Paste the sitemap into the free converter at the top of this page and download the CSV. It runs in your browser, so nothing is uploaded. For a sitemap index it lists the child files, which you can open and convert one by one.