How to Convert JSON to Excel

Paste your JSON array into the input box. The JSON must be an array of objects.
A table preview appears instantly showing your data with column headers.
Verify the data looks correct in the preview.
Click Download Excel to save as a .xlsx file.

Required JSON Format

The converter expects a JSON array of objects. Each object in the array becomes a row in the spreadsheet. The keys of the first object become the column headers.

Example:

[
  { "name": "Alice", "age": 30, "city": "New York" },
  { "name": "Bob",   "age": 25, "city": "London"   },
  { "name": "Carol", "age": 35, "city": "Sydney"   }
]

This produces a 3-row Excel spreadsheet with columns: name, age, city.

Common Use Cases

API response analysis: Copy a JSON API response and open it as a spreadsheet for quick data analysis.
Database exports: Convert JSON exports from MongoDB, Firebase, or other NoSQL databases to Excel.
Reporting: Share JSON data with non-technical team members by converting to Excel.
Data validation: Spot-check large JSON arrays by viewing them as a formatted table.
Log analysis: Convert structured JSON log data to Excel for filtering and sorting.

Handling Nested JSON

The converter works with flat JSON objects (where all values are primitives: strings, numbers, booleans). For nested structures:

Nested objects — Are converted to their JSON string representation in the cell (e.g., {"street":"Main St"}).
Arrays within objects — Are also stringified into the cell (e.g., ["red","blue"]).

For complex nested JSON, use the JSON Formatter to flatten or restructure your data first.

Frequently Asked Questions

What JSON format is required?

The tool expects a JSON array of objects — an array where every element is an object with key-value pairs. Example: [{"name":"Alice","age":30}]. Each object becomes a row; keys become column headers.

Can I convert nested JSON?

Nested objects and arrays are serialized to strings in the cell. For deeply nested structures, consider flattening your JSON first using the JSON Formatter tool, or restructure it programmatically.

Is there a row limit?

Excel supports up to 1,048,576 rows per sheet. The converter will handle any size JSON array within JavaScript's memory limits. Very large arrays (100,000+ rows) may take a few seconds to process.

Is my JSON data sent to a server?

No. All conversion happens in your browser using SheetJS. Your JSON data never leaves your device.

JSON to Excel