The task of converting JSON to an Excel CSV file won’t take a long time. We suspect it can take less than a minute if you move fast enough and have the relevant knowledge.

JSON to Excel Converter CONVERSION TOOLS is a free online tool that lets you convert a JSON file into Microsoft Excel format. It has both free and paid plans for users.

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.

Simon Bisson. Excel's JSON import tools can now load the data, but you're going to have to construct a data transformation to get at the information you want.