Sitemap to CSV
Convert an XML sitemap (urlset) or sitemap index into CSV with loc, lastmod, changefreq, and priority columns. Paste XML, upload a file, or fetch from a URL.
If the sitemap blocks browser requests, run CORS Anywhere or another proxy and paste its URL here. Use a prefix such as https://proxy.example.com/ or a query form ending in ?url= or {url}.
Drop a file or click to browse
or paste data below
How Sitemap to CSV works
What gets extracted
A standard sitemap (<urlset>) produces one row per <url> entry, with four columns: loc, lastmod, changefreq, and priority. Optional fields that an entry lacks are left blank, and entries without a loc are skipped. Namespace prefixes are ignored, so sitemaps written with sm:url-style tags work as well.
A sitemap index (<sitemapindex>), the file large sites use to list their child sitemaps, produces one row per child sitemap with its loc and lastmod. Fetch or paste each child sitemap to get its page URLs. Image, video, and news extensions inside entries are not extracted.
Fetching by URL
You can enter a sitemap URL instead of pasting XML. The request is made by your browser, so it only succeeds when the site allows cross-origin requests (CORS). Many sites do not. When the browser blocks the request, the tool explains this, and you can either open the sitemap in a new tab and paste its contents, or enter a CORS proxy that you run or trust.
A proxy can be a CORS Anywhere-style base URL, a query-style URL ending in ?url=, or a template containing {url}. Requests go from your browser to that proxy, not through RividTech. Gzipped sitemaps (.xml.gz) need to be decompressed before pasting.
What to do with the CSV
A sitemap as a spreadsheet is the starting point for many SEO checks. Sort by lastmod to find stale pages, filter by path in Data Process to count URLs per section, or compare two exports to see which URLs were added or removed after a release. Loading two exports into DB in Browser makes that comparison a single LEFT JOIN.
Example
Every row has all four columns; fields an entry does not include are left blank.
<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
<url>
<loc>https://example.com/</loc>
<lastmod>2026-09-30</lastmod>
<priority>1.0</priority>
</url>
<url>
<loc>https://example.com/pricing</loc>
<changefreq>monthly</changefreq>
</url>
</urlset>loc,lastmod,changefreq,priority
https://example.com/,2026-09-30,,1.0
https://example.com/pricing,,monthly,How to use Sitemap to CSV
- 1
Paste sitemap XML, upload an .xml file, or enter a sitemap URL and fetch it.
- 2
If the fetch is blocked by CORS, paste the XML or add a proxy URL.
- 3
Check the row count and columns in the CSV output.
- 4
Copy the CSV or download sitemap.csv.
When to use it
Content and SEO audits
List every URL a site declares, then sort and filter to find stale, missing, or duplicate pages.
Migration planning
Build a URL inventory to map old pages to new ones before a site migration.
Sitemap to CSV questions
Why does fetching my sitemap fail?
Browsers block cross-origin requests unless the site sends CORS headers. Open the sitemap in a new tab, copy the XML, and paste it instead.
Does it follow child sitemaps in an index automatically?
No. An index produces a list of child sitemap URLs; fetch or paste each one to extract its pages.
Can it read sitemap.txt or RSS feeds?
No. Only XML sitemaps with a urlset or sitemapindex root are supported.
Questions about privacy, file size, or accounts are answered on the FAQ page.
More clean & transform
Other tools in the same category
Data Process
Search, filter, sort, and rearrange CSV, TSV, or JSON data, then export exactly the view you built
Remove Duplicates
Remove duplicate rows from CSV, TSV, or JSON, matching on all columns or only the key columns you choose
CSV to Excel
Turn CSV or TSV into an .xlsx workbook that keeps leading zeros and long IDs intact
CSV & TSV Preview
View CSV or TSV as a readable table and export the table as an image