JSON2CSV is a Apache2 Licensed python based utility that converts json data to a csv file.
json2csv 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
Python 3.x
pip install git+https://github.com/vladikk/JSON2CSV
runtests.sh
See also the list of contributors who participated in this project.
This project is licensed under the Apache License - see the LICENSE.md file for details