XML to Excel Converter (XLSX)

Open an XML export in Excel and you often get a nested mess or an error. This converter turns the XML into a proper .xlsx workbook: the repeating record element (every <item>, <row> or <order>) becomes a row, and its attributes and child elements become columns with clear names such as price.@currency. Plain numbers are stored as numbers so you can sum and sort them, while codes with leading zeros stay text. Everything runs in your browser — the file never leaves your device.

How to use this tool

1. Choose an XML file or paste the XML.
2. Leave the record element empty to detect it, or type a name or path such as channel/item.
3. Choose one sheet, or one sheet per repeating element type.
4. Pick how attributes are named and what happens to repeated child elements.
5. Download the .xlsx file and open it in Excel, Google Sheets or LibreOffice.

Formula

record element → row · attribute → @name column · child element → column · nested child → parent.child column

Columns appear in the order they are first met; a record without a value gets an empty cell. Repeated child elements are joined in one cell (a | b) or spread over numbered columns. A value becomes a number only if it is a plain decimal without a leading zero and with at most 15 digits, Excel's precision; everything else is stored as text exactly as written.

Example

The sample catalog becomes a workbook with one sheet named book: 2 rows and 7 columns — @id, @lang, author, title, price, price.@currency and isbn. 44.95 and 5.95 are numbers, while the ISBNs 0201633612 and 0743273567 keep their leading zero because they are stored as text.