Sitemap to Excel: convert an XML sitemap to a spreadsheet

Paste the XML of a sitemap (or a sitemap index) below. You get every URL with lastmod, changefreq and priority, and a CSV file that Excel opens directly.

Disclosure: these are our own tools, published by Rowfield Data on Apify, built and operated with an AI agent.

How to get it into Excel

1. Open https://the-site.com/robots.txt and look for Sitemap: lines. If there are none, try /sitemap.xml or /sitemap_index.xml.
2. Open the sitemap URL in your browser, view the source, select all, copy, and paste it above. Or use open a file for a saved .xml file.
3. Press Get URLs, then Download CSV.
4. Open the downloaded .csv file in Excel (double-click it, or File, Open). Each column becomes a spreadsheet column: loc, lastmod, changefreq, priority. Save as .xlsx if you want an Excel workbook.
5. Only need the URLs in one column? Press Copy URLs and paste into cell A1.

If you paste a sitemap index, you get the list of child sitemaps. Open each child sitemap and paste it in turn.

What this free tool does not do

• It does not download sitemaps for you, follow indexes, or read .gz files. This page makes no network requests on purpose.
• It writes a CSV file, not an .xlsx file. Excel opens the CSV as a sheet.

For whole sites or many domains: export straight to Excel

Our Sitemap URL Extractor & Scraper on Apify fetches the sitemaps for you. Give it domains; it finds their sitemaps in robots.txt, reads sitemap indexes (nested up to 5 levels), gzipped (.gz) and plain-text sitemaps, and returns one de-duplicated row per URL. Export the dataset as Excel, CSV or JSON, or use the API.

• Filters: include or exclude by path regex, keep URLs changed on or after a date (lastmodAfter), cap URLs per domain and per run.
• Price: pay per result, $0.25 per 1,000 URLs ($0.00025 per URL) plus $0.00005 per run start. Status rows and URLs removed by your filters are not charged.

Prefer CSV? The same free tool is on Sitemap to CSV.

Open Sitemap URL Extractor on Apify