JSON to CSV

Convert JSON arrays to CSV format with automatic column detection

What is it and how does it work?

A JSON to CSV converter turns a JSON array of objects into a comma-separated table that spreadsheets understand. JSON is how data travels between APIs and applications — nested, flexible and built for machines — while CSV is the flat, row-and-column format that Excel, Google Sheets and database imports expect. Converting between them is one of the most common chores in data work: you have an API response or an export and you need it as a table you can sort, filter, chart or hand to someone who lives in a spreadsheet.

The conversion inspects every object in the array, collects the full set of keys to build the column header, then writes one row per object. The tricky parts it handles for you are the ones that quietly corrupt data: values that themselves contain commas, quotes or line breaks must be wrapped and escaped, and nested objects have to be flattened or stringified so they fit in a single cell. This tool does all of that in your browser, so even confidential exports never leave your device.

Common use cases

• Opening API data in Excel: convert a JSON response from an API into CSV so non-technical colleagues can analyse it in a spreadsheet.
• Preparing a database import: transform JSON records into CSV to bulk-load them into a tool that imports tables but not JSON.
• Building a report: flatten a JSON export of orders or users into columns to pivot, filter and chart the data.

Frequently asked questions

How are nested objects and arrays handled?

Because a CSV cell holds a single value, nested structures are flattened into separate columns or serialised as text within one cell. This keeps every value present in the output; deeply nested data is clearer when flattened into dotted column names first.

What happens to values that contain commas or quotes?

They are wrapped in double quotes and any internal quotes are doubled, following the standard CSV escaping rules. This ensures a value like "Smith, John" stays in one column instead of splitting the row.

What if my objects have different keys?

The converter collects every key that appears across all objects to form the header, and leaves cells empty where a given object lacks that key. The result is a complete, rectangular table even from irregular data.

Will my CSV open correctly in Excel?

Yes. The output uses standard comma separation and quoting that Excel, Google Sheets and Numbers all read. If a regional version of Excel expects semicolons, you can adjust the delimiter or use the spreadsheet's import dialog.

JSON

JSON Formatter · JSON Minifier · JSON Validator · JSON ↔ YAML · JSON Flatten · JSON Compare