JSON

JSON to CSV Converter

Converts an array of JSON objects into CSV, flattening nested objects into dotted column names.

Loading the tool…

Processing happens locally in your browser. What you paste or load is processed by this page and is not uploaded to a server. Nothing is stored unless you use a control that says it stores something, and you can clear anything this site has kept from the privacy page.

How to use this tool

  1. Paste an array of JSON objects. A single object is treated as one row.
  2. Pick the delimiter and how scalar arrays should be joined into a cell.
  3. Select Convert to CSV, or Preview as table to check the columns first.
  4. Download the CSV and open it in your spreadsheet.

What json to csv does

An API returns an array of objects; a spreadsheet wants rows and columns. The conversion is straightforward when every object has the same keys, and the interesting part is what happens when they do not. This converter takes the union of every key it sees, so an object missing a field produces an empty cell rather than a shifted row.

Nested objects are flattened into dotted column names, so profile.city becomes a column called profile.city. Arrays of scalars are joined with a separator you choose, because a CSV cell cannot hold a list. Arrays of objects have no honest flat representation, so they are serialised back to JSON inside the cell and left for you to deal with deliberately.

Frequently asked questions

They are flattened into dotted column names, so profile.city becomes a column named profile.city. The nesting is preserved in the column name rather than lost.

An array of scalars is joined into one cell using the separator you choose. An array of objects has no honest flat representation, so it is written back as JSON inside the cell — that keeps the data rather than silently dropping it, and lets you decide how to split it.

The header is the union of every key seen across all records. A record missing a key produces an empty cell in that column, so rows stay aligned instead of shifting.