JSON to Excel Converter transforms the structured content of a JSON file into a table representation and saves it as an Excel file.

See examples below.

JSON format used in a wide range of software applications and although it is a text format, it is difficult for a human to read and understand it visually.

Here is where JSON to Excel File Converter can help - it transforms JSON file data into Excel format so that it becomes very easy to read, understand, and do required data manipulation, like filtering or applying formulas.

JSON Format

JSON means JavaScript Object Notation.

JSON file is a text file and it can be edited in any Text Editor.

File in JSON format has extension: .json.

JSON Objects Format Data

Generic JSON file contains different types of data: objects, arrays, and attributes.

The JSON Objects file contains only objects, and attributes. Each object is representing one line.

Where the object is a data structure with a set of key-value attributes on the same level.

For example:

{
  "type": "book",
  "name": "Book of success",
  "price": "24.99"
}

The Attribute is a key-value, where the key is the name of the attribute. Attributes can only be used inside objects.

For example:

{
  "type": "book"
}

For the JSON Objects format, each object should be placed on a separate line.

For example:

{"type": "book", "name": "Book of success", "price": "24.99"}
{"type": "book", "name": "Special Book", "price": "107.99"}

Where JSON format is used?

The JSON file format is used for storing data or configuration, and for data interchange between different applications.

JSON is one of the most popular formats used on the Internet - for data interchange between websites or internet services or APIs.

File Format Information

• JSON file format at File.org
• JSON file format at FILExt.com

Based on the predefined rules we transform JSON Objects into a flat table representation, where each object is the single table row.

If you would like to have the result file in CSV format instead of Excel - consider using our JSON Objects to CSV converter.

Excel Format

Excel Limits (XLSX - Excel 2007+)

• Max number of rows: 1,048,576 rows
• Max number of columns: 16,384 columns (last column is "XFD")
• Column width: 255 characters
• Max number of characters in a cell: 32,767 characters
• Max number of Hyperlinks in a worksheet: 66,530 hyperlinks

Excel Limits (XLS - Excel 97-2007)

• Max number of rows: 65,536 rows
• Max number of columns: 256 columns (last column is "IV")

File Format Information

• XLSX file format at File.org
• XLS file format at File.org
• XLSX file format at FILExt.com
• XLS file format at FILExt.com

How do I convert JSON Objects to Excel format?

• Upload JSON Objects file
• Click 'Run Conversion' button
• When the file is converted - download Excel file