How to Convert JSON to Excel

Convert JSON to Excel online for free—three steps: add JSON, choose .xlsx or CSV (and CSV options), then download. No desktop install for the core flow; files open in Excel, Google Sheets, or LibreOffice.

Open the converter

Steps

1
Step 1 — Add your JSON
Paste into the box, upload one local .json or .txt file (drag-and-drop or browse, max 10MB), or use From URL to load a public JSON document. JSON Lines (one object per line) works too. Use Format JSON to tidy or sanity-check structure—there is no multi-file batch upload.
2
Step 2 — Choose export format and options
Pick Download Excel (.xlsx) for a spreadsheet workbook, or Download CSV for plain text. For CSV, open CSV options on the converter: header row on/off, quote all fields or auto, and CRLF vs LF line endings.
3
Step 3 — Download
Your browser saves the file immediately—no server-side queue or mandatory account for the core tool. Open the .xlsx in Excel, Google Sheets, or LibreOffice; open .csv in any spreadsheet app.

JSON vs Excel—and what “flattening” means

JSON and Excel are both common for data, but they are shaped differently: JSON is text structured as trees (objects and arrays nested inside each other), while an Excel workbook is a table-oriented file (rows and columns). Converters bridge the gap by flattening—turning paths in the tree into column names.

Nested fields usually become dot-separated headers, e.g. minerals.fe, vitamins.c. An array of objects at the root typically becomes one row per object:

[
  {
    "CustomerID": "ALFKI",
    "CompanyName": "Alfreds Futterkiste",
    "ContactName": "Maria Anders"
  },
  {
    "CustomerID": "ANATR",
    "CompanyName": "Ana Trujillo Emparedados y helados",
    "ContactName": "Ana Trujillo"
  },
  {
    "CustomerID": "ANTON",
    "CompanyName": "Antonio Moreno Taquería",
    "ContactName": "Antonio Moreno"
  }
]

Nested objects inside a row flatten with dots—for example:

[
  {
    "name": "Avocado Dip",
    "carb": "2",
    "cholesterol": "5",
    "fiber": "0",
    "minerals": { "ca": "0", "fe": "0" },
    "protein": "1",
    "sodium": "210",
    "vitamins": { "a": "0", "c": "0" }
  }
]

…becomes columns such as name, minerals.ca, vitamins.c, and so on. To rename columns, do it in Excel or Sheets after download—this tool does not ship a separate “rename transform” step.

Prefer a fully offline, batch-capable desktop workflow? Use installed software or scripts on your own computer; this page stays browser-first. See also JSON & Excel basics.

Why use an online JSON to Excel converter?

In many teams, data arrives as JSON—from APIs, exports, and logs—while review and reporting still happen in spreadsheets. An online converter lets you move from JSON to a workbook without installing specialized desktop software for a one-off task. This site focuses on that single direction: JSON in, structured columns out, as a file you can open on any platform.

What you get in the file

One worksheet. Output is a single workbook with one sheet (Sheet1) containing all rows—easy to share and import elsewhere.
Excel or CSV. Download .xlsx for workbooks, or .csv for comma-separated text with configurable header, quoting, and line endings (UTF-8 with BOM for broad Excel compatibility).
Values from JSON. JSON numbers and booleans are written as numeric/boolean cells; strings stay as text. (ISO date strings remain text unless you store them as epoch numbers in JSON.)
Lists as tables. When a list of objects is the main payload (including nested API wrappers), the converter expands it to one row per item; nested fields become columns—see the home FAQ for details.

JSON and Excel in brief

JSON (JavaScript Object Notation): A common text format for structured data—objects, arrays, strings, numbers, booleans, and null—widely used in APIs, configs, and exports. It is not the same as a spreadsheet; conversion flattens that structure into rows and columns.
Excel workbook (.xlsx): This site produces .xlsx files (Office Open XML), the default format for Microsoft Excel since 2007. Older .xls binary workbooks are not generated here—use a current Excel version or another app that reads .xlsx.

FAQ

What JSON shapes are supported?

Root arrays of objects; a single plain object; nested API wrappers where the main data is a list inside an object (e.g. metadata plus an items array)—the longest object array expands to one row per item; and JSON Lines / NDJSON with one JSON object per line (common with MongoDB exports).

Is there a charge for using the converter?

The on-page JSON to Excel conversion is free to use. Optional account or paid features elsewhere on the site, if any, are separate—see Pricing.

Can I export or keep my data after processing?

Yes. Processing happens in your browser for the core tool; the output is a file download to your device. You keep full control of the file.

Do you store my JSON on a server?

Paste and file upload are processed in your browser for conversion. If you use From URL, our server fetches that public URL once to return the JSON text to your page—we do not use that as a general file-storage service. (Accounts, contact forms, etc. follow our Privacy Policy.)

Do you export .xls (old Excel) or .xlsx?

We export .xlsx (Office Open XML), the format used by Excel 2007 and later—not legacy binary .xls. You can also download CSV if you need plain text.

Can I convert several JSON files at once like some online tools?

This converter handles one pasted or uploaded payload at a time (up to 10MB). Run it again for another file, or merge sources offline if you need a single table.

Do I need to install desktop software to convert JSON to Excel?

No install is required for this web tool—use the converter in your browser. If you need offline batch jobs, long-running pipelines, or dozens of transforms (merge, dedupe, etc.), use a desktop ETL product or scripts on your own machine; this site focuses on quick, lightweight export.

Terms and privacy

Using the site is subject to our Terms of Service and Privacy Policy.

More detail in the FAQ page and on the home page.