JSON to CSV - DigiKitApp

Convert a JSON array into a CSV table.

When should you use this?

Use this when you need to convert JSON data from an API or system into a table format (CSV) you can open and inspect in Excel.

When shouldn't you use this?

If the JSON data is deeply nested (nested objects or arrays), flattening it into a plain CSV table can lose information; you may need to simplify the structure first.

Step-by-step

Make sure your data is an array that starts with a square bracket, and that each item is an object with the same keys.
Paste it into the "JSON array" field.
Click "Run". You'll get CSV text with headers on the first line and one row per object below.
Copy the output and save it in a text file with a .csv extension, or paste it straight into a spreadsheet.

Example

Say you export three applications from a form service as an array of three objects, each with name, city and date fields. The tool turns that into a table whose first row holds the name, city and date headers, followed by three data rows. Open it in Excel or Google Sheets and you can sort by city, filter, or count entries per date. When you're handing data to a manager or a finance team, sending this table instead of raw JSON means they can read it without any extra tools.

The limit of converting JSON to CSV

CSV is a flat table, while JSON can hold nested objects and lists. So the conversion works most easily for a list of objects with the same fields: each object becomes a row and each field a column. Nested structures must be squeezed into a single cell, which hurts readability.

Tips when converting

Make sure the objects have the same fields; missing fields become empty cells.
If a field value contains a comma or a line break, double quotes are used.
When opening the result in Excel mind the delimiter and character encoding (UTF-8), or Turkish characters may break.
Nested data may need flattening first.

Things to keep in mind

In some regional settings, Excel expects semicolons rather than commas as the list separator. If the CSV opens with everything in one column, use the import-from-text option on the Data tab and choose comma as the delimiter.
If objects have different keys, some cells will be empty. That isn't an error; it means that record didn't have that field.
Values containing commas or line breaks need to be wrapped in quotes in CSV. Open the output and check that columns haven't shifted.
If accented or non-English characters look garbled in your spreadsheet, choose UTF-8 as the encoding when importing.

Frequently asked questions

Is the code/data I enter stored anywhere?

No, nothing is sent to a server or stored; processing happens entirely in your browser.

Does it work with large inputs?

Yes, though performance may degrade with very large inputs (several MB or more).

Is this tool free?

Yes, it's completely free for core use and requires no account.