Select Files
or drag and drop files here
Upload an XML file
The Challenge
XML sitemaps are structured for search engines, not humans. Reviewing URLs, checking lastmod dates, auditing priority values, or comparing sitemaps requires extracting data into a spreadsheet. Copying URLs manually from XML is tedious and error-prone. Most XML-to-CSV tools don't know the sitemap structure and produce mangled output with namespace prefixes and wrapper nodes.
Why convert your XML sitemap to CSV
SEO audits require reviewing every URL in your sitemap — checking for outdated pages, missing URLs, incorrect lastmod dates, and wrong priority values. A CSV spreadsheet lets you sort, filter, and compare URLs in Excel or Google Sheets. Compare two sitemaps side by side to find removed or added pages. Filter by lastmod to find stale content. Audit priority values to ensure important pages are weighted correctly. None of this is practical in raw XML format.
Sitemap index files vs individual sitemaps
- This tool processes individual sitemap files — not sitemap index files
- A sitemap index (sitemapindex) lists other sitemap files — it doesn't contain URLs directly
- If your sitemap.xml contains <sitemapindex>, download the individual sitemaps listed inside it
- Large sites split sitemaps into multiple files (sitemap-posts.xml, sitemap-pages.xml) — process each separately
- For sitemap index files, adjust the root path to 'sitemapindex.sitemap' to extract the list of sitemap URLs
How to download your XML sitemap
- Most sitemaps are at yourdomain.com/sitemap.xml — open this URL in your browser
- WordPress sites with Yoast: sitemap is at /sitemap_index.xml (index file) with individual sitemaps linked inside
- Right-click the page and select 'Save As' or 'Save Page As' — save as .xml file
- Alternative: use curl 'curl https://yourdomain.com/sitemap.xml -o sitemap.xml'
- For password-protected staging sitemaps, view source in browser and save the XML content as a .xml file
- Upload the saved .xml file to this tool — the urlset.url path is pre-configured
SEO audit tasks this enables
- List all indexed URLs to verify nothing is missing from the sitemap
- Filter by lastmod date to find pages not updated in 6+ months
- Check priority values to ensure key pages have higher priority than utility pages
- Compare two sitemap exports to find added or removed URLs after a migration
- Identify duplicate URLs or URL variations (www vs non-www, trailing slashes)
- Bulk check URLs against Google Search Console indexed pages
- Share URL inventory with clients or team members in spreadsheet format
Columns in your sitemap CSV
Standard sitemaps produce four columns: loc (the full URL), lastmod (last modification date), changefreq (how often the page changes — daily, weekly, monthly), and priority (value from 0.0 to 1.0). Not all sitemaps include every field — many omit changefreq and priority. The CSV will only contain columns that exist in your sitemap. Image sitemaps and video sitemaps include additional nested fields which are flattened into extra columns automatically.
Step-by-Step Workflow
Download sitemap.xml from your site
Upload sitemap file
URLs are extracted automatically with root path pre-set
Download as CSV or Excel
Specifications
- Input Format
- XML sitemap (.xml) — standard sitemap protocol
- Root Path
- urlset.url (pre-configured)
- Extracted Fields
- loc (URL), lastmod, changefreq, priority
- Output Formats
- CSV or Excel (.xlsx)
- Sitemap Index
- Process individual sitemaps — not sitemap index files
- Processing
- 100% client-side — sitemap data stays in your browser
Best Practices
- Root path 'urlset.url' is pre-configured — works with all standard XML sitemaps immediately
- For sitemap index files, change root path to 'sitemapindex.sitemap' to extract the list of child sitemap URLs
- Download as Excel for sitemaps with 1000+ URLs — easier to sort and filter than CSV in some editors
- Compare sitemaps before and after site migration — export both to CSV and use VLOOKUP to find missing URLs
- If your sitemap includes XML namespaces (image:image, video:video), nested fields are flattened with dot notation automatically
Frequently Asked Questions
How do I convert an XML sitemap to CSV?
Download your sitemap.xml file and upload it here. The tool is pre-configured with the correct root path (urlset.url) for standard sitemaps. All URLs, dates, and priority values are extracted into a flat CSV instantly. Download as CSV or Excel.
Does this work with WordPress sitemaps?
Yes. WordPress sitemaps (from Yoast, Rank Math, All in One SEO, or core WordPress) all follow the standard sitemap protocol. Download the individual sitemap file (not the sitemap index) and upload it. The urlset.url path works with all compliant sitemaps.
Can I process a sitemap index file?
A sitemap index lists other sitemaps — it doesn't contain page URLs directly. You can change the root path to 'sitemapindex.sitemap' to extract the list of child sitemap URLs. Then download and process each individual sitemap separately.
What if my sitemap has thousands of URLs?
The tool processes sitemaps of any size in your browser. Large sitemaps (10,000+ URLs) may take a few seconds. The output CSV or Excel file will contain every URL with all available fields. For very large sites, process individual sitemaps rather than trying to combine them before upload.
Why are some columns missing in my output?
Not all sitemaps include lastmod, changefreq, and priority. Many generators only output the loc (URL) field. The CSV reflects exactly what your sitemap contains. If you need lastmod dates, configure your CMS sitemap plugin to include modification dates.