Does it need an XSD schema?

No. DataTray infers the record shape from the document itself, which is what makes it work on the many XML files that arrive without a schema.

What about deeply nested XML?

Child elements are flattened into columns with a path-style name. Where the nesting is genuinely repeating you can pick which level becomes a row.

Is there a size limit?

No. Nothing is uploaded, so nothing is capped.

Free converter

XMLExcel

XML to Excel Converter

Government extracts, product feeds and legacy system exports still arrive as XML, and Excel's own XML import is famously awkward about it. DataTray maps the repeating element to rows and its attributes and children to columns.

Windows 10/11 (x64) · Free · No account

Drop in your files — A workbook lands in DataTray's output folder; the XML is not modified.

Why convert

Why Excel struggles with XML

Excel wants a schema, and most XML in the wild does not come with one — so it either refuses the file or invents a mapping you then have to unpick. Working out the repeating element and flattening around it is a more reliable approach, and it is what DataTray does.

Getting a supplier's product feed into a spreadsheet.
Converting a government or regulatory extract for analysis.
Pulling data out of a legacy system export nobody supports any more.
Turning an XML sitemap or catalogue into a reviewable table.

How it works

Convert XML to Excel in a few clicks

1
Open the XML
DataTray finds the repeating element that represents a record and shows you what it picked.
2
Map it to columns
Attributes and child elements become columns; drop the ones you do not want.
3
Write the workbook
One .xlsx out, or CSV or Parquet if that suits better.

The details

XML to Excel, at a glance

Input: XML, with or without a schema
Rows: From the detected repeating element, which you can change
Columns: Attributes and child elements, flattened
Output: .xlsx, or any other format the converter writes

Questions