JSON to Excel

Convert JSON to Excel online for free — turn an array of objects into a spreadsheet with one column per key, flatten nested objects into dotted columns (address.city), and turn an object of arrays into a workbook with one sheet per key. Paste JSON or drop a file; it all runs in your browser.

100% private — everything runs in your browser. Conversion happens on your device; nothing is uploaded.

100% private — runs in your browser
…or paste JSON text

Converted in your browser with SheetJS — your data never leaves your device. Excel formulas are exported as their calculated values; formatting such as colours and merged cells isn’t carried into CSV or JSON.

How to convert JSON to Excel

  1. Drop a JSON file or paste JSON.
  2. Check the preview.
  3. Click Download Excel (.xlsx).
  4. Open it in Excel, Google Sheets or Numbers.

What you can use it for

  • Turn API responses into spreadsheets for analysis
  • Share JSON exports with non-technical colleagues
  • Review app data and logs in Excel
  • Create reports from database exports

More free tools

Building for the web?

Format, minify, convert and generate code with our free, private developer tools.

See all free tools →

Frequently asked questions

What JSON structures work?

An array of objects (one row each), an array of arrays (rows and columns), or an object whose values are arrays (one sheet each). A single object becomes one row.

What happens to nested objects?

They're flattened into dotted column names like address.city. Arrays inside a row are joined with commas.

Is my data uploaded?

No. The conversion runs in your browser with the open-source SheetJS library, so spreadsheets with customer or financial data stay on your device.

What if my JSON objects have different keys?

Every key found in any object becomes a column, in the order the keys first appear, starting with the first object. The column names go in row 1 and each object fills one row below. If an object has no value for a column, or the value is null, that cell is left empty, so records with missing or extra fields still line up under one header row.

Are numbers, true/false and dates kept as real values?

Numbers in your JSON become number cells, and true or false become true/false (boolean) cells. Strings stay text exactly as written, which keeps leading zeros in codes such as "00123". Dates are written as text, for example 2026-01-05, because JSON has no date type. An array of values inside a row becomes one text cell, such as 1, 2, 3.

How do I get several sheets in one workbook?

Use one object whose values are all arrays, such as {"Users":[…],"Orders":[…]}. Each key becomes a sheet with that name, cut to 31 characters, and each array is converted as usual: objects give rows under a header row, arrays give plain rows and columns. If any value isn't an array, the whole object becomes a single row instead. The preview shows the first sheet; the download contains them all.

Can I combine several JSON files into one workbook?

Yes. Select the files together and drag them onto the drop box in one go. Each file becomes its own sheet, named after the file without .json and cut to 31 characters, and a repeated name gets a number, such as orders 2. The status line confirms how many files were combined. The click-to-browse picker opens one file at a time, so use drag and drop for several.

Why do I see “Couldn't read the pasted data”?

That message, or “Couldn't read this file” for a dropped or chosen file, usually means the text isn't valid JSON. The browser's own error text after the colon describes what it found. Check that keys and strings use double quotes, every bracket and brace is closed, and there's no comma after the last item. JSON Lines, with one object per line, needs wrapping in [ ] with commas between the objects.

Why does a sheet name error appear?

With an object of arrays, each key becomes a sheet name, so sheet-name rules apply. A key can't contain : \ / ? * [ or ], start or end with an apostrophe, or be called History. Keys are also cut to 31 characters, so two long keys that begin the same way can clash and show an “already exists” error. Rename those keys in your JSON and convert again.

What does the downloaded Excel file contain?

An .xlsx workbook named after your file, so orders.json becomes orders.xlsx, or data.xlsx when you paste. A plain array goes on one sheet called Sheet1; for an array of objects, the column names fill the first row. Column widths are set from the longest value in the first 500 rows, between 6 and 60 characters wide. The cells hold plain values, with no formulas or styling added, and the file is built in your browser.

Is there a sign-up, or a limit on rows or file size?

There's no sign-up or account. The tool sets no file-size limit of its own, and a large file is processed on your own device rather than on a server. The preview shows the first 50 rows and 20 columns, but the download includes every row and column, up to the .xlsx sheet limit of 1,048,576 rows and 16,384 columns. One cell can hold up to 32,767 characters of text, so shorten any longer value before converting.

Can I convert Excel back to JSON?

Yes, use our Excel to JSON converter. It turns spreadsheet rows into a JSON array of objects keyed by the header row, or into an array of arrays, keeps numbers and true or false as real types, and can export one sheet or every sheet at once. Like this tool, it runs in your browser, so your spreadsheet stays on your device.