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.

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 ...