JSON and Excel are both extensively used for storing and exchanging data. They are very different in structure (JSON is text structured as a tree and Excel is proprietary data structured as one or more tables). But you can easily convert JSON to Excel with Easy Data Transform:
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 Excel output:
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 Excel as:
Use the Rename Cols transform before output if you want to rename any of the columns.
If you have a large number of files to convert you can do it using the batch processing feature to do it in one operation.
As well as changing file format, Easy Data Transform also allows you to combine 65 transforms (such as merge, filter and de-dupe) to quickly and easily create complex data transformations.
v1.45.0 for Windows 11 / 10 / 8 / 7 (47 MB)
v1.45.0 for Mac 14.x to 10.13 (79 MB)
Questions or problems?