JSON to Excel

Generate a real .xlsx file from a JSON array. Opens in Excel, Numbers, Google Sheets, or LibreOffice. Conversion runs in your browser.

SHEET
JSON INPUTarray of objects

From API response to spreadsheet in one click

The common workflow: hit an endpoint, get back JSON, want it in a spreadsheet for analysis or to send to a non-developer colleague. The usual path is CSV plus a manual import in Excel. This tool skips the CSV step and produces the .xlsx directly.

Nested objects are flattened with dot-notation column names (address.city, address.zip). Arrays of primitives are joined with commas. Arrays of objects are JSON-stringified — for those you usually want a separate sheet, which you can generate by splitting the array first.

Type-aware cells

Numbers stay numbers (you can sum them in Excel), ISO date strings are detected when possible, booleans become TRUE/FALSE. No string-quoted numbers that Excel mistakenly displays as text.

Privacy first

SheetJS runs locally in the browser. Your data is never uploaded. The download is generated and saved by your browser, not fetched from a server.

Common questions

Does this generate a real Excel file?
Yes. The output is a proper .xlsx file built with the SheetJS library, the same engine Microsoft 365 plug-ins use. Open it in Excel, Numbers, Google Sheets, or LibreOffice without conversion.
What about nested objects and arrays?
Nested values are flattened into separate columns using dot notation — address.city becomes one column, address.zip becomes another. Arrays of primitives are joined with commas. For deeply nested or polymorphic data, flatten by hand first or use the JSON to CSV tool which has the same behavior.
Can I choose the sheet name?
Yes — set it via the field at the top of the editor. The default is "Sheet1". Sheet names cannot contain : / \ ? * [ or ] and must be 31 characters or shorter; the tool truncates and strips invalid characters silently.
How big a JSON can I convert?
Excel files are stored uncompressed in memory before download. The practical browser limit is around 100 MB of source JSON. Past that, generate the file server-side or split the data into multiple sheets.
Does it preserve number formatting?
Numbers are written as numbers, dates as dates (when detectable from ISO strings), booleans as TRUE/FALSE. No styling is applied — Excel uses its default General format for each cell. Apply formatting in Excel after import if needed.
Is my data private?
Yes. The JSON parse and the Excel generation both happen in your browser. The xlsx library is bundled into the page; no network calls during conversion.