johnmurch/json2csv.sh

Last active December 3, 2021 18:06

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/johnmurch/2ad639e72e220be4fa1b38677f7ad21d.js"></script>
Save johnmurch/2ad639e72e220be4fa1b38677f7ad21d to your computer and use it in GitHub Desktop.

Download ZIP

Convert JSON to CSV via CLI

Raw

json2csv.sh

cat sample.json| jq -r '(map(keys) | add | unique) as $cols | map(. as $row | $cols | map($row[.])) as $rows | $cols, $rows[] | @csv'  > sample.csv 

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment