jq

Installation

Linux

Update system with apt

sudo apt install jq -y
sudo apt upgrade jq -y

Windows

Usage

# Convert JSON to CSV
jq -r '(.[0] | to_entries | map(select(.value | type != "object")) | map(.key)), (map(to_entries | map(select(.value | type != "object")) | map(.value))[]) | @csv' data.json > data.csv

Version

Appendix

• jq
• GitHub - jqlang/jq
• StackOverflow - JSON arry to CSV