JSON to Excel Converter

Convert JSON to Excel — a real .xlsx, not a CSV

This tool converts JSON to Excel by building a genuine .xlsx workbook — the same Office Open XML format Microsoft Excel, Google Sheets, Apple Numbers, and LibreOffice Calc all read natively. Many so-called JSON to Excel converters actually hand you a CSV file with an .xlsx extension, which makes Excel show a warning and mangles anything with commas or leading zeros. Here the download is a proper spreadsheet, packaged in your browser, so numbers stay numeric, booleans stay boolean, and text stays text.

Paste a JSON array of objects, watch the spreadsheet preview build row by row, and download the workbook when it looks right. It is the quickest way to hand structured data to someone who lives in Excel — no scripts, no Power Query, no install.

How JSON maps to an Excel spreadsheet

A JSON array of objects maps onto a sheet the same way it maps onto a table: each object becomes a row, and the union of every key across the array becomes the column headers on the first row. Objects with different shapes still line up — a key that only some objects have gets its own column, and the rows that lack it are simply left blank in that cell.

A single JSON object (not wrapped in an array) becomes a one-row sheet, and a flat array of values becomes a single column. Whatever the shape, the header row is written first so the spreadsheet is self-describing the moment it opens.

Convert JSON to XLSX online — private by design

The entire conversion — parsing the JSON, flattening it into rows and columns, and zipping the .xlsx package — happens with client-side JavaScript. Your data never touches a server, so you can convert JSON to XLSX online even when the payload holds customer records, API keys, or anything else you would not paste into a random website. Once the page has loaded it even works offline.

To load your data, paste it directly, upload a .json file, or fetch it from a public URL. The output is a standard workbook you can email, attach to a ticket, or drop into a shared drive.

Nested JSON and arrays in Excel

Real JSON is rarely flat, so nested objects are flattened into dot-notation columns: a value at user.address.city becomes a user.address.city column rather than an unreadable blob in one cell. This keeps every scalar field addressable as its own column, which is exactly what a spreadsheet is good at.

Arrays that cannot be expressed as columns — a list of tags on a record, say — are written into the cell as compact JSON so nothing is lost. If you need arrays expanded into their own rows instead, flatten the JSON first, then convert.

JSON to XLS or XLSX — which format you get

People search for both "json to xls" and "json to xlsx", but they usually mean the same thing: an Excel file they can open. This converter produces .xlsx, the modern format introduced with Excel 2007 and supported by every current spreadsheet app. The older binary .xls format is effectively legacy and no longer recommended by Microsoft.

If a system you work with genuinely requires a .xls file, convert to .xlsx here, open it in Excel, and use Save As → Excel 97-2003 Workbook. For everything else, .xlsx is the right choice and imports without a single warning.

From API response to spreadsheet

A common workflow is turning a JSON API response into something a colleague can analyze. Fetch the response, paste it here (or load it straight from the endpoint URL), and export JSON to Excel in one step — the keys become a tidy header row and each record becomes a line you can sort, filter, and pivot.

Because the preview updates live, you can trim or reshape the JSON until the columns are exactly what you want before downloading, rather than cleaning up the spreadsheet afterwards.

JSON to Excel vs JSON to CSV

Reach for JSON to Excel when the person receiving the file expects a native spreadsheet — multiple sheets later, typed cells now, and no import dialog. Reach for the JSON to CSV converter when you want a plain-text, universally portable file for a data pipeline, a bulk importer, or a tool that speaks CSV. Both flatten nested JSON the same way, so you can switch based purely on the destination.