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

But things have changed at Twitter, and if you request a download of your data it comes as a set of JSON files. That shouldn't be a problem, after all, Excel can handle JSON. So, you try to open ...

You don’t want to have to SCP the file to your desktop, load the file, save it in the requisite format, and then SCP the file back to the server. You want to be efficient. Hence, csvkit.