With Python scripts, you can even create new Excel workbooks, add or delete worksheets, merge data from different files, and ...

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.