eDocTools

Convert JSON Data to Excel Table Online

Paste JSON or choose a file. Get a flat table you can download as Excel or CSV. Long ID numbers stay exact.

Tap to choose a JSON file, or drop it here .json, .jsonl, .ndjson or .txt, up to 50 MB

or paste your JSON below

How to Use JSON to CSV / Excel Table Converter

  1. Paste your JSON into the big box, or tap the upload area and pick a .json file. No data handy? Press Try a sample.
  2. Choose how lists inside a record should look. Joining them into one cell with a semicolon is the easiest to read.
  3. Press Convert to table. A preview of the first rows appears below.
  4. If the JSON holds more than one list, pick the one you want from the menu. The preview updates at once.
  5. Press Download Excel (XLSX) or Download CSV. You can also copy the CSV text.

Why Use This Tool? Practical Uses & Key Features

JSON is great for programs and awful for people. A shopkeeper can't sort it, and an accountant can't total it. A table can do both.

What it handles:

A word on the formula option. A cell that starts with an equals sign can run as a formula in a CSV opened in Excel. If your JSON comes from people you don't know, tick the option to add a small quote in front of those cells. The Excel download is already safe, because text there never runs as a formula.

100% Browser-Based Privacy & Security

Your JSON is read and converted by your own browser. It is not uploaded, not stored, and not logged. API responses often hold customer names, phone numbers or order details, so this matters.

Test it yourself: open the page, switch off your internet, and convert something. It still works, since nothing is sent anywhere. Close the tab and the data is gone.

Limits you should know about. Files up to about 50 MB work well. Excel sheets can hold at most 1,048,576 rows and 16,384 columns, so a giant file may be better as CSV. If your JSON is invalid, the tool tells you the line and column where it got stuck. The usual causes are single quotes instead of double quotes, a comma after the last item, or a missing bracket.

Last tip: if the preview shows one column called value, your JSON was a plain list of numbers or words. If it shows only one row, the top level was a single object and not a list, so check whether you pasted the right part of the response.

Frequently Asked Questions

How do I convert a JSON array to a CSV spreadsheet for free?

Paste the JSON or pick a .json file, press Convert to table, and download the CSV or Excel file. Each object in the array becomes one row, and each field becomes a column.

How do I flatten nested JSON into an Excel XLSX file?

The tool does it for you. A nested object like {"address":{"city":"Pune"}} becomes a column named address.city. For lists inside a record, choose between one joined cell, separate numbered columns, or raw JSON text.

Is this a good JSON table exporter for developers?

It is meant for quick checks and exports. You get a preview, automatic detection of the list inside a wrapper object, exact numbers, clear error positions, and both CSV and XLSX downloads. For repeated jobs inside an app, use a library in your own code.

How can I export an API JSON response to CSV?

Copy the response body from your browser's network tab, Postman or curl, and paste it in. If the records sit under a key such as data, items or results, the tool picks that list. When there are several lists, you choose one.

Will long ID numbers stay exact?

Yes. Numbers are read exactly as written, so an 18-digit ID is not rounded. In the Excel file, numbers longer than 15 digits are saved as text, because Excel itself can't hold more than 15 digits.