JSON2CSV is a Apache2 Licensed python based utility that converts json data to a csv file.
python json2csv.py "input_file.json" "output_file.csv"
If you pass in the following json file:
[
{
"id": 1,
"name": {
"first": "john",
"last": "johnson"
},
"age": 27,
"languages": [ "c#", "vb", "python" ]
},
{
"id": 2,
"name": {
"first": "scott",
"middle": "scottster",
"last": "scottson"
},
"age": 29,
"languages": [ "objective-c", "c++" ]
}
]You'll get the following csv file:
age ,id ,languages_0 ,languages_1 ,languages_2 ,name_first ,name_last ,name_middle
27 ,1 ,c# ,vb ,python ,john ,johnson ,
29 ,2 ,objective-c ,c++ , ,scott ,scottson ,scottster