Can I choose how nested JSON is laid out in the Excel file?

Yes. Use the Output layout option to control how nested JSON becomes rows and columns: Table (default) - one column per field, one row per record; best for flat or lightly nested JSON. Key / Value - two columns (the field path and its value), one row per value; handy for deeply nested or irregular JSON. One row per element - every value on its own row with its full path; useful for flattening or auditing. Nested levels - the path is split across columns (level 1, level 2, and so on) followed by the value; good for pivot-style analysis. One row per record - keeps each record on a single row and spreads repeating nested lists into indexed columns (for example line_items/0/amount, line_items/1/amount); best when every object should stay one row even with nested arrays.

Conversion Plan: Non-Registered User

File Size Limit: 10 MB

Conversions: 5 / Daily (up to 50 / Monthly)

Daily Conversions0 / 5

Monthly Conversions0 / 50

Upgrade Plan

Convert JSON to Excel

Online Converter: Convert JSON file into Excel format

Private by default · processed on our servers · files auto-deleted in 24h

Set options and click 'Run Conversion' button

Drag and Drop your file or click "Browse" to select it
or
paste URL or paste text

Max. size 10 MB

Use single file or archive (zip, rar, 7z, xz) for batch conversion

URL

Excel file format

XLSX (Excel 2007+)

XLS (Excel 97-2007)

Copy parent nodes values

Output layout (table shape)New

Table - one column per field (default)

Key / Value - two columns (key, value)

One row per element (path, value, attributes)

Nested levels - path split across columns

One row per record - nested lists spread across columns

Start Conversion

Rating

0.0(0 votes)

✨Create Your Own Custom Converter with AI

Need a custom converter? Build it yourself with AI in minutes!

Chat with AI to describe what you need
No coding required
Ready to use in minutes

Try AI Converter Studio

Chat-based converter creation • Ready in minutes • 100 free AI credits/month, buy more anytime

You may help others to find this website - Share your experience!

More Converters

JSON Converters Excel Converters Office Converters

Sign in to work securely with your files. Sign in or Sign up for full access.
Conversion time varies by file size; thank you for your patience.
Limits apply to maximum conversions and file size. See available plans on the Pricing page.
Unregistered users: up to 5 conversions/day, up to 50 conversions/month, and 10 MB per file. Sign up to extend your limits.
Need help converting files? Contact us.

Conversion Plan: Non-Registered User

File Size Limit: 10 MB

Conversions: 5 / Daily (up to 50 / Monthly)

Daily Conversions0 / 5

Monthly Conversions0 / 50

Upgrade Plan

Convert JSON to Excel

Online Converter: Convert JSON file into Excel format

Private by default · processed on our servers · files auto-deleted in 24h

Set options and click 'Run Conversion' button

Drag and Drop your file or click "Browse" to select it
or
paste URL or paste text

Max. size 10 MB

Use single file or archive (zip, rar, 7z, xz) for batch conversion

URL

Excel file format

XLSX (Excel 2007+)

XLS (Excel 97-2007)

Copy parent nodes values

Output layout (table shape)New

Table - one column per field (default)

Key / Value - two columns (key, value)

One row per element (path, value, attributes)

Nested levels - path split across columns

One row per record - nested lists spread across columns

Start Conversion

Rating

0.0(0 votes)

✨Create Your Own Custom Converter with AI

Need a custom converter? Build it yourself with AI in minutes!

Chat with AI to describe what you need
No coding required
Ready to use in minutes

Try AI Converter Studio

Chat-based converter creation • Ready in minutes • 100 free AI credits/month, buy more anytime

You may help others to find this website - Share your experience!

More Converters

JSON Converters Excel Converters Office Converters

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

Why Should You Transform JSON to Excel?

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.

JSON File Format

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:

json

{
  "type": "book"
}

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

For example:

json

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

And Array is a set of objects.

For example:

json

