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

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?