This python script converts valid, preformatted JSON to CSV which can be opened in excel and other similar applications. This script can handle nested json with multiple objects and arrays. Please see ...

If you need to convert that file from CSV to JSON, you can do that with the csvjson command like so: csvjson clients.csv > clients.json. Csvkit has a couple of other handy tricks up its sleeve.