← ihatecalc

JSON to CSV Converter

About this JSON to CSV Converter tool

CSV is the format spreadsheets such as Excel and Google Sheets open directly. This tool converts a JSON array of objects into CSV, using the object keys as column headers. It is handy for turning API responses into something you can sort and filter.

How to use it

  1. Paste a JSON array of objects.
  2. Click Convert.
  3. Copy the CSV or save it as a .csv file and open it in your spreadsheet.

Example

[{"name":"Asha","age":30},{"name":"Ravi","age":28}]

Becomes:

name,age
Asha,30
Ravi,28

Frequently asked questions

What JSON shape does it expect?

An array of objects, where each object becomes a row.

What about nested objects?

Nested values may be shown as text. Flatten the JSON first if you need separate columns.

Can Excel open the result?

Yes. Save the output as a .csv file and open it in Excel or Google Sheets.

Related tools

JSON Formatter · YAML to JSON · Remove Duplicate Lines