#get csv2json script here: # https://pastebin.com/qZc1V5Nm wget -qO- "https://randomuser.me/api/?nat=us&results=100&format=csv" > users.csv csv2json -i users.csv -o users.json -f pretty cut -d\, -f1,2,3,7 users.csv jq -r '.[]|(.phone+","+.email+","+."dob.age")' users.json jq -r '.[]|(.phone+"|"+.email+"|"+."dob.age")' users.json jq -r '.[]|(."name.first"+","+."name.last"+","+."dob.age"+","+.phone)' users.json jq -r '.[]|"\(."name.first"),\(."name.last"),\(."dob.age"), \(.phone)"' users.json