Now, opening a JSON file is not hard, however, it would make more sense to convert it to the Microsoft Excel (CSV) format for easier use. The question is, how does one convert a JSON file to Excel?

If you have a JSON file, you need dedicated software to open or view the JSON file. At times, we need to convert a JSON file into different formats, like the xlsx.

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 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.