rorymalcolm/convert-json-to-csv.sh Secret

Created May 1, 2023 08:29

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

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

Download ZIP

Raw

convert-json-to-csv.sh

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

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