About the XML to Excel
XML exports from shops, banks, government portals and older software are hard to read and analyse. This converter finds the repeating records in an XML file, for example each order in an orders file, and turns them into rows of a spreadsheet, with one column for each field. Nested fields get combined column names such as address.city. Check the preview, then download an Excel .xlsx file ready for sorting, filtering and formulas. The XML never leaves your browser.
Updated October 2026
How to use the XML to Excel
- 1Upload an XML file or paste the XML.
- 2Check the preview of the rows found.
- 3Adjust the XML if records are missing.
- 4Download the .xlsx file.
- 5Open it in Excel, Google Sheets or Numbers.
Typical XML files
Product feeds for marketplaces, bank statement exports, e-invoices, survey results and data from government open-data portals often come as XML. Turning them into a spreadsheet makes them easy to check and total.
An example
An orders file with <order> elements each holding <id>, <customer> and <total> becomes a spreadsheet with columns id, customer and total and one row per order.
- <orders> is the wrapper
- each <order> is a row
- each child is a column
Nested data
If an order holds an <address> with <city> inside, the column is called address.city. Lists inside records are joined into a single cell, which keeps the table rectangular.
If the preview looks wrong
Check that the XML is valid with our XML Formatter, and make sure the records you want are siblings with the same element name.
Large and complex files
The converter turns the XML into a table in your browser. Files with thousands of records are fine. Deeply nested XML with lists inside lists produces many combined column names; in that case, cut the XML down to the part you need before converting.
Text, numbers and dates
Values that look like plain numbers are stored as numbers so formulas work. Dates are kept as the text written in the XML; select the column in Excel and use Text to Columns or a date format if you need real dates.
Keeping the data private
Bank, payroll and customer exports often contain sensitive details. Because the conversion runs on your own device, nothing is sent to a server, and closing the tab removes the data from memory.
Phone and computer
Paste XML from an email on your phone or upload a file on your computer. To go the other way use Excel to XML, and XML to CSV Converter gives a text copy.
Features
- Finds repeating records automatically
- One column per field
- Nested fields flattened
- Numbers stored as numbers
- Preview before download
- No upload
Frequently asked questions
How does it decide what a row is?
It goes down through wrapper elements that contain a single child until it finds a list of repeating elements, and uses those as rows.
What happens to attributes?
Attributes become columns too, alongside child elements.
My XML has several different lists. Which is used?
The first list of repeating records the tool reaches. To convert another list, paste just that part of the XML.
Can it handle large files?
Files of several megabytes convert fine on a computer; very large exports may be slow in a browser.
Will numbers work in formulas?
Yes. Plain numbers become numeric cells; codes with leading zeros stay as text.
Is my spreadsheet uploaded?
No. It is read and converted in your browser, so private figures and customer lists stay on your device.
Can I get a CSV instead?
Use our XML to CSV converter, which uses the same record finder and gives you a CSV file to download.
Can I see the result before downloading?
Yes. The preview shows the first rows and columns found, updating as you edit the XML.