Convert XML to NUMBERS

Turn XML files into NUMBERS. 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

An XML file as a Numbers spreadsheet.The first list of repeated elements becomes the rows of one sheet.

  1. What you get

    A Numbers file with one sheet. The sheet is named after the file, cut to 31 characters.

    The first list of repeated elements, such as the items of a feed, becomes the rows. Each child element or attribute gets its own column. Attribute columns start with @.

    A document without repeated elements becomes one row.

  2. How values are stored

    Numbers, booleans and plain dates become typed cells, so Numbers treats them as values and not as text.

    Codes with a leading zero, numbers of 16 digits or more and times with a zone stay text. Numbers keep 15 significant digits.

    Deeper nesting is written into the cell as JSON text.

  3. Limits

    Fonts that Numbers does not have become Helvetica Neue.

    A document of more than 300,000 cells fails with unsupported_elements.

XML and NUMBERS.What each format is.

The formats

From · XML

XML

XML documents and data.

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

Apple Numbers

Apple Numbers spreadsheets from macOS and iOS.

Extensions
.numbers
MIME type
application/vnd.apple.numbers
Kind
Documents

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

terminal
$ cv convert report.xml report.numbers
$ cv convert report.xml report.numbers

Questions.What people ask about XML to NUMBERS.

01OF 04

The first list of repeated elements, such as the items of a feed. A document without repeated elements becomes one row.

Columns that start with @ come from attributes. Child elements get columns without it.

Nesting deeper than the columns is written into the cell as JSON text.

The document has more than 300,000 cells. The conversion stops with unsupported_elements at that size.

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