RunOfflineTools Logo RunOfflineTools
πŸ—ΊοΈ Perfect for SEO Audits β€’ Fast Extraction

XML Sitemap to CSV Converter

Easily extract all URLs and metadata from your XML sitemap into a structured CSV file for SEO audits, Google Sheets, or Excel.

How to Convert an XML Sitemap to CSV

Extracting URLs from a sitemap is a critical workflow for technical SEOs and webmasters. Our tool makes it instant:

  1. Choose your input method: You can either paste a direct link to a live sitemap (e.g., https://example.com/sitemap.xml) or paste the raw XML code directly.
  2. Click Extract: The tool will parse the XML tree and identify all <url> nodes or <sitemap> nodes if it is an index file.
  3. Download or Copy: The output is instantly formatted as comma-separated values, ready to be opened in your favorite spreadsheet software.

What Data is Extracted?

Depending on the type of sitemap provided, the CSV will contain the following columns:

  • Location (URL): The absolute URL of the page or sub-sitemap.
  • Last Modified: The <lastmod> date indicating when the page was last updated.
  • Change Frequency: (Standard sitemaps only) How often the page is expected to change (e.g., daily, weekly).
  • Priority: (Standard sitemaps only) The relative priority of the URL compared to other pages on your site.

Frequently Asked Questions

What does a Sitemap to CSV converter do?

This tool takes an XML sitemap (either via a live URL or raw pasted XML data) and extracts all the URLs, last modified dates, change frequencies, and priorities into a clean, structured CSV format.

Can it handle sitemap index files?

Yes! If you input a sitemap index file (which contains links to other sitemaps instead of webpage URLs), the tool will automatically detect it and extract the sitemap URLs and their last modified dates.

Why should I convert my sitemap to CSV?

Converting an XML sitemap to a CSV file allows you to easily open your website's architecture in Excel or Google Sheets. This is extremely useful for SEO audits, content migrations, URL mapping, and finding orphaned pages.

Are there any limits on the number of URLs?

Since the XML parsing happens directly in your browser using JavaScript, there are no hard limits. However, extremely large sitemaps (over 50,000 URLs) might cause your browser to slow down momentarily while parsing.