JSON to CSV Converter
This JSON to CSV converter turns a JSON array of objects into clean comma separated values that open straight into a spreadsheet. You paste a JSON array, where each item is an object with named fields, and the tool reads every object, builds a header row from all the keys it finds, and writes one CSV row per object. It runs entirely in your browser, so nothing you paste is uploaded to a server and your data stays private on your device. Developers, analysts, marketers and anyone moving data between an API and a spreadsheet use this to avoid hand editing or writing a one off script. The converter handles values that contain commas, quotes or line breaks by wrapping them in double quotes and doubling any internal quotes, which is the standard CSV escaping that Excel, Numbers and Google Sheets all understand. It also collects keys across every object, so if some objects have extra fields the header still includes them and missing values come through as empty cells. Three tips help you get a clean result. First, make sure your input is a true JSON array that starts with a square bracket and contains objects, not a single object on its own. Second, keep field names consistent across objects so the columns line up the way you expect. Third, if a value is itself an object or a nested array it will be written as JSON text inside the cell, so flatten deeply nested data first if you want tidy columns. Once converted, copy the output and paste it into a new spreadsheet, or save it with a dot csv extension and open it directly.
Runs in your browser. Nothing is uploaded.
How it works
The tool parses your text as JSON, expecting an array of objects. It gathers every key across all objects to form the header row, then writes one row per object, filling missing fields with blanks. Values with commas, quotes or line breaks are wrapped in double quotes with internal quotes doubled.
Worked example
Pasting an array of two people with name, age and city fields returns a header row of name,age,city followed by two data rows. A value containing a comma is automatically wrapped in double quotes so the columns stay aligned.
Related calculators
- URL Encoder Decoder: encode web text.
- Slug Generator: make URL slugs.
- UUID v4 Generator: random unique ids.
- Password Entropy Calculator: rate password strength.