If you want to view, read and edit JSON files in a readable format, then this post shows how to do it in Windows PC and on the Web.

If you cannot open an Excel file and see Excel cannot open the file because the file format or extension is not valid error, see this post.

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.

Twitter used to provide CSV exports of your data, now it's all in machine-readable JSON. How can you use it in Excel?