XML is everywhere, but hard to read
Plenty of systems still speak XML. Electronic invoices in many countries are XML files. Product feeds for shopping platforms, exports from accounting and inventory software, data from government portals, bank files, RSS feeds and older APIs often come as XML too. The data is all there, but between the tags it is very hard to read or total.
This converter turns XML into a table. It looks for the element that repeats, such as each item, product, invoice line or entry, and makes one row for each. The child elements and the attributes of that element become the columns.
How the table is built
Say a file has a list of products, each with a code, a name and a price, and the price has a currency attribute. You get a sheet with columns for the code, the name, the price and the currency, and one row per product. Nested children are flattened into columns with dotted names, so nothing is lost.
The preview shows the first rows before you download, so you can confirm the converter picked the right element. In Excel, prices and quantities are written as numbers you can add up, while codes with leading zeros and very long numbers, such as tax IDs or account numbers, stay as text exactly as they were.
Once the sheet is open, you can sort by any column, filter by date or supplier, and add totals with ordinary formulas. If the XML file is a single invoice, the repeated element is usually its line items, so you get one row per item; with a file that contains many invoices, each invoice or each line becomes a row, depending on which element repeats.
Typical uses
Reviewing the lines of a batch of invoices before accounting, checking a product feed for missing prices, comparing an inventory export with the physical count, or turning a report from an older system into something a manager can read. You can convert several XML files at once and download the spreadsheets together.
Very irregular XML, where every record has a different structure, may produce many sparse columns. In that case the preview helps you decide whether the result is useful before downloading. If you need CSV or JSON instead of Excel, choose that output.
Private and free
Invoices and business exports contain sensitive data. The XML is converted in your browser, not uploaded to any server, and nothing is stored. It is free, with no account and no file limit beyond your device's memory. To edit the spreadsheet afterward, open it with Online spreadsheet.