JSON to Excel Converter Online Tool

Input

Output

Excel output is a binary .xlsx file. Use Download to save the workbook. Copy is not available for this format.

Table Editor

3 rows × 3 columns

#
1
2
3

JSON to Excel

Convert a JSON array into an Excel .xlsx workbook. An array of objects uses the keys as column headers. A two-dimensional array is written row by row.

The download is one worksheet named Sheet1. .xlsx is the Office Open XML workbook defined by ECMA-376. Excel, Google Sheets, and LibreOffice open it. Microsoft lists it among the file formats Excel supports.

The input must be valid JSON as defined by RFC 8259. Object keys from the first item become the header row.

Cells are stored as text, so a code like 001 is not shortened into a number. Formula-like text such as =1+1 is stored as text and is not calculated on export.

Steps

Paste a JSON array of objects, or a 2D array, into the input panel. You can also upload a .json file.
Set the input format to JSON and the output format to Excel.
Confirm the header names in the Table Editor. Rename a header cell if you want a different column title.
Click Download to save table.xlsx.

FAQ

Q: How do I convert JSON to Excel?

Paste an array of objects or a 2D array, select Excel as the output, and download the .xlsx file.

Q: Which JSON shapes work?

An array of objects, or an array of arrays. A single object that is not a list of rows is not a table.

Q: Are numbers kept as text?

Cell values are written as text so codes like 001 are not shortened. Excel still opens each value in its own cell.

Q: Does conversion upload my JSON?

No. The workbook is created in your browser.

Part of tool topic

Table Tools - CSV, JSON & Markdown

Tool Chain Recommendation

After working with your table, you may also want to convert it to another format.

JSON Generator

Online JSON table generator, create JSON data by specifying rows and columns, with copy and download support

After working with your table, you may also want to convert it to another format.

JSON to CSV

Online JSON to CSV converter, quickly convert JSON data to CSV format, with copy and download support

After working with your table, you may also want to convert it to another format.

JSON to HTML Table

Online JSON to HTML table converter, quickly convert JSON data to HTML table format, with copy and download support

After working with your table, you may also want to convert it to another format.

JSON to LaTeX Table

Online JSON to LaTeX table converter, quickly convert JSON data to LaTeX table format, with copy and download support

After working with your table, you may also want to convert it to another format.

JSON to Markdown Table

Online JSON to Markdown table converter, quickly convert JSON data to Markdown table format, with copy and download support

After working with your table, you may also want to convert it to another format.

JSON to SQL INSERT

Online JSON to SQL INSERT converter, quickly convert JSON data to SQL INSERT statements, with copy and download support

After working with your table, you may also want to convert it to another format.