You can convert JSON files to Microsoft Excel CSV file formats using this hidden built-in feature. We show you how to do it.

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

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.

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.