Microsoft Excel's CHOOSECOLS and CHOOSEROWS functions are a game-changer if you want to quickly extract specific columns or rows from your data without nesting several functions in your formula.

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. In the Data section of the ribbon choose Get Data ...