What JSON shape can I convert to XLSX?
Use a non-empty JSON array of objects. Each object becomes one row, and all top-level keys become worksheet columns in the order first seen.
Convert a JSON array of objects into a downloadable Excel workbook.
Paste an array of JSON objects or choose a local JSON file. Preview the rows, then download one Excel worksheet.
Use an array of objects. Maximum 1,000,000 characters, 10,000 rows, 200 columns, and 200,000 cells.
Convert valid JSON to see its rows and prepare the XLSX download.
[
{ "id": "001", "name": "Roby", "score": 95, "active": true },
{ "id": "002", "name": "Budi", "score": null, "city": "Jakarta" }
]The workbook uses one worksheet named Data. The IDs stay as text, 95 becomes a numeric cell, true becomes a boolean cell, and missing or null fields become blank cells.
Each top-level object becomes one row. Keys are collected across every object without sorting. Nested objects and arrays are written as compact JSON text, while date-looking strings remain text.
Input is limited to 1,000,000 characters, 10,000 rows, 200 columns, 200,000 cells, and 100 levels of nesting. Local file imports must be 4 MB or smaller. The preview shows the first eight rows; the workbook contains every accepted row.
Duplicate keys follow standard JSON behavior, so the final value wins. Strings that start with spreadsheet formula characters remain literal text and are never exported as formulas.
Your JSON is processed in your browser and is not uploaded. Input, filenames, previews, and generated workbook bytes stay in memory for the current page session and are not stored by this tool.
Use a non-empty JSON array of objects. Each object becomes one row, and all top-level keys become worksheet columns in the order first seen.
Nested objects and arrays stay together as compact JSON text inside one cell. The converter does not flatten them or create extra worksheets.
Spreadsheet numbers have limited precision. The converter blocks unsafe integers and values with more than 15 significant digits. Put exact IDs or long decimal values in JSON quotes to export them as text.
No. Your JSON is processed in your browser and is not uploaded or saved by this tool.
Use XLSX when you want a ready-to-open Excel workbook with text, number, and boolean cell types. Use CSV when you need portable delimited text or want to choose a custom delimiter.
Explore another available JustRandom tool that may help with a related task.
Convert a JSON array of objects into CSV with delimiter options.
Convert CSV data with headers into pretty or minified JSON.
Format, beautify, pretty print, and validate JSON in your browser.