Skip to content
Sealpaste

JSON to CSV Converter

Turn an array of JSON objects into a CSV you can open in Excel or Google Sheets. Nested fields become dotted columns.

Direction
Delimiter

Input JSON

CSV

How to use it

  1. 1Paste a JSON array of objects, or open a .json file.
  2. 2Pick the delimiter: comma for most tools, semicolon for Excel in many European locales, or tab.
  3. 3Download the .csv or copy it straight into a spreadsheet.

Private by design

Everything runs in this browser tab. Your input is never uploaded, logged or saved on a server, and there are no public "recent" pages. Close the tab and it's gone.

How we keep it private

Examples

Nested objects become columns

Columns are the union of all keys; missing values are left empty.

Input

[{"id": 1, "user": {"name": "Ada", "city": "London"}}, {"id": 2, "user": {"name": "Grace"}}]

Output

id,user.name,user.city
1,Ada,London
2,Grace,

How the columns are built

Every object in the array becomes one row. The header lists every key found in any object, in the order it first appears, so rows with extra fields don’t get lost.

With "Flatten nested objects" on, {"address": {"city": "London"}} becomes a column named address.city. Arrays and the nested objects you choose not to flatten are written as compact JSON inside the cell.

Values with commas, quotes or line breaks are quoted the standard way (RFC 4180), so spreadsheets read them back correctly.

Frequently asked questions

What JSON shapes can be converted?

An array of objects (the usual API list response), a single object (one row), or an array of arrays (written as rows directly).

Why does Excel put everything in one column?

Excel uses your system’s list separator. In many European locales that is a semicolon: choose "Semicolon" and open the file again.

Is my data uploaded?

No. The conversion runs in your browser, so exports with customer or user data never leave your computer.