XML to Excel

Convert XML records into an Excel spreadsheet.

0 chars
0 words
0 lines
0 chars
0 words
0 lines

XML to Excel Converter – Download XML as .xlsx

The XML to Excel converter turns record-style XML into a genuine Excel workbook. Paste an XML export, check the table preview, and press Download Excel (.xlsx) — no macros, no Excel "XML Source" pane, and no XSD mapping required.

From elements to rows and columns

Most data-carrying XML has the same shape: a root element wrapping many copies of one record element. The converter finds that repeated element automatically and builds a table from it:

  • each record (<book>, <order>, <item>…) becomes a row;
  • child elements and attributes become columns, with namespace prefixes such as dc: removed;
  • deeper nesting is flattened into dotted names (shipping.address.city), and repeated simple children are joined with commas;
  • an element with both text and attributes is split into price and price@currency.

Columns are collected from all records, so a field that appears only in some rows still gets its own column and is left empty elsewhere.

A real workbook

The download is an Office Open XML .xlsx file with a bold, frozen header row. Numbers and booleans are typed cells, so formulas work immediately, while text such as ZIP codes keeps its leading zeros. Accented characters and non-Latin scripts display correctly because nothing passes through a CSV encoding step.

The text box on the right shows the same table as tab-separated values. Copy it and paste into an open Excel or Google Sheets window if you only need the data in an existing sheet.

Edge cases

A document with a single record produces a one-row table. If the XML is not well-formed, the error message points to the line and column of the problem. Very deep, document-style XML (like XHTML) does not map naturally to rows — use XML to JSON for that.

Need a text format instead? Try XML to CSV or XML to TSV. Going from JSON? Use JSON to Excel, and to read spreadsheets back, open Excel to XML.

Frequently Asked Questions

The converter looks for the repeated element — for example every <book> inside <catalog> — and turns each one into a row. Child elements and attributes become columns; nested elements are flattened into dotted column names like address.city.

Attributes of the row element get their own column named after the attribute (id, category). An element that has both text and attributes, such as <price currency="USD">44.95</price>, produces two columns: price and price@currency.

Yes. Values that look like numbers or true/false are detected, so the .xlsx contains numeric and boolean cells you can sum, sort, and filter. Values with leading zeros, such as 00501, stay text.

No. Parsing and the workbook are both built in your browser, and the file is downloaded straight to your device.