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