JSON → Excel Converter
Convert JSON into a real, downloadable .xlsx workbook — multiple sheets, flattened fields, real number/boolean cell types — entirely in your browser.
When on, a nested field like address.city becomes its own column. When off, nested objects and arrays are kept as a single JSON-text cell.
Advanced options
Dates are written in UTC (date-times without an offset are read as UTC). Epoch conversion only touches columns whose name looks like a date (date, time, created, updated, …_at) and whose values are all plausible timestamps between 1980 and 2100. Numbers stay numbers otherwise.
Drag and drop a .json or .txt file here
Turning JSON into a real spreadsheet without a server
An API response or a config file speaks JSON; the person who needs to review, filter, or chart that data almost always wants it in Excel. Getting there usually means either asking someone to write a throwaway script, or pasting the data into an online converter that quietly stores a copy of whatever you upload — which is a bad trade when the JSON in question is customer records, financial figures, or anything else you'd rather not hand to a third-party server.
This tool builds an actual .xlsx workbook — not a renamed CSV, but a real Excel file with typed cells, a bold header row, and sized columns — directly in your browser using a JavaScript spreadsheet library. Your JSON is parsed, converted, and packaged into the download entirely on your machine; nothing is ever transmitted anywhere. Numbers stay numbers and booleans stay booleans in the resulting spreadsheet, so a column of prices is immediately usable in a SUM formula instead of needing a find-and-replace pass first.
If your JSON is a single array of objects, you get one sheet. If it's an object whose top-level keys each hold an array — for example `{ "employees": [...], "departments": [...] }` — the tool automatically creates one sheet per key, named after that key, so a single JSON export with several related tables lands in one workbook with several tabs instead of forcing you to split it apart by hand. Nested fields like `address.city` can be flattened into their own dot-notation column, or left as a single JSON-text cell if you'd rather keep the raw structure visible.
The preview table shows exactly what each sheet will contain — row count, column count, and the first rows of data — before you commit to downloading anything, so you can adjust the flatten option or fix the source JSON first if the shape isn't quite right. Once it looks correct, name the sheet and the output file and click download. If you need the tabular data as plain text instead of a binary spreadsheet, the CSV ↔ JSON Converter covers that; if you're validating or reformatting the JSON itself first, the JSON Formatter & Validator is the natural first stop.
Frequently asked questions
Does it produce a real Excel file, not just a renamed CSV?
Yes — a genuine .xlsx workbook with a bold header row, typed numeric/boolean cells, and sized columns.
Can one JSON file produce multiple sheets?
Yes — if your JSON is an object whose top-level keys each hold an array, each key automatically becomes its own sheet. An object with a single array (for example { "users": [...] }) is unwrapped into one sheet named after the key.
Can I preview the spreadsheet before downloading?
Yes — a preview table shows the first rows of each sheet before you download the .xlsx file.