How to convert JSON to CSV

JSON and CSV are both widely used for storing and exchanging data. They are very different in structure (JSON is structured as a tree and CSV is structured as a table). But you can easily convert JSON to CSV with Easy Data Transform:

JSON to CSV

convert JSON to CSV

JSON to CSV converter

Example JSON input:

[
  {
    "CustomerID": "ALFKI",
    "CompanyName": "Alfreds Futterkiste",
    "ContactName": "Maria Anders"
  },
  {
    "CustomerID": "ANATR",
    "CompanyName": "Ana Trujillo Emparedados y helados",
    "ContactName": "Ana Trujillo"
  },
  {
    "CustomerID": "ANTON",
    "CompanyName": "Antonio Moreno Taquería",
    "ContactName": "Antonio Moreno"
  }
]


Example CSV output:

CustomerID,CompanyName,ContactName
ALFKI,Alfreds Futterkiste,Maria Anders
ANATR,Ana Trujillo Emparedados y helados,Ana Trujillo
ANTON,Antonio Moreno Taquería,Antonio Moreno


The dot (‘.’) character is used to show nesting of JSON values. For example:

[
  {
    "name": "Avocado Dip",
    "carb": "2",
    "cholesterol": "5",
    "fiber": "0",
    "minerals": {
      "ca": "0",
      "fe": "0"
    },
    "protein": "1",
    "sodium": "210",
    "vitamins": {
      "a": "0",
      "c": "0"
    }
  }
]


Will be ‘flattened’ into a table as:

flatten nested JSON

Use the Rename Cols transform before output if you want to rename any of the columns.

If you have large number of files to convert you can do it using the batch processing feature.

As well as changing file format, Easy Data Transform also allows you to combine 42 transforms (such as merge, filter and dedupe) to quickly and easily create complex data transformations. See our quick start guide for more details.

JSON to CSV

Try it free now!

Windows Logo Windows Download

v1.6.2 for Windows 10 / 8 / 7 (48 MB)

Apple Logo Mac Download

v1.6.2 for Mac 10.15 to 10.12 (22 MB)


Questions or problems?

Email support@easydatatransform.com


Do you have a question?
We would love to help.

This pop-up will not be shown again