JSON to Excel Converter

How to use the JSON to Excel (XLSX) tool

1. The tool expects an array of objects, one per row. Paste it into the left editor, load a file with Upload JSON, or fetch it with Load URL. Dummy Data shows the expected shape.
2. On the right you get a tab-separated preview of the sheet. The header row starts with the first object's keys, and keys that only appear in later objects are added at the end. A nested object or array lands in its cell as JSON text.
3. Click Beautify input to reindent the JSON if you want to check it first.
4. Click Download XLSX to save a workbook with one sheet named Sheet1.
5. Click Copy for Spreadsheet to copy the tab-separated preview, then paste it straight into an open Excel or Google Sheets tab.

How to convert JSON to an Excel XLSX file in JavaScript, Python and PHP

// npm install xlsx
const XLSX = require("xlsx");

const rows = [
  { id: 1, name: "Ada", joined: "2024-01-15", score: 98.5 },
  { id: 2, name: "Grace", joined: "2024-02-01", score: 91 },
];

const sheet = XLSX.utils.json_to_sheet(rows);      // first object's keys = header row
const book = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(book, sheet, "Data");
XLSX.writeFile(book, "data.xlsx");

# pip install openpyxl
import json
from openpyxl import Workbook

rows = json.loads('[{"id":1,"name":"Ada","score":98.5},{"id":2,"name":"Grace","score":91}]')

wb = Workbook()
ws = wb.active
ws.title = "Data"

headers = list(rows[0].keys())
ws.append(headers)
for row in rows:
    ws.append([row.get(h) for h in headers])   # numbers stay numeric cells

wb.save("data.xlsx")

<?php
// composer require phpoffice/phpspreadsheet
require 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

$rows = json_decode('[{"id":1,"name":"Ada","score":98.5},{"id":2,"name":"Grace","score":91}]', true);

$sheet = (new Spreadsheet())->getActiveSheet();
$sheet->fromArray(array_keys($rows[0]), null, 'A1');          // header row
$sheet->fromArray(array_map('array_values', $rows), null, 'A2');

(new Xlsx($sheet->getParent()))->save('data.xlsx');

Common errors and how to fix them

Excel says the file is corrupt or in a different format

The file was saved with .xlsx but contains CSV or HTML. Only a real Office Open XML writer produces .xlsx; renaming a .csv does not.

Dates appear as text and sorting is alphabetical

JSON has no date type, so ISO strings such as 2024-01-15 arrive as text. Convert the column with Excel's Text to Columns, or parse the string into a Date before writing when you generate the file in code.

Numbers show as 1.23457E+15 or lose digits

Excel stores numbers as 64-bit floats with 15 significant digits. Write IDs, phone numbers and card numbers as strings so they are stored in text cells.

Sheet name error: "Worksheet name cannot contain [ ] * ? / \ : and must be 31 characters or less"

Excel limits sheet names. Trim the name and remove those characters before calling book_append_sheet or ws.title.

Good to know