Excel's JSON import tools can now load the data, but you're going to have to ... and there's a new icon in the table column header. Click this to get a list of the columns you can expand the ...

You should now click on the Import button at the bottom, and right away Excel will launch a Power Query Editor window. This window is all about giving you the chance to decide how the JSON data ...