Skip to content
Sealpaste

Delete all recent work?

This removes the 0 items saved in this browser. Your settings stay.

Stop saving recent work?

New work won't be saved in this browser. The 0 items already saved can stay or go.

JSON to CSV Converter

JSON

Paste JSON, or

CtrlV paste · Ctrl↵ run now

CSV
Ready
Ln 1, Col 1
Runs in your browser. Nothing you paste is uploaded unless you share it.

JSON array to CSV for Excel or Sheets, nested objects as address.city columns; comma, semicolon, tab or pipe; a table preview

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

How to use it

  1. Paste a JSON array of objects, or open a .json file.
  2. Pick the delimiter: comma for most tools, semicolon for Excel in many European locales, or tab.
  3. Under Options: Arrays as rows gives one row per record in a nested list (the other fields repeated); Dates writes ISO dates as 2024-03-05, 03/05/2024 or 05/03/2024; leave out the header row, quote every cell, or end lines with CRLF for Windows and Excel.
  4. Download the .csv or copy it straight into a spreadsheet.

Example

Nested objects become columns

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

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

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 "Nested as columns" 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.

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). Also JSON Lines, one object a line, and an object whose one array of records holds the rows, as in {"data": [...], "total": 2}; the status bar says which it read.
Can it read a file that isn’t UTF-8?
Yes for UTF-16 and UTF-32 files that start with a byte-order mark, as Windows tools often save them, and for Windows-1252 and ISO-8859-1 text. Other single-byte encodings, such as Windows-1251, are read as Windows-1252 and show the wrong letters, and the rest as a file that could not be read; save those as UTF-8 first.
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.
Why does it say some cells start like a formula?
A cell that starts with =, +, -, @, a tab or a carriage return may run as a formula when a spreadsheet opens the file. The CSV keeps your values as they are; turn on "Make safe for spreadsheets" to start those cells with an apostrophe, so Excel, Google Sheets and LibreOffice show them as text.
Is my data uploaded?
No. Everything runs in your browser, so your data stays on your device. Nothing you paste is uploaded unless you share a result, which is locked with your password first. That matters for exports with customer or user data.

Related tools