Sitemap to CSV Converter

Parse an XML sitemap by entering its URL or pasting the XML directly. Works with sitemap indexes and .xml.gz files. Image counts, hreflang, news and video details are added as extra CSV columns when present.

Why Use the Sitemap to CSV Converter?

Need to audit your sitemap or analyze URL data in a spreadsheet? This tool parses XML sitemaps and exports all URLs with their metadata (lastmod, changefreq, priority) into a CSV file you can open in Excel, Google Sheets, or any data tool. Learn why regular sitemap audits are important in our XML Sitemaps for SEO guide.

Don't have a sitemap yet? Create one with our Sitemap Generator, then run it through the Sitemap Validator to check for issues before deploying.

Example Input

Enter a sitemap URL or paste the XML directly:

<?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-01-15</lastmod>
    <priority>1.0</priority>
  </url>
  <url>
    <loc>https://example.com/blog</loc>
    <lastmod>2026-03-01</lastmod>
    <priority>0.8</priority>
  </url>
</urlset>

Example Output

The converter produces a CSV table:

URL,Last Modified,Change Frequency,Priority
https://example.com/,2026-01-15,,1.0
https://example.com/blog,2026-03-01,,0.8