How to use XML to Excel
- 1
Drop the XML export
From a bank, a marketplace, a 1C or SAP export, a price list or a feed.
- 2
Confirm the record element
Each repeating element becomes one spreadsheet row; the most likely one is preselected, the list shows the others.
- 3
Download the .xlsx
Preview the rows, decide whether numbers and dates should be typed, and save the workbook.
Limits and Pro
XML files up to 100 MB; one sheet of up to 1,048,576 rows.
About XML to Excel
XML to Excel opens the records hidden in an XML file as an ordinary spreadsheet. Pick the element that represents a record and you get one row per record, with a header row of column names, ready for sorting, filtering, pivot tables or a quick check by someone who never reads XML.
The column layout is the same as for CSV: attributes and child elements become columns, nested elements get dot names (supplier.inn, address.region), and repeated children are joined in one cell or spread over numbered columns.
What Excel adds is types. With type detection on, 125000 and 4.5 become numbers you can sum, true and false become logical cells, and ISO dates such as 2026-03-31 or 2026-03-31T14:30:00 become real Excel dates shown as yyyy-mm-dd or with the time. Identifiers with leading zeros — tax numbers, account numbers, product codes like 007 — stay text so Excel doesn't strip the zeros, and so do numbers longer than 15 digits. Turn detection off to keep every value as text, exactly as the XML had it.
The workbook has one sheet named after the record element, with column widths fitted to the content. Excel limits a sheet to 1,048,576 rows and 16,384 columns; a bigger XML export should be split or converted to CSV instead. Formatting such as colours or bold headers isn't added.
Privacy
Parsing the XML and writing the XLSX both happen in a worker in this tab (SheetJS writes the workbook); the export never leaves your computer.