Convert XML to Excel
More data converters: JSON to Excel · JSON to CSV · CSV to JSON · Excel to JSON · XML to JSON · JSON to XML · YAML to JSON · JSON Formatter
How to Convert XML to Excel
Product feeds, orders, invoices, exports from accounting or shop software.
The repeating element is found automatically. If there are several, pick one in the Rows from menu.
Columns get bold headers, filters and a frozen first row.
How the table is built
Take a catalog with two <book> elements. Each book becomes a row:
Example result
| id | lang | author | title | price |
|---|---|---|---|---|
| bk101 | en | Gambardella, Matthew | XML Developer's Guide | 44.95 |
| bk102 | en | Ralls, Kim | Midnight Rain | 5.95 |
- Rows: the element that repeats under one parent —
<book>,<item>,<order>— becomes the rows. Feeds often have more than one list; the Rows from menu shows each with its count. - Columns: attributes (
id,lang) and child elements become columns. Deeper elements get dotted names such asshipping.address.city. - Numbers like 44.95 become real Excel numbers you can sum and sort. Values such as 007 stay text so codes are not changed.
- Repeated children inside a row (several
<tag>in one book) go into one cell separated by commas, or into numbered columns with "One column per item". - Very large exports up to 50 MB can be opened; Excel holds up to 1,048,576 rows.
Need JSON instead of a spreadsheet? Use XML to JSON.
Frequently Asked Questions
Is the XML uploaded to a server?
No. It is read and turned into an Excel file by JavaScript in your browser.
Which element becomes the rows?
The element that repeats under one parent, such as book, item or order. If the XML has several such lists, you can choose one.
What happens to attributes?
They become columns, just like child elements. If an attribute and a child element share a name, the attribute column starts with @.
Can Excel open XML directly?
Excel for Windows can import XML through Data → Get Data, but nested XML often needs extra steps to become a flat table, and the options differ between Excel versions. This converter gives a plain .xlsx that opens anywhere.