An object such as address with a city inside becomes a single address.city column, so nested JSON still fits in a table.
Converters
JSON and CSV Converter
Turn a JSON array into a spreadsheet-ready CSV, or a CSV into JSON. Nested objects are flattened, and quoting is handled the way spreadsheets expect.
InputPaste JSON or CSV, or drop a file
ResultUpdates as you type
Nothing to convert yet
Paste JSON and choose JSON to CSV, or paste CSV and choose CSV to JSON.
What it handles
Data moves between formats without surprises.
APIs speak JSON and spreadsheets speak CSV. Converting between them by hand breaks on commas, quotes, and nested values, so this handles those properly.
Values containing commas, quotes, or line breaks are quoted correctly on the way out and read correctly on the way in, following the CSV standard.
Going from CSV, numbers and true/false become real JSON values, while codes with leading zeros such as 007 stay as text.
Frequently asked questions
What JSON shapes can it convert to CSV?
An array of objects is the usual case. An array of arrays, an array of plain values, and a single object also work.
What happens to arrays inside a record?
They are written into their cell as JSON text, because a table cell cannot hold a list. Split them afterwards if you need them apart.
Which delimiter does it use?
It detects comma, semicolon, tab, or pipe when reading CSV. When writing, it uses a comma unless you choose another, and you can pick semicolon for spreadsheets set to European locales.
Are values with leading zeros kept?
Yes. A value such as 007 or an ID with leading zeros is kept as text, so it does not lose its zeros. Turn off number conversion to keep everything as text.