XML to Excel converter
Turn XML into a real .xlsx workbook as you type. Nothing is uploaded, and the result can be previewed as a table, copied or downloaded.
Loading the converter… It runs locally in your browser.
How to convert XML to Excel
- Paste your XML into the input panel, drop a file onto it, or press “Open file”.
- Pick how arrays should be handled. Nested objects are flattened into dot-path columns automatically.
- Check the result: switch the output to “Table” view to see it as a grid.
- Press “Copy” or “Download .xlsx”. The conversion runs on your device, so large files never leave it.
TableForge looks for the repeating element in your XML (for example every <item> in a feed) and turns each one into a row, with child elements and attributes as columns.
About XML
Extensible Markup Language: a tree of named elements with attributes. Still common in feeds, SOAP services, office documents and enterprise exports.
About Excel
Microsoft Excel workbooks (.xlsx, and legacy .xls). TableForge also reads OpenDocument .ods and data copied straight out of a spreadsheet.
How a JSON tree becomes table columns
A table is flat: every row has the same columns. JSON is a tree. To fit one into the other, each leaf value gets a column named after its path from the top of the record, joined with dots. Toggle the options and watch the header change.
{
"id": 7,
"name": "Mae Jemison",
"address": {
"city": "Houston",
"geo": {
"lat": 29.76
}
},
"missions": [
"STS-47",
"Endeavour"
]
}| Column | Value |
|---|---|
| id | 7 |
| name | Mae Jemison |
| address.city | Houston |
| address.geo.lat | 29.76 |
| missions.0 | STS-47 |
| missions.1 | Endeavour |
“Column per item” keeps every value searchable but widens the table when arrays are long. “Joined text” keeps one column and suits tags. “JSON text” is lossless, so you can parse it back later.
Questions people ask
Is my XML data uploaded anywhere?
No. The XML to Excel conversion runs entirely in your browser with JavaScript. The page works offline once it has loaded, and TableForge never receives your data.
How large a file can I convert?
The limit is your device's memory. Files of tens of megabytes (hundreds of thousands of rows) convert fine on a typical laptop. The preview shows the first 200 rows, but the download always contains every row.
How are nested XML objects converted into columns?
Each value gets a column named after its path, joined with dots, for example address.city. Arrays can become one column per item (tags.0, tags.1), a single joined column (a; b), or JSON text. Records that lack a key simply leave that cell empty.
Can I convert Excel back to XML?
Yes, use the Excel to XML converter at tableforge.io/excel-to-xml, or the universal converter on the home page.
Will Excel strip my leading zeros?
Not in this file. Only plain numbers without leading zeros are stored as numeric cells. Everything else (ZIP codes, phone numbers, IDs like 00123) is written as text, so Excel shows it exactly as it was.