Skip to content
Sumly

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
Rows3
Columns3
Open the semicolon variant directly in European Excel locales — comma CSVs land everything in one column there.

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

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