All tools
Free · Private · No upload

Convert JSON to Excel Online

Open JSON data as a spreadsheet and download it as an XLSX workbook. The JSON is parsed in your browser and never uploaded.

Drop a CSV or Excel file here

CSV · XLSX · XLS · XLSM · XLSB

or paste your data below

How to convert JSON to Excel

Three steps from issues.json to an XLSX file.

1. Paste the JSON

Paste JSON or drop a .json file. Arrays, keyed objects and JSON Lines all work.

2. Check it in the grid

Check the column order: it follows the order in which keys first appear. Delete columns you don't need before you download.

3. Download XLSX

Click Download XLSX. The workbook (data.xlsx) is built from the grid as it is at that moment, in your browser.

Example: JSON in, Excel out

Issues exported from a tracker: a plain array of objects, with a labels array and an assignee only on one issue.

issues.json
[
  { "id": 412, "title": "Login fails on Safari", "state": "open", "labels": ["bug", "auth"] },
  { "id": 415, "title": "Add dark mode", "state": "closed", "assignee": "kim" }
]
data.xlsx, sheet 1
ABCDE
1idtitlestatelabelsassignee
2412Login fails on Safariopen["bug","auth"]
3415Add dark modeclosedkim

The labels array arrives as JSON text in one cell (["bug","auth"]), and issue 412 has an empty assignee cell because the key is missing there.

What changes between JSON and Excel

Built from the grid

The XLSX is made from the grid, row for row: the header row (id, title, state, labels, assignee) is row 1 and the first data row is row 2. The "First row as header" checkbox affects only text outputs, not the workbook.

Edits included

Anything you change in the grid before downloading (a fixed typo, a deleted column, a renamed header) is what ends up in the file.

Not everything stays typed

Nested values are not flattened but written into one cell as JSON text, like ["bug","auth"]. null becomes an empty cell, and that is how they reach the Excel.

When to convert JSON to Excel

JSON to Excel in JavaScript

JSON needs no parser: JSON.parse gives you the data. Writing the .xlsx is the part TabularJS leaves to a writer library.

import { readFile } from 'node:fs/promises';

const items = JSON.parse(await readFile('issues.json', 'utf8'));
const toText = (v) => (v == null ? '' : typeof v === 'object' ? JSON.stringify(v) : String(v));
const header = [...new Set(items.flatMap((o) => Object.keys(o)))];
const rows = items.map((o) => header.map((key) => toText(o[key])));

// TabularJS reads spreadsheets but does not write them.
// [header, ...rows] is the 2D array an XLSX writer takes; this page
// builds the file with Jspreadsheet and its @jspreadsheet/render extension.
console.log([header, ...rows]);

TabularJS reads spreadsheet files, not JSON; JSON.parse is all JSON needs.

npm install tabularjs MIT licensed

Frequently asked questions

Does every object become a row?

Yes, one row per object in the array, under a header row of keys. Keys missing from some objects leave those cells empty.

Can nested arrays go into separate sheets?

No. The page builds one sheet, and nested arrays stay as JSON text in a cell. Split the data into separate arrays in code if you need one sheet per array.

My JSON is wrapped in an object like {"data": [...]}. Will it work?

Yes. When the top level is not a table, the largest array of objects among its properties is used, and other properties (counts, paging links) are ignored.

Is the header row kept in the workbook?

Yes, as row 1. The workbook mirrors the grid, so the "First row as header" checkbox does not change it.

Does issues.json get uploaded when I convert it to Excel?

No. The JSON is parsed in your browser and never uploaded.