Skip to content
convertirdocs

JSON to CSV converter

Paste the output of an API or open a .json file and get a CSV table with one row per object and one column per field, ready for a spreadsheet, a database or a report.

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

or drop them here

How to convert JSON to CSV in 3 steps

  1. 1

    Open one or more .json files that contain an array of objects.

  2. 2

    Choose the CSV separator (comma, semicolon or tab) and check the preview of the first rows.

  3. 3

    Download the CSV files.

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.

From an API response to a table

JSON is the format most web services use to send data: orders from an online store, users from an app, results from a survey platform, records exported from a no-code tool or a log from a server. It is easy for programs to read and hard for people to scan. A CSV puts the same data in rows and columns that anyone can open in a spreadsheet, filter and share.

This converter expects the most common shape: an array of objects, where each object is one record. Each object becomes a row and each key becomes a column. If some objects have fields others don't, those cells are simply left empty.

Nested objects become columns

Real JSON is rarely flat. A customer record may have an address object with street, city and postcode inside it. Instead of dropping that information or dumping it as raw text, the converter flattens it into columns named with a dot, such as address.city and address.postcode. That keeps every value in its own cell, ready to sort and filter.

Check the preview before downloading: it shows the first rows, so you can see at a glance whether the columns match what you expected.

Arrays inside a record, such as a list of tags or order items, are harder to fit into a single row. If your file has deep lists like that, look at the preview first to see how they come out, and consider whether you need one table per level. For the common case of records with a few nested objects, such as a customer with an address or an order with a shipping block, the flattened columns are exactly what you need.

Separators, accents and IDs

Choose a comma, semicolon or tab as the separator, depending on where the CSV goes. If you will open it in Excel, the Excel-compatible option keeps accented letters readable. Values such as codes with leading zeros and very long numeric IDs are kept exactly as they were in the JSON, which matters for order numbers, account numbers and tracking codes.

If what you really need is a spreadsheet, JSON to Excel writes an .xlsx file directly, where numbers stay numbers for calculations and IDs stay as text.

Your data stays on your device

API exports often contain personal data or internal information. Here the conversion happens in your browser: the JSON is not uploaded to any server and nothing is stored. It is free, without an account, and you can convert several files at once. To go the other way, CSV to JSON turns a spreadsheet export into JSON.

Frequently asked questions

What JSON structure does it accept?

An array of objects, where each object is a record. Each object becomes a row and each key a column.

What happens to nested objects?

They are flattened into columns named like parent.child, for example address.city.

What if some records have extra fields?

Every field becomes a column, and records that don't have it get an empty cell.

Which separator should I use?

The one your destination expects. Comma is most common; semicolon is usual in countries that use a decimal comma.

Can I convert several JSON files at once?

Yes. Open them together and download each CSV, or all of them in a ZIP.

Does it work with JSON from any API?

It works when the data is an array of objects. If the array sits inside another object, check the preview to see whether the rows are the ones you expect.

Is my JSON sent anywhere?

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

Related tools