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.

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.

And that’s how we can manipulate XLS, JSON, and CSV files with csvkit. This tool might not be used very often, but when you need it, you’ll be happy it’s around.