Skip to content

JSON to CSV Converter

Converts a JSON array of objects into CSV text with a header row.

0 characters

What is JSON to CSV Converter?

JSON is the usual format for data from web services, while CSV opens directly in a spreadsheet. Converting JSON to CSV lets you look at the data as a table.

What this tool does

Converts a JSON array of objects into CSV text. The column names come from the keys of all the objects, and values that contain commas, quotes or line breaks are quoted correctly.

How to use it

  1. Paste a JSON array of objects.
  2. Leave Auto ticked, or press Convert to CSV.
  3. Copy the CSV and paste it into a spreadsheet.

Did you know?

  • Nested objects and arrays are written into a single cell as JSON text.
  • Objects that are missing a key simply leave that cell empty.

More tools in this category