XML to Excel Converter

Choose your .xml file and click “Convert to Excel”. The records are detected automatically, and you get an XLSX file with one sheet named “Data” and the field names in the first row. It opens in Excel, Google Sheets or Numbers.

XML files with a list of repeated elements, such as <product> inside <products> or <order> inside <orders>, work best. The element that repeats most often becomes one row each. If nothing repeats, the whole file becomes a single row. For data in JSON format, use JSON to Excel.

Each attribute gets its own column, marked with @ – for example @id or @currency. Attributes of nested elements keep their path, such as address.@type. They appear in the same row as the element’s other fields.

Nested elements become columns with combined names, such as address.city. If a simple element repeats inside one record, for example several <tag> elements, their values are joined in one cell, separated by semicolons. Deep structures can produce many columns, which you can delete in Excel.

Only one table is created per file: the longest list of identical elements under one parent. Other lists in the file are not converted. If a nested list – say many <item> elements inside one <order> – is longer than your main list, that nested list becomes the table; split or simplify the XML in that case.

Yes, plain numbers like 42 or 19.99 become numeric cells. Values with leading zeros (such as 00123), thousands separators or currency symbols stay text, and so do dates. Very long digit strings also stay text so they don’t lose digits.

“Not valid XML” means the file has a syntax problem, often an unclosed tag or an & that is not written as &amp;. “No data was found” means the file parsed but contains no text values or attributes to put in columns. An empty file gets its own message.

The prefix is kept in the column name, so an element <g:price> becomes a column called g:price. This is common in product feeds. You can rename the column headers in Excel afterwards.

Up to 30 MB per file, one file at a time, free and without an account. Only files with the .xml extension are accepted. Very large files depend on your device’s memory, since everything runs in the browser.

Yes. The XML is read as data in your browser – nothing in it is executed and the file is not uploaded. That makes it suitable for exports from business software that contain customer or order data.