How to Use JSON to CSV / Excel Table Converter
- Paste your JSON into the big box, or tap the upload area and pick a
.jsonfile. No data handy? Press Try a sample. - Choose how lists inside a record should look. Joining them into one cell with a semicolon is the easiest to read.
- Press Convert to table. A preview of the first rows appears below.
- If the JSON holds more than one list, pick the one you want from the menu. The preview updates at once.
- 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.
- Shopkeepers: your online store or payment app lets you export orders, and the file comes as JSON. Convert it and hand your CA a sheet he can filter by date.
- CSC operators: some portals and APIs return a list of applicants or receipts as JSON. Turn it into Excel, then add your own notes and print it.
- Students and teachers: results or attendance data downloaded as JSON become a table you can sort by marks in a minute.
- Office staff: a software vendor sends you a data dump. Skip the programmer and open it as a spreadsheet.
- Developers: paste an API response from your browser tools or Postman and see the shape of the data as rows and columns before writing any code.
What it handles:
- A plain list of records, or a wrapper object such as
{"status":"ok","data":[...]}. The tool finds the list that holds the records. - Nested objects, flattened into columns named like
address.city. - Records that don't all have the same fields. Columns are collected from every record, and gaps are left empty.
- JSON Lines files, where each line is its own record.
- Long ID numbers. Most tools round a number like 123456789012345678. This one reads numbers exactly as written and saves long ones as text so they stay whole.
- Hindi, Marathi and other scripts, including characters written as
\u0939codes.
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.