Browser-Based · Instant · Free

JSON to Excel.
Clean Columns, Real Numbers.

Paste JSON or open a .json file and get an Excel spreadsheet: one row per record, one column per field, with nested objects flattened into columns. The conversion runs in your browser.

Convert JSON to Excel

More data converters: JSON to CSV · CSV to JSON · Excel to JSON · XML to JSON · JSON to XML · XML to Excel · YAML to JSON · JSON Formatter

How to Convert JSON to Excel

1
Paste or open the JSON

An array of records, an API response or a JSON Lines file. Click Example to see how it works.

2
Check the preview

The table shows the first 100 rows. If the JSON has several lists, choose which one becomes the rows.

3
Download the .xlsx

The header row is bold, frozen and has filters, so the file is ready to sort and filter in Excel.

How JSON becomes a spreadsheet

Example: one record

In the JSONIn Excel
"name": "Ana"Column name with the text Ana
"price": 12.5Column price with a real number you can sum
"active": trueTRUE in column active
"address": {"city": "Sarajevo"}Column address.city
"tags": ["admin", "editor"]admin, editor in one cell — or tags.1, tags.2 with "One column per item"
null or a missing fieldEmpty cell
  • Which part becomes the rows: a list at the top level is used directly. If the list sits inside an object — like {"data": {"items": [...]}} from an API — it is found automatically, and a Rows from menu appears when there is more than one list to choose from.
  • Columns appear in the order fields are first seen. Records that lack a field get an empty cell, so records with different fields still line up.
  • Text stays text: "00123" keeps its leading zeros because it is a string in the JSON. Very long whole numbers such as 19-digit IDs are kept as text too, because Excel would round them after 15 digits.
  • JSON Lines (one JSON object per line, .jsonl or .ndjson) is recognised automatically.
  • Excel limits: a sheet holds 1,048,576 rows and 16,384 columns, and a cell holds 32,767 characters. Longer text is cut and you are told how many cells were affected.

Need a plain text file instead? Use JSON to CSV. To check or tidy the JSON first, use the JSON formatter.

Frequently Asked Questions

Is my JSON uploaded to a server?

No. The JSON is read and the Excel file is built by JavaScript in your browser, so private data such as customer lists never leaves your device.

What happens to nested objects and arrays?

Nested objects become columns with dotted names such as address.city. Lists of simple values are joined into one cell (admin, editor), or split into one column per item if you choose that option. Lists of objects are kept as JSON text in one cell.

Why does Excel show some numbers as text?

Values that are strings in the JSON, like "42" in quotes, stay text so that codes with leading zeros are not changed. Numbers written without quotes become real Excel numbers.

How big can the JSON be?

Files up to 50 MB can be opened. Excel itself allows 1,048,576 rows per sheet; for more rows, convert to CSV instead.