Convert XML to XLSX

Turn XML files into XLSX. One sheet named after the file, cut to 31 characters.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop XML files on the dialor turn it to pick what to do

Repeated XML elements become spreadsheet rows.One sheet, one row per item, and one column for each child element or attribute.

  1. What you get

    An Excel workbook with a single sheet, named after the file and cut to 31 characters. The first list of repeated elements, such as the items of a feed, becomes the rows.

    Each child element becomes a column. Each attribute becomes a column too, and its name starts with @.

  2. How values are typed

    Numbers, booleans and plain dates become typed cells, so Excel can sort, sum and filter them as such.

    Some values stay text so they are not changed. Codes with a leading zero, numbers of 16 digits or more, and times with a zone are kept as written.

  3. Nested and flat documents

    Only the first list of repeated elements is turned into rows. Nesting deeper than a row's columns is written into the cell as JSON text.

    A document with no repeated elements becomes one row. Output is one file. To combine several workbooks afterward, you can merge XLSX.

XML and XLSX.What each format is.

The formats

From · XML

XML

XML documents and data.

Extensions
.xml
MIME type
application/xml
Kind
Text and data
To · XLSX

Excel Workbook

Excel's workbook format since 2007. Sheets, formulas, formats and charts in zipped XML.

Extensions
.xlsx
MIME type
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Kind
Documents

In your code.The same XML to XLSX conversion through the API, for your app or your agent.

terminal
$ cv convert report.xml report.xlsx
$ cv convert report.xml report.xlsx

Questions.What people ask about XML to XLSX.

01OF 04

The first list of repeated elements gives the rows. Each child element or attribute of an item gives a column, and attribute columns start with @.

Deeper nesting is written into the cell as JSON text.

Yes. Codes with a leading zero stay text, so the zero is kept. The same goes for numbers of 16 digits or more and times with a zone.

The document becomes one row on the single sheet.

More conversions.Other ways in and out of XML and XLSX.