JSON to Excel

This free JSON to Excel converter turns JSON into a real .xlsx spreadsheet entirely in your browser. Paste your data or upload a .json file, review the preview, and download the file. Nothing leaves your device, and there is no sign-up.

How to use this JSON to Excel converter

• Paste your JSON into the box, or upload a .json / .txt file.
• Keep Expand nested objects on to turn nested objects into separate columns (e.g. address.zip), or turn it off to keep each nested block as text in one cell.
• Optionally set a Sheet name; it defaults to JSON.
• Click Convert to Excel, check the preview, then Download .xlsx.

What this tool supports

Input shapes

• Array of objects — [{"a":1},{"a":2}] (most common)
• Single object — {"a":1,"b":2} becomes one row
• Object with an array property — {"users":[...]} is detected and the array becomes the rows
• JSONLines / NDJSON — one JSON object per line, no outer array
• File upload — .json or .txt files

Nested objects

With Expand nested objects on (default), a nested object such as {"name":"Alice","address":{"city":"NYC","zip":"10001"}} becomes the columns name, address.city, address.zip. Turn the option off and the whole address block is written as JSON text inside a single cell, preserving the original structure.

Arrays

An array inside a value is written into one cell. Arrays of plain values are joined with ; (for example ["x","y"] becomes x; y); arrays that contain objects are written as JSON text. A spreadsheet cell holds one value, so an array cannot become its own set of columns.

Data types

• Numbers stay numbers, so they sort and calculate correctly.
• true / false are kept as booleans.
• Empty or null values become empty cells.
• Leading-zero strings — 007, 01234 — stay text, so zip codes, phone numbers and fixed-width IDs keep their zeros.
• Very long digit strings stay text, so large identifiers are not silently rounded.

Privacy

Uploaded files are read with the browser's own file reader and never leave your device. There is no upload endpoint on this page, no account, and no stored history. You can disconnect from the internet after the page loads and it will still work.

Using your file in spreadsheet software

Open the downloaded .xlsx by double-clicking it, or from inside Excel, Google Sheets, Numbers, or LibreOffice via File → Open. The first row holds the column names; each following row is one record. Because the file is a standard spreadsheet, you can sort, filter, chart, and re-save it like any other workbook.

Spreadsheet apps cap the number of rows per sheet. If your data exceeds that cap, the limit is the spreadsheet app's, not this converter's; the converter itself imposes no row limit and works in your browser's memory.

FAQ