JSON to CSV Converter
API responses into spreadsheets — columns built from your keys.
In
Nested objects and arrays are serialised into their cell as JSON text.
Out
product,units,revenue Desk lamp,42,2814 Monitor arm,17,3059 Cable set,130,1298.7
How JSON to CSV Converter works
The first array element's keys become the header row; every object contributes its values in that order. Keys that appear in later objects are unioned in so no field is dropped.
Nested values (objects, arrays) are serialised to JSON text inside their cell — lossless, and clearly marked so you can flatten deliberately rather than discover it in Excel.
Delimiter choice matters for Excel: comma for most locales, semicolon for European ones where comma is the decimal separator, tab for pasting into tools that expect TSV.
Worked example
Three product objects (product, units, revenue) become a 4-line CSV — header plus 3 rows — with 42-unit desks at $2,814. Download it, open in Excel, and the pivot is one click away.
The tool above opens with these numbers. Change them to run your own scenario, or press Reset to come back to this example.
Frequently asked questions
Related tools
Instant, clean table view of any CSV — no spreadsheet needed.
JSON, CSV, TSV and NDJSON — paste any, convert to any.
From 12,500 to 18,400 is +47.2% — with the reverse check done for you.
Mean, median, mode and range from any list of numbers.
Spread that means something — sample or population, with context.
Calculate the required survey or experiment sample size for statistical significance.
- json to csv
- convert
- spreadsheet
- export
- api