Convert JSON to Excel Online

Convert JSON files to Excel format directly in your browser. No upload required — your data never leaves your device.

About converting JSON to Excel

JSON to Excel is how API data reaches people who work in spreadsheets: a finance lead who wants Stripe payouts, a support manager reviewing a ticket export, or a marketer with a HubSpot contacts pull. The result is an .xlsx workbook with one sheet named Sheet1. Row 1 holds the JSON keys and each array element fills one row below it.

Cell types follow the JSON values. Numbers become numeric cells you can sum, true and false become Excel booleans, and null leaves the cell blank. Dates are the exception. A value such as 2026-03-05 is written as text, not as an Excel date serial, so date filters and date formats will not apply until you convert the column with DATEVALUE or Text to Columns.

Check nested data before you share the file. Objects and arrays inside a record are written into one cell as compact JSON text, which is hard to filter or sum in Excel. If your JSON has an address object or a tags array, run Flatten JSON first so the city lands in its own address_city column. Arrays of objects, such as order line items, need one row per item, which UNNEST in the SQL Query tool can produce.

Not sure which format you need? Read the Excel vs JSON comparison.

Worked example

A small sample file, converted with the default settings.

Input (JSON)

[
  {
    "id": 4101,
    "title": "Login fails on Safari 17",
    "state": "open",
    "comments": 3,
    "created": "2026-03-02",
    "assignee": "maria"
  },
  {
    "id": 4102,
    "title": "Export slow, then times out",
    "state": "closed",
    "comments": 8,
    "created": "2026-03-03",
    "assignee": null
  },
  {
    "id": 4103,
    "title": "Add dark mode",
    "state": "open",
    "comments": 12,
    "created": "2026-03-05",
    "assignee": "dev-team"
  },
  {
    "id": 4104,
    "title": "Crash on empty file",
    "state": "closed",
    "comments": 0,
    "created": "2026-03-06",
    "assignee": "li.wei"
  }
]

Output (Excel)

Excel workbook, first sheet (Sheet1)

id	title	state	comments	created	assignee
4101	Login fails on Safari 17	open	3	2026-03-02	maria
4102	Export slow, then times out	closed	8	2026-03-03	NULL
4103	Add dark mode	open	12	2026-03-05	dev-team
4104	Crash on empty file	closed	0	2026-03-06	li.wei

What changes when you convert JSON to Excel

Keys become the header row. The six keys in the example fill columns A to F of Sheet1.
id and comments are numeric cells. The created values are text cells that read 2026-03-02 and so on.
null and missing keys produce empty cells. Issue 4102 has a blank assignee.
Integers above 9,007,199,254,740,991 are written as text so every digit survives. Smaller long numbers are numeric, and Excel displays only 15 significant digits.
Nested objects and arrays become JSON text in a single cell, such as ["api","bug"].

Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.

Frequently Asked Questions

Why do some Excel cells contain JSON text?

Those keys held objects or arrays in the JSON. A spreadsheet cell holds one number, text or boolean, so nested values are written as JSON text rather than dropped. Flatten JSON turns one level of objects into ordinary columns; run it before converting.

Why does Excel not treat my date column as dates?

Dates arrive as text such as 2026-03-02. They sort correctly because the format is year-first, but Excel date filters ignore them. Select the column, use Data > Text to Columns and choose the YMD date format, or add a helper column with =DATEVALUE(E2).

How many JSON records fit in one sheet?

Excel allows 1,048,576 rows per sheet, including the header, and 16,384 columns. A larger JSON array will not fit. Filter or split the JSON first, or convert to CSV or Parquet instead.

What is Excel format?

Excel (XLSX) is Microsoft's spreadsheet format, widely used in business. It supports multiple sheets, formulas, and formatting.

Related Tools

Convert Excel to JSON Online

Convert Excel files to JSON format directly in your browser. No upload required — your data never leaves your device.

Excel Viewer Online

View and inspect Excel files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.

JSON Viewer Online

View and inspect JSON files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.

Validate JSON Files Online

Validate JSON file structure in your browser. Check null counts, distinct values, and data types for every column — no upload required.

Deduplicate JSON Files Online

Remove duplicate rows from JSON files instantly in your browser. No upload, no server — 100% private.

Filter Excel Files Online

Filter rows in Excel files by column value, directly in your browser. Your data stays on your device.

Convert JSON to CSV Online

Convert JSON files to CSV format directly in your browser. No upload required — your data never leaves your device.

Convert JSON to Parquet Online

Convert JSON files to Parquet format directly in your browser. No upload required — your data never leaves your device.