XML to Excel Converter
Read an XML invoice, a bank statement file, a product feed or an export from accounting software as an ordinary spreadsheet, with one record per row, without setting up XML maps in Excel.
Data Converter
or drop CSV, TSV, TXT … files here ·
Max 95 MB per file· Up to 20 files· Deleted after 30 minutes
Files are processed on our servers and deleted after 30 minutes.
Character that separates columns in CSV and text files, for both reading and writing. Auto detects it from the input and writes commas.
UTF-8 works for every language. Choose UTF-8 with BOM if Excel on Windows shows garbled accents or Asian characters when opening the CSV.
Excel, ODS and Numbers input: convert the first sheet only, or every sheet (one CSV per sheet in a ZIP, or one JSON key per sheet).
Name of the sheet tab in the new spreadsheet, up to 31 characters.
Array of objects uses column names as keys for every row; array of arrays is more compact and keeps the header as the first array.
Name of the outer element that wraps all rows; each row becomes a <row> inside it.
Used in CREATE TABLE and INSERT statements. Letters, digits and underscores only.
Quoting and column types differ slightly between databases; pick the one you will import into.
Rewrite date cells in one format. ISO (2026-10-18) is safest for databases and code; keep leaves them as they appear in the source.
How to use this tool
- 1
Upload the XML files
Drop one or more .xml files on the upload area, up to 20 per batch and 95 MB each. Every file becomes its own workbook.
- 2
Name the tab if you like
Output is set to XLSX. Under Advanced settings, Sheet name changes the tab name and Dates can rewrite timestamps into a format your team reads.
- 3
Convert and open
Press Convert to XLSX (Excel) and open the workbook in Excel, Numbers, Google Sheets or LibreOffice Calc.
XML files people need to open in Excel
XML has been a W3C standard since 1998, and its strength is precision: every value sits in a named tag, and a schema can say exactly which tags are allowed. That is why governments, banks and large retailers chose it for machine-to-machine data. The catch is that the same precision makes the files tiring for humans to read in a text editor.
Since January 2019, Italy has required business-to-business invoices to pass through its exchange system as FatturaPA XML. The Peppol network that many European public buyers use carries UBL invoices, also XML. Banks moving to ISO 20022 deliver account statements as camt.053 XML. Marketplaces and shopping feeds describe products in XML, and many accounting packages export journals the same way. Each of these regularly lands on the desk of someone who just wants a table.
Invoices
UBL and FatturaPA files: one row per invoice line with item, quantity, VAT rate and amount.
Bank statements
camt.053 files: one row per booked entry with date, amount, currency and counterparty.
Product feeds
Shop and marketplace feeds: one row per product with ID, title, price and availability.
XML to Excel converter or Excel's own XML import
| This converter | Excel for Windows | Excel for Mac | |
|---|---|---|---|
| Opens arbitrary XML as a table | yes | yes | no |
| No XML map or schema prompt | yes | no | no |
| Converts many files in one go | Up to 20 | One at a time | no |
| Works without an Excel license | yes | no | no |
XML
Extensible Markup Language
XML is a markup language for structured data published by the W3C in 1998. It uses nested tags with attributes and supports schemas, namespaces and validation, which makes it robust for complex documents. It underlies RSS feeds, SVG, Office documents, sitemaps and many enterprise and government data exchanges. XML is verbose compared with JSON, but every programming language and many spreadsheet tools can read it.
- Compression
- –
- Transparency
- –
- Animation
- –
- Introduced
- 1998 · W3C
XLSX
Microsoft Excel workbook
XLSX is Microsoft Excel's default workbook format since Office 2007, based on the Office Open XML standard. It stores multiple sheets, formulas, formatting, charts, pivot tables and data validation in a ZIP package of XML. It supports over a million rows per sheet and is the default exchange format for business spreadsheets. Google Sheets, LibreOffice and Numbers open XLSX, though macros and advanced features may not carry over.
- Compression
- –
- Transparency
- –
- Animation
- –
- Introduced
- 2007 · Microsoft
XML goes to Excel when a person, not a program, has to read the data: an accountant checking an e-invoice, a merchant reviewing a product feed, or a manager looking at an export that only arrives as XML.
Convert XML to XLSX: how nested data lands in columns
A spreadsheet is flat and XML is a tree, so the conversion has to decide what one row means. The repeating element closest to the data, for example each <Entry> in a statement or each <cac:InvoiceLine> in a UBL invoice, becomes the row. Values nested inside it are spread into columns, and attributes such as a currency code get columns of their own next to the amount they describe.
Text stays exactly as written in the XML, which protects account numbers, IBANs and article codes with leading zeros. Amounts that look numeric become number cells you can total. Namespace prefixes such as cbc: stay part of the column names, which is harmless and makes the origin of each field clear. If you want the full tree instead of a flat table, for example to feed a script, XML to JSON keeps the nesting intact.
For very large exports, keep Excel's grid in mind: a worksheet holds 1,048,576 rows, so a feed with more records than that should go to CSV or be split first.
XML to Excel FAQ
Why does Excel for Mac not import my XML file?
XML maps and the XML Source pane exist only in Excel for Windows. Excel for Mac opens an XML file at best as text, with every tag in one column. Converting the file to XLSX first gives Mac users the same table that Windows users get.
Excel says the XML has no schema and offers to create one. Is that a problem?
It is Excel inferring a structure from the data, and for simple files it works. For deeply nested or very large files, the inferred map often fails or spreads values over many columns. This converter flattens the records without a schema step, so there is nothing to approve.
Can I convert an XML e-invoice to Excel?
Yes. Formats such as UBL, used across the Peppol network, and Italy's FatturaPA are plain XML. Header details like seller, buyer and totals appear as columns, and the repeating invoice lines become rows you can sum and check against the PDF copy.
How is XML to Excel different from XML to CSV?
The data is the same, but XLSX keeps text and numbers as typed cells and opens with a double-click without Excel re-guessing values. Choose XML to CSV when another system will import the result rather than a person reading it.
Can the workbook be turned back into XML?
Yes, once you have edited the rows, Excel to XML writes them as XML records again. The original nesting, namespaces and attributes are not rebuilt automatically, so check the result against what the receiving system expects.
- XML to CSV ConverterConvert XML feeds, invoices and system exports to CSV online. Repeating records become rows, child tags become columns. Up to 20 files, 95 MB each.
- XML to JSON ConverterConvert XML to readable JSON: attributes become @ keys, repeated tags become arrays, text stays intact. For SOAP responses, feeds and legacy exports.
- JSON to Excel ConverterConvert JSON or JSON Lines into an Excel XLSX sheet: keys become column headers, each record becomes a row. Up to 20 files per batch, no account needed.
- Excel to XML ConverterConvert an Excel sheet to XML without XML maps or the Developer tab. Each row becomes a record, each header a tag. XLSX, XLS and ODS input.
- CSV to XLSX ConverterConvert CSV to an Excel XLSX workbook with leading zeros, long IDs and accented text intact. Comma, semicolon and tab files detected automatically.
- XML to Word ConverterConvert XML to Word: repeating records become rows of a table in a .docx file you can print, comment on and send. Elements and attributes become columns.