JSON to CSV Converter
Turn JSON objects into spreadsheet-ready rows with correct quoting and optional nested-key flattening.
Rows
2
Columns
6
Chars
146
JSON input
CSV output
CSV generated
Created 2 CSV rows with 6 columns.
id,name,profile.city,profile.role,skills,active
1,Ada Lovelace,London,Engineer,"[""math"",""programming""]",
2,Grace Hopper,New York,Admiral,,trueQuotes, delimiters, and line breaks are escaped using standard CSV double-quote rules.
Convert JSON into CSV Rows
The JSON to CSV converter transforms an array of objects into a header row followed by one CSV row per object. It combines property names found across the array, so a field that appears later is still included as a column.
CSV cells containing delimiters, quotes, or line breaks are wrapped in double quotes, and embedded quotes are escaped. Choose comma, semicolon, or tab output depending on the spreadsheet or system that will read the file.
Nested JSON and Arrays
With nested-key flattening enabled, an object such as {"profile":{"name":"Ada"}} becomes a profile.name column. Arrays remain JSON text inside one cell because a flat CSV row cannot preserve an arbitrary nested list as separate rows without additional rules.
This tool is useful for:
- Moving API response data into a spreadsheet.
- Preparing small JSON exports for analysis or review.
- Converting fixture records into a table.
- Checking which fields vary across objects in an array.
Use the JSONPath Tester first when you need to select one nested array from a larger response. Use JSON to YAML when preserving the full nested structure matters more than a flat table.