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.
Extract Sitemap Data For Spreadsheet Review
- Navigate to yourdomain.com/sitemap.xml in a web browser
- Right-click the page and select 'Save As' to download the raw file
- Upload the saved XML file into the conversion tool interface
- Wait for the system to parse 12,500 URLs and extract 4 data columns
- Download the resulting CSV file containing loc, lastmod, changefreq, and priority values
Sitemap Index Files Versus Individual Sitemaps
This tool processes individual sitemap files, not sitemap index files. A sitemap index lists other sitemap files and does not contain URLs directly. If your sitemap.xml contains a sitemapindex tag, download the individual sitemaps listed inside it. Large sites split sitemaps into multiple files; process each separately. For sitemap index files, adjust the root path to 'sitemapindex.sitemap' to extract the list of sitemap URLs.
Understanding Sitemap Data Structures
Standard sitemaps produce four columns: loc (the full URL), lastmod (last modification date), changefreq (how often the page changes), and priority (value from 0.0 to 1.0). Not all sitemaps include every field; many omit changefreq and priority. The CSV output contains only the columns present in your source file. Image and video sitemaps include additional nested fields that the processor flattens into extra columns automatically.
XML Format Versus CSV Spreadsheet
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)
- Root Path
- urlset.url
- Extracted Fields
- loc lastmod changefreq priority
- Output Formats
- CSV Excel
- Processing Mode
- Client-side
Best Practices
- Root path urlset.url is pre-configured for standard XML sitemaps
- Download as Excel for sitemaps with 1000+ URLs to simplify sorting
- Compare sitemaps before and after migration using VLOOKUP to find missing URLs
- Nested image or video 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.
Related Guides
Convert RSS Feed to CSV Spreadsheet
- RSS 2.0, Atom
- CSV, Excel
- Client-side
Convert Nested API JSON Response to CSV Spreadsheet
- JSON File
- Auto-Detect
- Configurable
Convert Stripe JSON Export to CSV Spreadsheet
- Stripe JSON Export
- Nested Objects With Dot Notation
- CSV Or Excel
Convert to JPG
- JPG JPEG PNG WebP
- 1% to 100%
- Solid Background Color
Convert to PNG
- PNG
- Lossless DEFLATE
- 8-bit Alpha Channel
Convert Binary to Decimal for Programming: Debug Bitwise Operations
- Binary → Decimal
- Bitwise operations, flag debugging
- 64 bits (JavaScript safe integer)
Convert HEX Color Codes to Decimal RGB for Web Development
- Hex → Decimal
- CSS colors to RGB, Canvas API
- FF5733 or #FF5733 (both accepted)
Number Base Converter: Binary Hex Decimal Octal ASCII Text
Convert Unix File Permissions: Octal to Binary Chmod Values
- Octal → Binary
- Unix file permissions (chmod)
- 3-digit octal (755, 644, 777)
Decode ASCII from Hex Network Protocols and Packet Dumps
- Hex To ASCII
- Network Packet Analysis
- Space Separated Hex Bytes
Bra Size Converter: cm to Inches
- divide EU band by 2.54, add 0–4 inches depending on brand
- US/UK 32 (traditional) or 30 (modern fit)
- US/UK 34 (traditional) or 32 (modern fit)
Bracelet Size cm to Inches
- inches = centimeters ÷ 2.54
- 7 in = 17.78 cm
- 8.5 in = 21.59 cm
Chain Length Inches to Centimeters
- cm = inches × 2.54
- 40.64 cm — sits at collarbone
- 45.72 cm — below collarbone
Chest Size cm to Inches
- inches = cm ÷ 2.54
- ~84cm = 33 in
- ~88–92cm = 35–36 in
Convert Centimeters to Feet
- feet = centimeters ÷ 30.48
- 0.032808 feet
- 30.48 cm (exact, defined)
Convert Centimeters to Inches
- inches = centimeters ÷ 2.54
- 0.393701 inches
- 2.54 cm (exact, defined)
Convert Centimeters to Millimeters
- millimeters = centimeters × 10
- 10 mm (exact)
- 0.1 cm (exact)
Collar Size cm to Inches
- inches = centimeters ÷ 2.54
- 15.0 in (US size 15)
- 15.4 in (US size 15½)
Drill Bit Size Inches to Millimeters
- mm = inches × 25.4
- 1.588 mm
- 3.175 mm