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.

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

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

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.