This window is all about giving you the chance to decide how the JSON data will be loaded onto your spreadsheet. The final thing you will want to do here is to convert the JSON data to a table.

In the Data ... 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.

How to convert ... data to a new system (be it a CMS, CRM, HRM … you name it), only to find out the platform wouldn’t accept the file format I had available. I might have a spreadsheet or JSON ...