Convert JSON to NUMBERS
Turn JSON files into NUMBERS. One sheet named after the file, cut to 31 characters, with a row per object under a header of every key in first-seen order; a single object becomes one row.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop JSON files on the dialor turn it to pick what to do
JSON rows in a Numbers sheet.Each object becomes a row under a header of its keys.
What you get
One Numbers file with one sheet. The sheet is named after your file and cut to 31 characters.
The header holds every key in the order it is first seen. Each object in the JSON becomes a row below it. A single object becomes one row.
How values are written
Numbers, booleans and plain dates become typed cells. Nested objects and lists are written into their cell as JSON text.
Codes with a leading zero stay text. So do numbers of 16 digits or more and times with a zone.
Limits
Numbers keep 15 significant digits. Fonts that Numbers does not have become Helvetica Neue.
A document of more than 300,000 cells fails with
unsupported_elements. To combine several files before converting, you can merge JSON first.
JSON and NUMBERS.What each format is.
The formats
JSON
JSON, the data format of every API.
- Extensions
- .json
- MIME type
- application
/json - 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 JSON to NUMBERS conversion through the API, for your app or your agent.
$ cv convert report.json report.numbers$ cv convert report.json report.numbersQuestions.What people ask about JSON to NUMBERS.
It takes the name of your file and is cut to 31 characters.
They are written into their cell as JSON text. They are not split into extra columns or rows.
Yes. Codes with a leading zero stay text, so the zero is kept.
It stops with unsupported_elements when the document has more than 300,000 cells.