Convert JSON to CSV

JSON to CSV flattens an array of objects into rows with a header line, which is what you need before a spreadsheet or a bulk importer will accept the data. The conversion happens in your browser, so an API response containing real customer records never leaves your machine.

How to convert JSON to CSV

  1. Paste a JSON array of objects into the input.
  2. The keys of the first object become the header row.
  3. Copy the CSV, or download it and open it in the spreadsheet editor.

Last updated

Questions

What happens to nested objects?

CSV is flat and has no way to express nesting, so nested structures have to be flattened or dropped. Convert one level at a time if your JSON is deeply nested.

Do the objects all need the same keys?

They do not, but the header comes from the first object — so any key that appears only in later objects will not get a column. Normalise the array first if that matters.