89 · Text Tools

JSON to CSV Converter

Paste a JSON array to get CSV you can open in any spreadsheet.

How to use the json to csv converter

  1. Paste a JSON array of objects.
  2. Choose the delimiter.
  3. Copy the CSV, or save it as a .csv file.

How fields map

Every key that appears in any object becomes a column, so objects with missing keys get empty cells. Nested objects and arrays are written as JSON text in a single cell. Values containing commas, quotes or line breaks are quoted.

Examples

[{"name": "Ada", "age": 36}]

name,age / Ada,36

An object with "tags": ["a", "b"]

A tags column containing ["a","b"]

Questions

Excel shows everything in one column

In some regions Excel expects semicolons. Choose semicolon as the delimiter.

Can I convert a single object?

Yes. It becomes one row.