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

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.

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.

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.