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?

It also offers you batch file conversion. You can convert more than one JSON file into Excel format in one go. For this, you have to upload all the JSON files to their server one by one. After ...

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.

That shouldn't be a problem, after all, Excel can handle JSON. So, you try to open the file in Excel using its data import tooling, which usually works very well indeed as a basic ETL system.