JSON to Excel Converter

Key Features

Real XLSX Workbook

Download an actual .xlsx workbook with a single worksheet, ready to open in Excel, Google Sheets, and LibreOffice Calc. No import wizard or text-column mapping is required.

Array of Records Input

Paste a JSON array of objects or open a .json file. Each array item becomes one worksheet row, and the detected fields become columns.

Flatten Nested Objects

Turn nested objects into dotted column names such as `address.city`. Arrays of objects become indexed columns such as `items.0.name`, and arrays of simple values are written as JSON text.

Collect Every Field

Columns are collected from every record, not just the first one. Fields missing from a record are exported as empty cells instead of shifting the row.

Optional Header Row

Include the column names as the first row, or turn the header off when appending data below an existing spreadsheet.

Preview Before Download

Review the flattened records and detected columns in the preview panel before exporting the workbook.

Copy as CSV Text

Copy the same rows as comma-separated text when you only need to paste values into a sheet. The CSV copy uses a comma delimiter and follows the header setting.

Browser-Based Processing

JSON parsing and workbook generation happen in your browser. The page does not require an account or upload the source JSON to a remote service.

How to Use

Enter or open JSON

Paste a JSON array of objects into the editor or open a .json file from your device.

Choose export options

Enable flattening for nested objects and decide whether the first row should contain column names.

Convert and preview

Run the conversion and review the flattened records, detected columns, and row count in the preview panel.

Download or copy

Download the .xlsx workbook, or copy the rows as CSV text when you only need to paste values.

How to Convert JSON to Excel (XLSX)

What this JSON to Excel converter does

A JSON to Excel converter turns a JSON array of objects into an XLSX worksheet: each array item becomes a row and the detected fields become columns. The downloaded file is a real workbook you can open directly, not plain text you must import through a wizard.

It restructures data; it does not analyse it. It does not build charts, pivot tables, or formulas, and it does not decide which fields to merge.

Common use cases

Business analysis: Export API records to a sheet your colleagues open in Excel.
Data delivery: Hand operations, finance, or clients a file they can open directly.
Review and audit: Flatten records into rows to check missing fields and unexpected values.
Migration and import: Prepare tabular data for a CRM, ERP, or finance system.

How to convert JSON to Excel

Prepare the array: Make sure the input is a JSON array of objects; wrap a single object in an array.
Choose options: Enable flattening for nested data and decide whether to include a header row.
Preview: Confirm the column names, row count, and flattening result look right.
Download: Export the .xlsx workbook, or copy the rows as CSV text to paste into a sheet.
Double-check: In your spreadsheet, review numbers, dates, and empty values.

How nested JSON becomes columns

Sheets are two-dimensional, so nested structures must be flattened. With flattening enabled:

Nested objects: Dotted column names such as address.city, at any depth.
Arrays of objects: Indexed column names such as items.0.name.
Arrays of simple values: Written as JSON text in one cell, because a single column cannot safely hold a list of varying length.
Missing fields: Left as empty cells so rows stay aligned with columns.

Different tools flatten nested structures differently, so preview before exporting.

Data types and empty values

Numbers and booleans are written as cells of that type and can be sorted or calculated directly. Null and missing fields become empty cells. Dates stay as the original JSON strings, because JSON has no date type and the tool cannot reliably tell whether a string is a date; convert them in your spreadsheet when you need real date cells.

XLSX vs CSV

XLSX is a workbook format: one file can hold worksheets, cells carry type information, and spreadsheet apps open it by double-clicking. CSV is plain text with delimiters, and regional defaults for separators and encoding can differ. This page downloads XLSX; the Copy CSV button only puts the same rows on the clipboard as comma-separated text for quick pasting.

Limitations to keep in mind

Input must be an array: A root object errors; extract its array first.
One worksheet: A single conversion produces one sheet.
Very large arrays: Limited by browser memory; sample or split first if needed.
No type conversion: Dates and number precision should be reviewed in the sheet.

Browser-based privacy

The workbook is generated in your browser and the JSON is not sent to a remote conversion service, which is convenient for everyday development and data work. It is not a secret-management system, so avoid pasting passwords, API keys, access tokens, or production customer data into any browser tool.

Excel to JSON → JSON to CSV Converter → CSV to JSON Converter → JSON Editor →

Frequently Asked Questions

Does this create a real Excel XLSX file?

Yes. The download is a real .xlsx workbook with a single worksheet named Sheet1, so you can open it directly in Excel, Google Sheets, and LibreOffice Calc without importing text.

Can I choose comma, semicolon, or tab output?

The XLSX download does not use a delimiter, so no delimiter setting is needed. The CSV copy button always uses a comma, because that is what spreadsheets expect when pasting text.

What JSON structure works best?

A JSON array of objects works best, where each object is one record. Flat objects export one column per key, and nested objects are flattened when the option is enabled.

Can I convert a JSON object instead of an array?

No. The input must be a JSON array. Wrap a single object in an array, for example `[{ ... }]`, or select the array inside the object, such as the `items` array of an API response.

Does it support nested JSON objects?

Yes, when flattening is enabled. Nested objects become dotted columns such as `address.city`, arrays of objects become indexed columns such as `items.0.name`, and arrays of simple values are written as JSON text. Turn the option off to keep nested objects out of the workbook columns.

Are all fields exported, or only the fields of the first record?

Columns are collected from every record in the array. A field that is missing from one record becomes an empty cell in that row, so rows stay aligned even when records have different fields.

How are numbers, booleans, dates, and null values exported?

Numbers and booleans are written as cells of that type. Null and missing values become empty cells. Dates stay as the original JSON strings, so convert them inside your spreadsheet if you need real date cells.

Can I remove the header row?

Yes. Turn off the header option and the workbook and CSV copy will contain data rows only, which is useful when appending below an existing sheet.

Can I export multiple worksheets?

No. One conversion produces one worksheet. Convert each array separately if you need several sheets, then combine them in your spreadsheet application.

Can I convert large JSON files?

The practical limit depends on browser memory, device performance, and record count. Very large arrays take longer to flatten and export, and may exhaust available memory.

Is my JSON uploaded to a server?

The workbook is generated in your browser and does not require a server upload. You should still avoid entering passwords, API keys, tokens, or confidential customer data into any browser-based tool.

Is this a free JSON to Excel converter?

Yes. You can paste JSON or open a file, preview the rows, and download the XLSX workbook without creating an account.