How to Connect a SharePoint List to Excel
It is very easy to connect a SharePoint list to Excel. Here’s a quick guide on how to do it in simple steps:
- Inside your Microsoft Excel worksheet, head over to the top menu bar and click 'Data'.
- Subsequently, tap 'Get Data (Power Query)'.
- Choose 'SharePoint Online List' from the available options.
- 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.
This website uses cookies to ensure you get the best experience on our website. Learn More
Got it