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.

Sitemap XML
<?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>
CSV output
loc,lastmod,changefreq,priority
https://example.com/,2026-09-30,,1.0
https://example.com/pricing,,monthly,

How to use Sitemap to CSV

  1. 1

    Paste sitemap XML, upload an .xml file, or enter a sitemap URL and fetch it.

  2. 2

    If the fetch is blocked by CORS, paste the XML or add a proxy URL.

  3. 3

    Check the row count and columns in the CSV output.

  4. 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.

Other tools in the same category

Search all tools