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.
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 @.
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.
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
XML
XML documents and data.
- Extensions
- .xml
- MIME type
- application
/xml - Kind
- Text and data
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.
$ cv convert report.xml report.xlsx$ cv convert report.xml report.xlsxQuestions.What people ask about XML to XLSX.
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.