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.

  1. 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.

  2. 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.

  3. 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

From · JSON

JSON

JSON, the data format of every API.

Extensions
.json
MIME type
application/json
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 JSON to NUMBERS conversion through the API, for your app or your agent.

terminal
$ cv convert report.json report.numbers
$ cv convert report.json report.numbers

Questions.What people ask about JSON to NUMBERS.

01OF 04

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.

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