How to Convert Access Reports to Excel Tables. One of the prime attractions of Microsoft Office Suite is the ability to transfer and convert data for use in each of the different programs that ...

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.

After converting the data sets to Table objects, you can create the relationships. To do so, click anywhere inside a Table and then click the Power Pivot tab to open the Power Pivot window.

Because the data is in a range that isn't formatted as an Excel table, you need to fill the rest of the column manually. To do this, click and drag the fill handle in the bottom-right corner of ...