Convert JSON to XLSX

Turn JSON files into XLSX. 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 an Excel sheet.Each object becomes a row under a header of its keys.

  1. What you get

    One XLSX file with one sheet. The sheet is named after your file, cut to 31 characters.

    The header row lists every key in the order it first appears. 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, so Excel treats them as numbers, true or false values and dates.

    Nested objects and lists are written into their cell as JSON text. They are not split into extra columns or sheets.

  3. Values that stay text

    Some values look like numbers or dates but are kept as text. Codes with a leading zero stay text, so the zero is not lost. Numbers of 16 digits or more stay text. Times with a zone stay text.

  4. Files that fail

    If the file cannot be parsed, the conversion stops with input_corrupted. This means the JSON is not valid.

    To go the other way, use XLSX to JSON.

JSON and XLSX.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 · XLSX

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 JSON to XLSX conversion through the API, for your app or your agent.

terminal
$ cv convert report.json report.xlsx
$ cv convert report.json report.xlsx

Questions.What people ask about JSON to XLSX.

01OF 04

It takes the name of your file and cuts it to 31 characters.

They are written into their cell as JSON text.

Codes with a leading zero are kept as text so the zero stays. Numbers of 16 digits or more and times with a zone are kept as text too.

It becomes one row under the header of its keys.

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