[
  {
    "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.

Format Resources

JSON.org - Official JSON specification
RFC 8259 - The JSON Data Interchange Format (IETF)

How Exactly Does the Converter Work?

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.

Nested JSON rarely maps cleanly onto a single flat table. The Output layout option lets you choose exactly how nested fields become rows and columns in the Excel. Pick the shape that matches how you will use the data:

Tabletable

One column per field, one row per record. The default, and the best fit for flat or lightly nested JSON.

Input (JSON)

json

{
  "order": {
    "id": "1001",
    "status": "paid",
    "item": { "sku": "A1", "qty": "2" }
  }
}

Output (Excel)

order	id	status	item	sku	qty
	1001	paid		A1	2

Key / Valuekey_value

Two columns, the field path and its value, with one row per value. Ideal for deeply nested or irregular JSON where a fixed set of columns does not fit.

Input (JSON)

json

{
  "order": {
    "id": "1001",
    "status": "paid",
    "item": { "sku": "A1", "qty": "2" }
  }
}

Output (Excel)

key	value
order/id	1001
order/status	paid
order/item/sku	A1
order/item/qty	2

One row per elementelement_rows

Every value on its own row alongside its full path. Useful for flattening or auditing all values in one long list.

Input (JSON)

json

{
  "order": {
    "id": "1001",
    "status": "paid",
    "item": { "sku": "A1", "qty": "2" }
  }
}

Output (Excel)

path	text
order/id	1001
order/status	paid
order/item/sku	A1
order/item/qty	2
order/item
order

Nested levelspath_levels

The path is split across columns (level 1, level 2, and so on) followed by the value. Good for pivot-style analysis by depth.

Input (JSON)

json

{
  "order": {
    "id": "1001",
    "status": "paid",
    "item": { "sku": "A1", "qty": "2" }
  }
}

Output (Excel)

level_1	level_2	level_3	value
order	id		1001
order	status		paid
order	item	sku	A1
order	item	qty	2
order	item
order

One row per recordNewtranspose

Keeps each record on a single row and spreads repeating nested lists into indexed columns (for example line_items/0/amount, line_items/1/amount). The best fit when every record must stay one row even with nested arrays.

Input (JSON)

json

{
  "order": [
    { "id": "1001", "item": [ { "sku": "A1" }, { "sku": "B7" } ] },
    { "id": "1002", "item": [ { "sku": "C3" } ] }
  ]
}

Output (Excel)

order	id	item/0	item/0/sku	item/1	item/1/sku
	1001		A1		B7
	1002		C3

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

Working with Indian GST returns? Our dedicated GSTR JSON to Excel converter turns GSTR-1, GSTR-2A, GSTR-2B and GSTR-3B JSON into a clean workbook with one sheet per section (B2B, B2C, Credit/Debit Notes, HSN and more).

Excel Format

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:

Row capacity: up to 1,048,576 rows
Column capacity: up to 16,384 columns (final column labeled "XFD")
Column width limit: 255 characters
Cell character limit: 32,767 characters
Hyperlink limit per worksheet: 66,530 hyperlinks

Excel Limits (XLS - Excel 97-2007)

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

Row capacity: up to 65,536 rows
Column capacity: up to 256 columns (final column labeled "IV")

Format Resources

MS-XLSX - Excel file format specification (Microsoft)
Excel file formats - Supported formats (Microsoft)

(FAQ) Frequently Asked Questions

How Do I Transform JSON into Excel?

All kinds of JSON files can be exported to Excel format with the use of our converter.

Follow the steps listed below to use our converter:

Upload the file
Click on the 'Run Conversion' button
Download the transformed file

How Long Does It Take to Convert JSON to Excel?

The size of the file determines how long it will take to convert JSON to Excel online; usually the conversion is quite easy to perform and does not take much time.

Is It Safe to Convert JSON to Excel Using Our Converter?

Yes, it is safe. All documents uploaded to our services are encrypted with the use of advanced encryption technology. Source files are deleted immediately after conversion, and converted files are deleted within 24 hours by default.

What Makes Our Converter a Good Choice?

We are devoted to providing you with the best service possible. Here's why you should consider using our converter:

We've been converting documents on the web since 2010;
We use 'state of the art' technologies;
We have a lot of converters for transforming different types of files, for example PDF to Excel, XML to CSV, and others;
We offer custom converter development.

Sign in to work securely with your files. Sign in or Sign up for full access.
Conversion time varies by file size; thank you for your patience.
Limits apply to maximum conversions and file size. See available plans on the Pricing page.
Unregistered users: up to 5 conversions/day, up to 50 conversions/month, and 10 MB per file. Sign up to extend your limits.
Need help converting files? Contact us.

order

status

item

sku

qty

1001

paid

key

value

order/id

1001

order/status

paid

order/item/sku

order/item/qty

path

text

order/id

1001

order/status

paid

order/item/sku

order/item/qty

order/item

order

level_1

level_2

level_3

value

order

1001

order

status

paid

order

item

sku

order

item

qty

order

item

order

item/0

item/0/sku

item/1

item/1/sku

1001

1002

(FAQ) Frequently Asked Questions

How Do I Transform JSON into Excel?

All kinds of JSON files can be exported to Excel format with the use of our converter.

Follow the steps listed below to use our converter:

Upload the file
Click on the 'Run Conversion' button
Download the transformed file

How Long Does It Take to Convert JSON to Excel?

The size of the file determines how long it will take to convert JSON to Excel online; usually the conversion is quite easy to perform and does not take much time.

Is It Safe to Convert JSON to Excel Using Our Converter?

What Makes Our Converter a Good Choice?

We are devoted to providing you with the best service possible. Here's why you should consider using our converter:

We've been converting documents on the web since 2010;
We use 'state of the art' technologies;
We have a lot of converters for transforming different types of files, for example PDF to Excel, XML to CSV, and others;
We offer custom converter development.