What is this XML to Excel converter?
A free, browser-based tool that turns XML data into a real Excel (.xlsx) file. Paste or upload your XML, check the live preview, and download the workbook. All processing happens locally in your browser, so your data is never uploaded and no Excel installation is needed.
Reviewing product feed XML in rows and columns, not tags
A 3,000-line XML feed is technically human-readable and practically not. Product feeds, order exports, and the XML that government or legal systems produce all share the same shape: one record element repeated over and over. In a spreadsheet that shape becomes rows, and the questions you actually have (which items lack a price, how many orders per country) turn into a filter or a sort instead of a scroll through angle brackets.
It is also the practical way to hand XML to colleagues who will never open a text editor: purchasing, finance, the client. They get a familiar grid, and the file's origins stop mattering.
How messy real-world XML settles into the sheet
Real feeds are ragged: optional fields appear on some records and not others. The column set becomes the union of every field seen across all records, in order of first appearance, with blanks where a record lacks the field, so auditing incompleteness is just filtering a column for empty cells. Plain numeric values are written as real numbers, ready for sums and sorting, while codes with leading zeros stay text.
Two boundaries worth knowing: values stored in attributes (id="123" inside the tag) are not lifted into columns, only element content is, and nested groups below the field level collapse into that column's combined text. Good enough for review; not a round trip.
How to use it
- Paste your XML into the left panel, or upload a XML file.
- Check the live table preview to confirm rows and columns were detected correctly.
- Press “Convert & download .xlsx” to save the Excel file.
How the data is mapped
- Each XML record becomes one spreadsheet row (row elements under the root; their child elements become columns).
- The XML shape is the generic tabular mapping: <rows><row><Column>value</Column></row></rows>, with column names sanitized into valid element names.
- Values that look like plain numbers are written as real Excel numbers; codes like 007 stay text so leading zeros survive.
Example
Input (XML)
<?xml version="1.0" encoding="UTF-8"?>
<rows>
<row>
<Name>Apple</Name>
<Qty>3</Qty>
</row>
<row>
<Name>Orange</Name>
<Qty>5</Qty>
</row>
</rows>Output (Excel)
Name Qty Apple 3 Orange 5
XML vs Excel at a glance
| Format | Type | Structure | Best for |
|---|---|---|---|
| XML | Plain text markup | Nested named elements plus attributes | System integrations, feeds, legacy APIs |
| Excel | Binary spreadsheet (.xlsx) | Sheets of rows × columns with typed cells | Editing in Excel or Google Sheets |
