Skip to content
convertirdocs

JSON to Excel converter

Open a JSON file from an API, an app or an export tool and get a real Excel spreadsheet, with one row per record, one column per field and numbers you can calculate with.

100% free · no sign-upYour files never leave your device

or drop them here

How to convert JSON to Excel in 3 steps

  1. 1

    Open one or more .json files containing an array of objects.

  2. 2

    Check the preview of the first rows to confirm the columns.

  3. 3

    Download the Excel .xlsx file.

Your files never leave your device

This tool runs entirely inside your browser. The file is never uploaded to any server: it is read, processed and downloaded on your own device. When you close or reload the page, it is gone from memory.

JSON for people who work in Excel

A developer sends you an export, an online form tool gives you its results as JSON, or a platform's API returns orders, products or contacts. You need to sort, total, filter or chart that data, and the people who will look at it work in Excel. Opening JSON in a text editor doesn't help.

This converter turns an array of JSON objects into a spreadsheet: each object is a row and each field is a column. Fields that appear only in some records still get their own column, with empty cells where they are missing.

Numbers stay numbers, IDs stay intact

In the .xlsx file, numeric values are written as real numbers, so SUM, averages, filters and pivot tables work immediately. At the same time, the converter protects values that only look like numbers: codes with leading zeros and numbers longer than 15 digits are kept as text. That avoids the familiar problem of order numbers, tracking codes or bank accounts turning into scientific notation or losing their last digits.

Nested objects are flattened into columns with dotted names, such as customer.name or shipping.city, so every value has its own cell.

Typical uses

Reviewing orders exported from an online store, sharing user lists from an app with a sales team, auditing records from a database dump, building a quick report from a survey platform's results, or checking a product feed before importing it into a store. Analysts and support teams use it to hand data to colleagues without writing scripts.

You can convert several files at once and download them one by one or together. If you need a CSV instead, JSON to CSV produces one with the separator you choose.

A quick check before sharing the spreadsheet: look at the preview to confirm the columns, then, once it is open in Excel, freeze the header row and turn on filters so colleagues can explore the data. Column names come from the JSON keys, so if they are technical, such as created_at or sku_id, you may want to rename them in the spreadsheet for a non-technical audience.

Private, free and in your browser

JSON exports often include emails, names and internal IDs. The conversion runs in your browser, so the file is not uploaded and nothing is stored. It is free, with no account and no limits beyond your device's memory. To open and edit the resulting spreadsheet online, use Online spreadsheet.

Frequently asked questions

What format should my JSON be in?

An array of objects, where each object is one record. Each object becomes a row in the spreadsheet.

How are nested fields handled?

They are flattened into columns with dotted names, such as address.city.

Will long IDs turn into scientific notation?

No. Numbers longer than 15 digits and codes with leading zeros are saved as text, so they stay exactly as they were.

Can I calculate with the numbers in the file?

Yes. Regular numbers are written as numbers, so formulas, filters and pivot tables work.

Can I get a CSV instead?

Yes. Choose CSV as the output, or use the JSON to CSV page.

Can I convert several JSON files at once?

Yes. Open them together and download each spreadsheet separately or all of them in a ZIP.

Is my file uploaded?

No. It is converted in your browser and nothing is sent or stored.

Related tools