How JSON to Excel Conversion Works
A spreadsheet is flat, with one value per cell, and JSON is a tree that can nest objects inside arrays inside objects. A json to excel converter has to decide which part of the JSON becomes rows and how nested values become columns. This tool does both in your browser, so API responses and customer exports are never uploaded.
The records are found like this:
- A top-level array: each item becomes one row.
- An object that holds a list, such as { "data": [ ... ] }: the list is detected and used. If several lists exist, the nearest and longest one wins. Type a Root path to choose a different one.
- A single object with no list inside: it becomes a sheet with one row.
- JSON Lines (one JSON value per line, as many log exports use): each line becomes a row.
- An array of plain values such as [1, 2, 3]: a single column named value.
Flattening Nested JSON with Dot Notation
With Flatten nested JSON on, every nested value gets its own column. The column name is the path to the value, joined with dots:
{
"id": 1,
"user": { "name": "Ada", "address": { "city": "London" } },
"tags": ["math", "engine"]
}That single record becomes one row with these columns: id, user.name, user.address.city, tags.0 and tags.1. Array items are numbered from 0.
- Records with different keys are merged into one table. A record that lacks a field gets an empty cell.
- Empty objects and empty arrays become empty cells.
- Switch flattening off to keep nested values as JSON text inside one cell instead.
- Column order follows the first time each key appears.
Data Type Mapping and Real-World Uses
- Strings stay text. Emoji and non-Latin characters are kept, and CSV files are saved with a byte order mark so Excel reads them correctly.
- Numbers become numeric cells in .xlsx, so you can sum and sort them. In CSV and TSV they are written as plain digits.
- true and false become boolean cells in .xlsx and the words true and false in CSV and TSV.
- null and missing fields become empty cells.
- Dates are only text in JSON, so they stay text. Convert them with Excel's DATEVALUE or Text to Columns if you need real dates.
- A single cell holds at most 32,767 characters. Longer text is shortened and the preview tells you how many cells were affected.
Typical jobs include reading an API response in a spreadsheet, handing a database export to a colleague who works in Excel, building a report from an analytics export and checking a QA fixture side by side. To turn a spreadsheet back into JSON use Excel to JSON. When the JSON arrives as an escaped string, run it through JSON Unescape first, and use JSON Escape for the opposite direction. The Excel Case Converter can then tidy capitalization in the finished sheet.
Online Converter vs Power Query vs Python and JavaScript
- This online converter: no setup, a preview before you download and no upload. Good for one-off files and quick checks.
- Excel Power Query: built into Excel 2016 and later and Microsoft 365 under Data > Get Data > From File > From JSON. It is powerful for refreshable reports, but you expand lists and records column by column in the editor.
- Python with pandas: pandas.json_normalize flattens nested records and DataFrame.to_excel writes the file. It is the best choice for scheduled jobs and very large data.
- JavaScript: write the flattened rows with a library such as ExcelJS inside a Node script or your own app.
import json
import pandas as pd
with open("data.json", encoding="utf-8") as f:
records = json.load(f)["data"]
pd.json_normalize(records).to_excel("data.xlsx", index=False)json_normalize uses a dot as its default separator too, so the column names match what this tool produces for objects. Arrays are handled differently, because json_normalize keeps a list as one cell unless you ask it to expand the list.
Privacy and Limits
Your JSON is parsed and converted by JavaScript on your device, and the .xlsx file is built in your browser. Nothing is sent to our servers, and the Privacy Policy explains what the site does collect.
- JSON files up to 150 MB and pasted text up to 5,000,000 characters, with up to 15,000,000 values and 5,000,000 records.
- An .xlsx file holds at most 1,048,575 rows and 16,384 columns, which are Excel's own limits. CSV and TSV files can have up to 5,000,000 rows and 100,000 columns, so use them when your data is bigger than a sheet.
- The tool writes modern .xlsx workbooks. The old binary .xls format is not created, and every current version of Excel opens .xlsx files.
- Sheet names are limited to 31 characters and cannot contain \ / ? * [ ] or :. Those characters are removed for you.