You can convert JSON files to Microsoft Excel CSV file formats using this hidden built-in feature. We show you how to do it. ... Do this by clicking on Into Table, then hit Close & Load.

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.