How it works
How to use the JSON to CSV
Paste JSON
Usually an array of objects, such as an API response. Nested objects become columns like address.city.
Pick a delimiter
Comma for most tools, semicolon for European Excel, or tab for TSV.
Download the CSV
Save it as a .csv file or copy it into a spreadsheet. Use Swap to go from CSV back to JSON.
How nested JSON becomes CSV
CSV is flat, JSON is not. Nested objects are flattened into dot-notation columns (customer.address.city) and arrays into indexed columns (tags.0, tags.1). Alternatively, choose As JSON text to keep nested values as JSON inside a single cell. Values containing delimiters, quotes or line breaks are quoted according to RFC 4180.
In the other direction, the converter auto-detects the delimiter, turns numeric and boolean strings into real JSON types, and rebuilds nested objects from dotted headers.
Built for developers
Why developers use it
Private by design
Runs 100% in your browser. Nothing you paste is uploaded, logged or stored on a server.
Instant results
Output updates as you type, with precise error locations when something is wrong.
Works offline
Once loaded, the tool keeps working without a connection. Install it as an app if you like.
Free, no sign-up
No accounts, no limits, no watermarks.
FAQ
Frequently asked questions
Will the CSV open correctly in Excel?
Yes. Enable CRLF line endings for maximum compatibility. If your Excel uses a comma as the decimal separator, choose the semicolon delimiter.
What if my objects have different keys?
Columns are the union of all keys, in order of first appearance. Missing values become empty cells.
Is my data uploaded anywhere?
No. This tool runs entirely in your browser. Your input never leaves your device, is not logged, and works offline once the page has loaded.
Keep going
Related tools
- JSON to XMLConvert JSON to XML and XML to JSON
- JSON to YAMLConvert JSON to YAML and YAML to JSON
- XML to JSONConvert XML to JSON and back
- YAML to JSONConvert YAML to JSON and back
- TOML to JSON ConverterConvert TOML to JSON and back
- JSON to StringConvert JSON into a string literal
- CSV to JSONConvert CSV to JSON and back
- JSON FormatterFormat, validate and explore JSON