Skip to content
ToolPlankDEV
JSON Tools
100% In-Browser Execution

Updated:

JSON to Excel Converter Online

Convert JSON to Excel in your browser. Paste JSON or choose a file, flatten nested objects into dot-notation columns, check the table preview and download an .xlsx, CSV or TSV file. Nothing is uploaded.

Processing in browser...

Loading the tool. It runs entirely in your browser, so your data is never uploaded.

More free tools you may need next.

Quick Guide

How to use JSON to Excel

Simple step-by-step instructions to get the exact output you need.

  1. 01

    Add your JSON

    Paste JSON on the Paste JSON tab, or choose a .json file on the Upload tab. The Sample button loads an example with nested objects and arrays so you can see how it works.

  2. 02

    Check the options

    Flatten nested JSON is on by default and turns nested objects into dot-notation columns such as address.city. Leave Root path empty to detect the list of records automatically, or type a path such as data.items.

  3. 03

    Review the table preview

    The preview shows the first 100 rows and 50 columns exactly as they will appear in the spreadsheet, even when the data is far larger. The badge shows the total rows and columns, and every download contains all of them.

  4. 04

    Download or copy

    Choose .xlsx, CSV or TSV, set a sheet name if you like and press Download. To paste straight into an open workbook, press Copy as TSV and use Ctrl+V in Excel. The swap button between the panels sends your table to Excel to JSON if you want to go the other way.

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:

JSON
{
  "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.
Python
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.

Frequently Asked Questions

Technical Q&A for JSON to Excel

Common questions about edge cases, character encoding, and privacy guarantees.

Excel 2016 and later can import JSON through Data > Get Data > From File > From JSON, which opens Power Query, but you must expand the records and lists by hand. To import JSON to Excel in one step, paste it into this converter and open the downloaded .xlsx file.

Choose your .json file or paste it, then download the result as .xlsx, the format every Excel since 2007 opens. This JSON to XLS converter does not write the old binary .xls format. If you need that, open the .xlsx in Excel and use File > Save As > Excel 97-2003 Workbook.

An Excel sheet cannot hold more than 16,384 columns, so the .xlsx download is switched off for such data. Choose CSV or TSV, which this tool writes for up to 100,000 columns, or turn off Flatten nested JSON, or use Root path to convert only a smaller part of the JSON.

Yes. Press the swap button between the two panels to open Excel to JSON with your table already loaded, then copy or download the JSON.

Open the Upload .json file tab and choose your file, or paste the JSON on the Paste JSON tab. Check the table preview, pick .xlsx and press Download. The tool creates .xlsx workbooks, which every current version of Excel opens. It does not write the old .xls format, but you can open the .xlsx and use Save As if you need one.

In Excel 2016 and Microsoft 365 go to Data > Get Data > From File > From JSON, pick the file, then use the Power Query editor to convert the list to a table and expand the columns. Excel 2013 needs the free Power Query add-in first. Excel 2007 has no Power Query, so convert the file with this tool and open the result instead.

Paste the JSON here with Flatten nested JSON switched on. Each nested value gets its own column named by its path, such as user.address.city, and array items are numbered, such as tags.0. Download the file and open it in Excel with every level already expanded.

Arrays inside a record are flattened into numbered columns such as tags.0 and tags.1, or kept as JSON text if flattening is off. null values and missing fields become empty cells. Booleans become TRUE and FALSE cells in .xlsx and the words true and false in CSV and TSV.

Yes. Files up to 150 MB and up to 15,000,000 values are supported. The conversion runs in the background of your browser tab, so the page does not freeze, and the practical limit is your device's memory. The preview shows only the first 100 rows to stay fast, and the download contains every row. For files much larger than that, use a script, for example pandas.

Use Power Query, which is built into Excel 2016 and Microsoft 365 under Data > Get Data > From File > From JSON, or skip Excel's editor and convert the JSON here first. Either way you do not need VBA or any code.

No. The JSON is read and converted by JavaScript in your browser tab, and the spreadsheet is built on your device. You can check your browser's Network tab to confirm that no request carries your data.