Converters
JSON and CSV Converter
Paste JSON and choose JSON to CSV, or paste CSV and choose CSV to JSON.
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.
How to use this tool
Paste JSON or CSV, drop or Import a file, or press Sample.
Choose JSON to CSV or CSV to JSON, then the Delimiter (Detect, Comma, Semicolon, Tab or Pipe). Turn Flatten nested objects, First row is a header and Convert numbers and true/false on or off to suit your data.
Check the row and column counts and the result, then Copy result, Download it, or use Use as input to convert it back.
How to use this tool
Paste JSON or CSV, drop or Import a file, or press Sample.
Choose JSON to CSV or CSV to JSON, then the Delimiter (Detect, Comma, Semicolon, Tab or Pipe). Turn Flatten nested objects, First row is a header and Convert numbers and true/false on or off to suit your data.
Check the row and column counts and the result, then Copy result, Download it, or use Use as input to convert it back.
Was this tool helpful?
Suggest an improvementHelp keep ConduitTools free
Every tool here is free, private and built by a solo developer. If this one saved you time, a small tip keeps the site running and new tools coming.
Nested JSON flattened into columns, and back again.
APIs speak JSON and spreadsheets speak CSV. Converting between them by hand breaks on commas, quotes, and nested values, so this handles those properly.
- Nested data, flattened
- An object such as address with a city inside becomes a single address.city column, so nested JSON still fits in a table.
- Proper CSV
- 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.
- Sensible types
- 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.