In the Data section of the ribbon choose Get Data and in the drop down pick From File and then from JSON. The JSON will load ... query that can bring the data you want into Excel.