JSON to CSV Converter – Convert JSON Arrays to Excel-Ready CSV

How to use JSON to CSV Converter

1. Paste your JSON array.
2. Choose the delimiter.
3. Check the preview table.
4. Click “Download CSV” or copy the CSV text.
5. Open the file in Excel, Google Sheets or Numbers.

How the conversion works

CSV is a flat table, JSON can be deeply nested. The converter:

• uses each object as one row;
• collects all keys from all objects as columns, so rows with missing fields get empty cells;
• flattens nested objects with dots: {"address": {"zip": "1000"}} becomes a column address.zip;
• keeps arrays as JSON text in one cell, for example ["a","b"];
• quotes values that contain the delimiter, quotes or line breaks, following RFC 4180.

If you paste an object instead of an array, the converter looks for the first array inside it (for example a data or items field), which is how many APIs wrap their results.

Example

Comma or semicolon?

In countries that use a comma as the decimal separator — Germany, France, Spain, Brazil and many more — Excel expects semicolons between columns. If your CSV opens with everything in column A, switch to semicolon and download again. Tabs work everywhere and avoid the problem entirely.

Excel and special characters

The downloaded file starts with a UTF-8 byte-order mark, so Excel shows accents, € signs and other characters correctly instead of garbled text.

Large files and privacy

Everything is processed in your browser, so customer lists and exports never leave your computer. The preview shows the first 50 rows, while the CSV contains all of them. To clean up or validate the JSON first, use the JSON Formatter. Working with API tokens too? The JWT Decoder reads them.

Going the other way

If you edit the data in a spreadsheet and need JSON again, export the sheet as CSV and convert it with a script or a CSV to JSON tool. Keep the column headers unchanged so the field names match the original structure. For nested fields, the dotted column names make it easy to rebuild the original objects, because each part of the name stands for one level of nesting.

You may also find these free tools useful: JSON Formatter, Password Generator and Regex Tester.