Browser-Based · Instant · Free

XML to Excel.
Rows From Records.

Paste XML or open an .xml file and get an Excel table: each repeated element becomes a row, and its child elements and attributes become columns.

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

1
Paste or open the XML

Product feeds, orders, invoices, exports from accounting or shop software.

2
Choose the rows

The repeating element is found automatically. If there are several, pick one in the Rows from menu.

3
Download the .xlsx

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

idlangauthortitleprice
bk101enGambardella, MatthewXML Developer's Guide44.95
bk102enRalls, KimMidnight Rain5.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 as shipping.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.