Have you ever wondered how to open a JSON file? Probably not. However, for those who do, chances are you’ve tried everything under the sun but still cannot find a way to gain access to the data ...
Click the Convert to table button in the ribbon. This gives you a single column view of the JSON records, which you can now use to choose the elements you want to use in your final spreadsheet.