You want to look at your json file and see what you are working with. then look at the first and last line of the json file. You want to see how its structured. Then you can run a command with jq on the terminal such as e.g... jq -r '.[] | [.Name, .Password, .UserName, .Mobile, .Namelast, .Phones]|@tsv' example.json > newexample.tsv In this example you are taking certain field types from the json file so they will appear on the tsv file.