Guide

1. Inside your Microsoft Excel worksheet, head over to the top menu bar and click 'Data'.

2. Subsequently, tap 'Get Data (Power Query)'.

3. Choose 'SharePoint Online List' from the available options.

4. Finally, provide the site URL of the SharePoint list you wish to integrate. Once done, tap 'Sign In' to log into your Microsoft account and enable the connection.