DevFormat Studio
Home / JSON to CSV / Excel Converter

JSON to CSV / Excel Converter

Convert JSON arrays to clean CSV with a live table preview and one-click download. Runs locally in your browser — nothing is uploaded.

Table preview

Your converted table will appear here.

What Is JSON to CSV Conversion?

JSON describes data as nested objects and arrays, while CSV (comma-separated values) describes it as a flat grid of rows and columns. Converting between them lets you take data returned by an API or exported from a database and open it in Excel, Google Sheets, Numbers or a data-analysis tool. Developers use this conversion constantly: to hand a report to a non-technical colleague, to import records into a spreadsheet, or to feed a legacy system that only accepts tabular files.

The challenge is that JSON is hierarchical and CSV is not. A good converter must decide how to represent nested objects, how to handle records with different keys, and how to escape commas, quotes and line breaks so the file opens correctly everywhere.

How to Convert JSON to CSV

Step-by-step instructions

  1. Paste a JSON array of objects into the input box, or press Load Sample Data to see an example.
  2. Pick a delimiter. Comma is standard, but semicolons are common in European locales and tabs suit pasting into spreadsheets.
  3. Leave Flatten nested objects ticked to turn {"address":{"city":"London"}} into a column named address.city.
  4. Press Convert. The table preview updates instantly so you can verify headers and values before exporting.
  5. Click Download .csv File or copy the text to your clipboard.

How edge cases are handled

The column list is the union of every key found across all records, so rows with missing fields simply get empty cells. Arrays are stored as JSON text inside a single cell. Fields containing the delimiter, quotation marks or newlines are wrapped in quotes with inner quotes doubled, following RFC 4180. The optional formula protection prefixes cells beginning with =, + or @ so spreadsheets never execute them as formulas. The download includes a byte-order mark so Excel detects UTF-8 characters correctly.

Privacy and Security Benefits

Exported datasets frequently contain customer names, emails, order histories or internal metrics. Uploading them to a random converter website exposes that information to a third party. DevFormat Studio parses and converts your JSON entirely in your browser memory. No request is made with your data, nothing is written to a server, and the preview table is rendered locally. When you close the tab the data is gone.

Frequently Asked Questions

Can I convert a single JSON object?

Yes. A lone object becomes a one-row table. If your object contains exactly one array property, such as {"users":[...]}, that array is used automatically.

Will the CSV open correctly in Excel?

Yes. The file is UTF-8 with a byte-order mark and CRLF line endings, which Excel and Google Sheets read without garbled characters.

What happens to nested arrays?

They are serialised as JSON text in one cell, preserving all information without inventing extra columns.

Is there a row limit?

No fixed limit. The preview shows the first 200 rows for speed, while the download contains every row.