Convert XML to Excel (XLSX)

1. 1Choose the XML file.
2. 2Leave “Row element” empty to use the detected repeated element, or type its name.
3. 3Keep “Detect numbers and true/false” ticked to get numbers you can calculate with.
4. 4Click Convert to Excel and download the .xlsx file.

Each <order> becomes a row; attributes become @ columns.

<orders>
  <order id="1001">
    <customer>Ana</customer>
    <total currency="EUR">24.90</total>
  </order>
  <order id="1002">
    <customer>Ben</customer>
    <total currency="EUR">1200</total>
  </order>
</orders>

@id  | customer | total/@currency | total
1001 | Ana      | EUR             | 24.9
1002 | Ben      | EUR             | 1200

01Checking a feed or an export

Product feeds, order exports and accounting or banking exports often arrive as XML. In a sheet you can sort, filter and spot problems in minutes.

02Skipping Power Query

Excel opens XML through Data > Get Data > From File > From XML, then makes you expand nested columns one by one in Power Query. This converter flattens the records into one sheet in a single step.

03Large XML files

The XML is parsed as a stream rather than loaded as a document tree, so files with tens of thousands of records convert comfortably.

• Rows: the shallowest element that repeats becomes the row, unless you name one in “Row element”.
• Columns: child elements are named by their path inside the row, such as customer or address/city.
• Attributes: they become columns starting with @, such as @id or total/@currency.
• Repeated fields inside one record are joined with “; ” in a single cell.
• The first row holds the column names, and columns are sized to their content.

With detection on, plain numbers such as 24.90 or 1200 are stored as Excel numbers and true/false as booleans. Values that would change if converted, such as 00123, IDs longer than 15 digits or 1e5, stay text. An element that is missing or empty in a record leaves its cell empty.