XML to CSV Converter
Use this tool to convert XML into CSV (Comma Separated Values) for Excel
This free online converter transforms XML into clean CSV that opens directly in Excel, Google Sheets, and other spreadsheet apps. Paste your XML, upload a file, or enter a URL — the tool handles nested elements, attributes, and repeated records, and works with common XML sources like sitemaps, RSS and product feeds, WordPress exports, and bank or government data files.
- Upload your XML text, file or URL into this online converter
- (Press the cog button on the right for advanced settings)
- Download the resulting CSV file when prompted
- Open your CSV file in Excel, Google Sheets, or another spreadsheet app
Frequently asked questions
What XML formats does this converter support?
The tool works with standard XML files, including data exports, API responses, RSS and product feeds, sitemaps, and structured documents. Both single-record and multi-record files convert cleanly into rows and columns.
Can I convert a sitemap.xml file to CSV?
Yes. Paste your sitemap URL or upload the file, and each <url> entry becomes a row with
<loc>, <lastmod>, and any other child elements as columns.
This is a common way to audit pages, last-modified dates, and indexed URLs.
Does this work with WordPress XML exports?
Yes. WordPress WXR exports are XML, so you can paste or upload your export file and convert it to CSV. Each post, page, or comment becomes a row with title, content, author, and other fields as columns.
How are XML attributes converted to CSV columns?
Attributes are preserved as their own columns alongside the element’s text and child values, so no data is lost.
For example, <item id="42" stock="ok"> will produce columns for both id and stock.
What happens when XML elements are deeply nested?
You choose how nested data is handled in the settings panel (cog icon): keep child elements on the same row as extra columns, expand them into separate rows, concatenate them inside a single cell, or output a matrix-style layout. Pick the option that matches how you want the spreadsheet to look.
Can I convert XML directly to an Excel (XLSX) file?
Yes. The default download is CSV, which opens cleanly in Excel and Google Sheets. You can also choose native XLSX as the output format in the settings if you want a ready-made Excel workbook instead of CSV.
Can I rename, reorder, or remove columns before downloading?
Yes. After conversion, right-click any column header in the results table to rename, hide, reorder, or filter columns. Your changes are reflected in the downloaded CSV or XLSX file.
Why is my CSV showing only one row?
This usually means the XML has only one repeating element at the level the converter is reading. Open the settings (cog icon) and try a different nested-data option to expand child elements into rows, or contact us with a sample of your file and we’ll take a look.
Also check out our JSON to CSV Converter, or our generic data converter.
