JustRandom

JSON to XLSX Converter

Convert a JSON array of objects into a downloadable Excel workbook.

Convert JSON to XLSX

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.

Workbook preview

Convert valid JSON to see its rows and prepare the XLSX download.

How to convert JSON to XLSX

  1. Paste a JSON array of objects or choose a local `.json` file.
  2. Select Convert to XLSX to validate and prepare the workbook.
  3. Review the worksheet preview and row and column counts.
  4. Select Download XLSX to save `converted.xlsx`.

Example JSON to Excel conversion

[
  { "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.

Data mapping and limits

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.

Private browser-based conversion

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.

Frequently asked questions

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.

How are nested objects and arrays handled?

Nested objects and arrays stay together as compact JSON text inside one cell. The converter does not flatten them or create extra worksheets.

Will large numbers keep their exact value?

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.

Is my JSON uploaded?

No. Your JSON is processed in your browser and is not uploaded or saved by this tool.

When should I use XLSX instead of CSV?

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.

Related tools

Explore another available JustRandom tool that may help with a related task.