Skip to content
parsing.tools

JSON to CSV Converter

Turn a JSON list into a CSV file you can open in a spreadsheet.

  • Free, no account
  • Nothing uploaded
  • 13 tools
Input
Output
working…in 259 B · 5 linesProcessed in this tab, no request made

Nothing you paste is uploaded. The server sends connect-src 'self', so your browser blocks this page from contacting any other host. Check it yourself

Turn a JSON array of objects into CSV. Nested objects become dotted columns, values are quoted per RFC 4180 and you choose the delimiter. Runs in your browser tab.

How JSON becomes rows and columns

The converter expects an array of objects: one object per row, one key per column. Columns appear in the order their keys are first seen, and an object that lacks a key gets an empty cell.

[ { "sku": "BOLT", "bin": { "aisle": "C", "shelf": 4 } }, { "sku": "NUT", "note": "zinc, flat" } ]

sku,bin.aisle,bin.shelf,note
BOLT,C,4,
NUT,,,"zinc, flat"

Nested objects are flattened into dotted names. Arrays inside a row are written as JSON text in one cell, since a CSV cell cannot hold a list. A value containing the delimiter, a quote or a line break is wrapped in double quotes, with inner quotes doubled, as RFC 4180 describes.

Choosing the delimiter

Comma is the default. Spreadsheet programs in locales that use a decimal comma usually expect a semicolon. Tab output pastes straight into a spreadsheet. Going the other way? Use CSV to JSON.

Questions

Short answers to what people ask most.

What shape of JSON can be converted?

An array of objects, where each object becomes a row. A single object becomes one row, and an array of arrays is written as rows directly. An array of plain values is rejected because it has no columns.

What happens to nested objects and arrays?

Nested objects are flattened into dotted column names such as address.city. Arrays are written as JSON text inside one cell, because a CSV row cannot hold a list without inventing a convention.

Will Excel open the file correctly?

Quoting follows RFC 4180, which Excel reads. In locales where the decimal separator is a comma, Excel expects a semicolon delimiter: choose it in the options. Excel may also reinterpret long digit strings and dates; that is an Excel import behaviour, not something a CSV file can prevent.

Are columns in a fixed order?

Columns appear in the order their keys are first seen, scanning the objects from top to bottom. Objects that lack a key get an empty cell.