HomeDevJSON to Excel Converter
Web tools

JSON to Excel Converter

Convert JSON arrays or objects to Excel (.xls) or CSV in your browser. Free online tool — no sign-up. Nothing is uploaded.

Loading tool…

Loading Preparing tool…

How to use

Follow these steps for a clear answer.

1

Paste JSON

Use an array of objects, a single object, or a 2D array of rows.

2

Preview the table

Columns are inferred from object keys or the first row.

3

Download

Export Excel SpreadsheetML (.xls) or CSV—nothing is uploaded.

JSON to Excel converter specification

Version 1.0.0 · Last reviewed 2026-07-29

Definition
JSON to Excel conversion flattens structured JSON into a tabular spreadsheet or CSV for spreadsheets and data tools.
What it calculates
JSON → table rows/columns → Excel SpreadsheetML (.xls) or CSV download.
Inputs
  • JSON text (array of objects, object, or 2D array)
Outputs
  • Table preview
  • Excel .xls download
  • CSV download
Formula
Object keys → columns; array elements → rows; nested values → JSON.stringify

Paste JSON and download an Excel (.xls) or CSV file. Arrays of objects become rows; keys become column headers.

Example

[
  { "name": "Ada", "role": "Engineer", "years": 12 },
  { "name": "Grace", "role": "Scientist", "years": 20 }
]
name role years
Ada Engineer 12
Grace Scientist 20
Assumptions
  • UTF-8 text; SpreadsheetML for Excel compatibility without a binary library.
  • Runs locally; data is not uploaded.
Units
  • Rows × columns in the preview table
Boundary conditions
  • Empty or invalid JSON → error.
  • Empty array → empty table.
Example
[{"name":"Ada","age":36}] → columns name, age
Validation cases
  • [{"a":1,"b":2}] → 1 row, columns a b
  • {"x":10} → 1 row object as key/value or single-row table
Sources
  • ECMA-404 JSON
  • Microsoft SpreadsheetML
Last reviewed
2026-07-29
Calculation version
1.0.0

Frequently asked questions

Key distinctions behind the tool.

What JSON shapes work?

An array of objects (recommended), a single object, or a 2D array of rows. Nested objects/arrays are stringified into cells.

Is it a real .xlsx file?

Downloads use Excel SpreadsheetML (.xls), which Excel and Google Sheets open. You can also export CSV.

Are files uploaded?

No. Parsing and export run entirely in your browser.