JSON to Excel

What this tool does

This tool turns a block of JSON data into a real Microsoft Excel workbook (.xlsx) that you can download and open straight away. You paste a JSON array of objects — or drop a .json file — and the tool reads it, works out the columns, shows you a preview of the table, and builds the spreadsheet on your device. JSON is the format that most apps, databases and APIs use to hand over data; Excel is the format most people actually want to work in. This converter bridges the two without any copy-paste-by-hand.

The tool loads with a small sample dataset so you can see the whole flow before using your own data. Each object in your JSON becomes a row, and the keys become the column headers.

Why and when you’d use it

Data arrives as JSON far more often than people expect. A developer sends you an export of sign-ups. A marketing platform’s API returns campaign results. A report-builder offers “download as JSON” but not Excel. In every case you are left with a wall of brackets and quotes that is unreadable to anyone who lives in spreadsheets.

Converting it to .xlsx makes the data usable: you can sort it, filter it, build a pivot table, add a chart, or simply hand a clean tab to a colleague. Because the output is a true Excel file and not a CSV, it opens on the right sheet with the right types and no import wizard — useful when you are sending the file to someone who should not have to think about delimiters or encodings.

How to use it

1. Paste your JSON array of objects into the input box, or drop a .json file onto the drop zone. The tool parses it immediately.
2. If the JSON is not a valid array of objects, a clear message explains the problem — for example an empty array, or an item that is not an object.
3. Review the detected columns. Uncheck any column you do not want in the spreadsheet.
4. Set the sheet (tab) name and choose whether to include a header row.
5. Check the preview table — it shows the first twenty rows exactly as they will appear in Excel.
6. Click Download .xlsx. The spreadsheet engine loads on this first click (it is a large library, so the button shows a brief “Preparing Excel file…” state), then the file downloads as data.xlsx.

CSV versus XLSX, and the leading-zero trap

It is tempting to convert JSON to CSV instead — CSV is simpler and opens in Excel too. The catch is that CSV carries no type information. Every value is just text, and Excel re-interprets that text when you open the file. The classic casualty is the leading zero: a ZIP code stored as 02134, a SKU like 00471, or a phone number, all lose their leading zeros because Excel decides they are numbers. Long numeric IDs can even be rewritten in scientific notation (1.23E+15). Once that happens on open, the original value is gone.

An .xlsx file avoids this because each cell’s type is written into the file. A value the tool treats as text stays text; a number stays a number. If your data contains codes, IDs, postal codes or anything where a leading zero matters, prefer the Excel download over CSV. If you genuinely need CSV, related tools like the JSON to CSV converter can produce that instead.

Common pitfalls and tips

Nested data is the most common surprise: a value that is itself an object or array is written into its cell as a JSON string, because a single cell cannot hold a structure. Flatten nested fields before converting if you need them in their own columns. Missing keys are fine — if one object lacks a key another object has, that cell is simply left blank. Finally, Excel limits sheet names to 31 characters and forbids the characters [ ] : * ? / \; the tool trims and cleans the name for you so the workbook always opens.

Privacy

This converter runs entirely in your browser. Your JSON is parsed and the Excel workbook is assembled on your own device by local JavaScript. Nothing is uploaded, nothing is stored between visits, and nothing is logged. That makes it safe to convert customer records, financial exports and other sensitive business data — the data never leaves your computer.