Convert

JSON to Excel Converter

Paste JSON or upload a .json file, pick the array to convert, choose how nested data is handled, name the worksheet and download a real .xlsx workbook that opens in Excel, LibreOffice and Google Sheets. Everything is processed in your browser; your data is not uploaded.

Back

1. JSON input and options

Local only

Processed in your browser; your files and data are not uploaded or stored. Formulas, macros and scripts in your data are never run.

2. Table preview and download

Live preview

Text is stored as plain text cells, so nothing in the workbook can run as a formula. The workbook has one worksheet with a bold header row; no styles or formulas are added.

JSON input up to 10 MB, 100,000 rows, 1,000 columns and 40 levels of nesting. An Excel cell holds at most 32,767 characters.

About this tool

About JSON to Excel Converter

JSON to Excel Converter creates a real .xlsx workbook from JSON. It accepts arrays of objects, arrays of arrays, or an object that contains such an array, flattens nested objects into dot-notation columns or keeps them as JSON text, and lets you name the worksheet.

JSON from an API or export is hard to review or share with people who use spreadsheets. Converting it to Excel makes it sortable and filterable. Because text is stored as plain text cells, values that look like formulas can never run when the file is opened.

How to use

Step by step

  1. Paste JSON or upload a .json file.
  2. If the root is an object, choose which top-level array to convert.
  3. Choose whether to flatten nested objects or keep nested values as JSON text.
  4. Enter a worksheet name and decide whether numbers should be stored as numbers.
  5. Check the table preview, then download the .xlsx file.
Key features

What it offers

  • Arrays of objects, arrays of arrays and selected top-level arrays
  • Dot-notation flattening or nested values as JSON text
  • Stable column order based on first appearance
  • Worksheet name validation using Excel's rules
  • Bold header row and numeric cells where safe
  • Clear errors with line and column for invalid JSON
Best practices

Tips for best results

  • Use arrays of objects with consistent keys for the cleanest columns.
  • Keep deeply nested data as JSON text if you need to round-trip it later.
  • Untick numeric storage for codes or IDs that must stay text.
  • Open the workbook once to check column widths and formats.
Benefits

Why people use it

Real .xlsx

Opens in Excel, LibreOffice and Google Sheets.

Formula-safe

Text cells are never written as formulas.

Private

JSON is parsed and the workbook built on your device.

FAQ

Common questions

A root array of objects (one row per object), a root array of arrays (one row per inner array), or an object that contains such an array at the top level — you choose which array to convert. Arrays that mix objects with plain values, and single values, are rejected with an explanation.
You choose. "Flatten" turns nested objects into dot-notation columns, so {"address": {"city": "Pune"}} becomes an address.city column; arrays inside an object are kept as JSON text in their cell. "Keep nested values as JSON text" puts every nested object or array into its cell as JSON.
Columns appear in the order their keys are first seen across all rows. If a row lacks a key, that cell is left empty.
With "Store numeric values as numbers" ticked, plain numeric values become number cells you can calculate with. Values with leading zeros, surrounding spaces or more than 15 digits stay as text to avoid losing digits. true, false and null become the text true, false and an empty cell.
Names of 1 to 31 characters that do not contain [ ] : * ? / or \, do not start or end with an apostrophe and are not "History". These are Excel's own rules; the page explains any problem.
No. Text is written as plain text cells, never as formulas, so values such as =SUM(A1) appear exactly as text when the file is opened.
The page shows the parser's message with the line and column where it failed, so you can fix a missing comma, quote or bracket. JSON is parsed safely and never run as code.
No. The JSON is parsed and the workbook is built in your browser using this site's own files. Nothing is uploaded or stored.
Private by design

This runs entirely in your browser

No file or text you enter here is uploaded. Encoding and decoding happen on your device using native browser APIs — close the tab and nothing remains on a server.

Install Toolisco Add it to your device for offline, one-tap access.