To convert a json file to CSV you will need a linux program called jq.
INPUTFILE="inputfile-with-json"
OUTPUTFILE="outputfile-formatted.csv"
jq -r '(.[0] | keys_unsorted) as $keys | $keys, map([.[ $keys[] ]])[] | @csv' ${INPUTFILE} > ${OUTPUTFILE}
To convert a json file to CSV you will need a linux program called jq.
INPUTFILE="inputfile-with-json"
OUTPUTFILE="outputfile-formatted.csv"
jq -r '(.[0] | keys_unsorted) as $keys | $keys, map([.[ $keys[] ]])[] | @csv' ${INPUTFILE} > ${OUTPUTFILE}