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

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

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.