How to Convert JSON to Excel (XLSX) Online, Step by Step

JSON is how websites and APIs exchange data. Excel is where most people want to read, sort and analyse it. Converting one to the other turns each object into a row and each key into a column.

Convert JSON to Excel in 5 steps

1. Copy your JSON, from an API response, a file or a database export.
2. Paste it into the JSON to Excel Converter.
3. Click Validate JSON. The tool tells you if something is wrong and shows a preview table.
4. Check that the columns look right.
5. Click Convert to Excel and download the .xlsx file.

What JSON shape works best?

The cleanest results come from an array of objects that share the same keys:

[
  { "name": "Atal", "city": "Jaipur" },
  { "name": "Rahul", "city": "Delhi" }
]

This becomes a two-column sheet with a header row (name, city) and two data rows. A single object becomes a one-row sheet.

Nested objects and arrays

Spreadsheets are flat, so nested data has to be flattened. Nested objects turn into dotted column names. For example, { "address": { "city": "Jaipur" } } becomes a column called address.city. Arrays inside a record are joined into one cell, separated by commas.

Fixing common JSON errors

• Trailing commas: remove the comma after the last item in an object or array.
• Single quotes: JSON requires double quotes around keys and strings.
• Unquoted keys: { name: "A" } is JavaScript, not JSON. Write { "name": "A" }.
• Comments: JSON does not allow // or /* */ comments.
• Multiple objects pasted one after another: wrap them in [ ] and separate them with commas.

Excel limits to know

An Excel worksheet holds up to 1,048,576 rows and a single cell can contain up to 32,767 characters. For very large datasets, split the JSON into smaller files or use a database export instead.

Other ways to do it

Excel can import JSON itself through Data > Get Data > From File > From JSON (Power Query). It is powerful, but slower for a quick one-off conversion, which is where a browser tool is handy.

Is my data safe?

The conversion happens inside your browser. Your JSON is not sent to a server, so it is fine to use with private data, though you should still avoid pasting secrets like API keys.