The converter helps to transform the content of JSON file to Excel online and saves the result in .xlsx or .xls format.

It is difficult to read and comprehend JSON even though it is a text format. Our service can assist in this case by converting JSON into Excel table. As a result, it becomes easy to read, understand and do required data manipulations like filtering and applying formulas.

JavaScript Object Notation is the full meaning of JSON. This is a text document that can be created in any text editor. It is a popular text-based technique for presenting structured data in JavaScript object syntax.

JSON Format Description

This format contains different types of data: objects, arrays, and attributes.

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"
}

The Object is a data structure with a set of attributes on the same level.

For example:

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

And Array is a set of objects.

For example:

[
  {
    "type": "book",
    "quantity": 5
  },
  {
    "type": "magazine",
    "quantity": 12
  }
]

Where is the JSON Format Applicable?

It is a commonly used format for internet services, APIs, websites. The JavaScript Object Notation file can be used to store and configure data. It can as well be used 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

Additional information about this format can be found in the resources below:

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

We transform objects in JSON into a flat table layout in accordance to specified rules, with arrays acting as a collection of rows in the table.

An example of a conversion:

Source file:

Result table data:

Use our JSON to CSV converter if you prefer to receive the result in CSV style.

This is used in Microsoft Office Excel program. The extension used in an Excel file is either .XLS or .XLSX, depending on the version used.

Our Converter saves the documents in the XLSX format, which is compatible with Microsoft Office 2007 and later editions, or you can choose XLS format for earlier versions.

Excel Limits (XLSX for Excel 2007+)

It has the following restrictions when it is used with Microsoft Office:

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

Excel Limits (XLS - Excel 97-2007)

The restrictions of the XLS style used in 97-2007 are listed below

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

File Format Information

Additional information can be found in the following resources

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