Skip to content
QuicklySorted

JSON to CSV Converter

Convert a JSON list of objects to CSV that opens in Excel or Google Sheets. Nested objects become columns such as address.city, and nothing is uploaded.

0 characters · 2,000,000 remaining

0 characters

Paste CSV or JSON above and the result appears here, converted in your browser.

On this device

No signup. Your input is never uploaded.

How to use the JSON to CSV Converter

  1. Paste a JSON list of objects, or load the example.

  2. Choose the separator and whether to include a header row.

  3. Copy the CSV, or download it to open in a spreadsheet.

An example

A list of two people

You enter

[{"name":"Ada","age":36,"city":"London"},{"name":"Linus","age":28,"city":"Helsinki"}]

You get

name,age,city
Ada,36,London
Linus,28,Helsinki

How the JSON to CSV Converter works

Each object in the list becomes a row, and the keys become columns, in the order they first appear. Values with commas, quotes, or line breaks are quoted by the standard CSV rules, so the file opens correctly in a spreadsheet.

Limits to know about

  • Up to 2 million characters of input are accepted.
  • Lists inside objects are written into a single cell as JSON text, because CSV has no way to nest.
  • Every item in the list has to be the same kind: all objects, all lists, or all plain values.

Questions about the JSON to CSV Converter

Paste a JSON list of objects. Each object becomes a row, and the keys become the column names in the first row. The CSV appears as you type, ready to copy or download.

With Flatten nested objects on, an object inside an object becomes a column named with dots, such as address.city. Lists are written into one cell as JSON text, because CSV has no way to nest.

Every key becomes a column, in the order it first appears, and a row that lacks a key gets an empty cell. Nothing is dropped.

A cell that starts with =, +, -, or @ can run as a formula when the file is opened in a spreadsheet. Protect from formulas puts a quote mark in front of such text so it shows as text. Turn it on for data from outside sources.

Last updated

Missing a tool?

Tell us what you wanted to do. Your ideas decide which tools we build next.

Suggest a tool on wisemensoft.com