JSON to Excel Converter

JSON to XLSX in seconds — rows, columns, numbers and dates, as if the sheet were built by hand.

Reverse: Excel to JSON

Files never leave your device — everything runs in your browser

Copying JSON into Excel by hand means hours of pasting and checking that columns line up. The converter does it in one pass: every record becomes a row, nested fields become dotted columns, and numbers and ISO dates are written as real numbers and dates rather than text — so SUM works and date filters behave.

Complex exports get a dedicated mode: nested arrays on separate sheets, linked by id. Orders land on the first sheet, the items of each order on the second, and every item row carries its order's id, ready for a pivot table or XLOOKUP. A single object becomes a two-column Key / Value sheet.

The XLSX opens in Excel, Google Sheets, Numbers and LibreOffice with a bold header, autofilter, a frozen first row and column widths fitted to the content. Prefer CSV? Switch the file format in Options.

Nothing is uploaded: parsing and conversion run inside your browser, so API responses, CRM exports and files with personal data stay on your device.

Options and features

How to convert JSON to Excel in 3 steps

  1. 1

    Load the JSON

    Drop a .json file or paste text. Errors are shown with their line and column.

  2. 2

    Check the options

    Choose what to do with nested arrays, the column name separator and the flattening depth.

  3. 3

    Download the XLSX

    The workbook is ready immediately. Changed an option? Press Convert again.

Frequently asked questions

Convert it here and open the XLSX. Excel's own Power Query import also works, but it takes setup and isn't available everywhere.
We produce XLSX, which every Excel since 2007, Google Sheets and LibreOffice open. The old XLS format stops at 65,536 rows.
They unfold into dotted columns — customer.name, customer.city. You can limit the depth.
Up to 50 MB of JSON. Excel itself fits a little over a million rows per sheet.
Excel to JSON reads XLSX, XLS and ODS.

Related tools