How to Connect a SharePoint List to Excel
- George Apostolov
This guide is an interactive LiveDemo. Create interactive demos of your own product: Interactive demo software · Interactive customer onboarding guides · Start free
How to Connect a SharePoint List to Excel: step-by-step guide
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.
Quick answer: To connect a SharePoint list to Excel, go to the Data tab in Microsoft Excel, select Get Data (Power Query), choose SharePoint Online List, enter the site URL, and sign in to your Microsoft account to establish the connection.
About this Excel tutorial
Integrate your SharePoint lists directly into Excel by using Power Query, entering your site URL, and signing in to enable the connection. This guide shows how to connect a SharePoint List to Excel in 4 steps, starting with "Inside your Microsoft Excel worksheet, head over to the top menu bar and click 'Data'" and finishing with "Finally, provide the site URL of the SharePoint list you wish to integrate. Once done,...". The interactive demo above is a click-through copy of the real Excel interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to connect a SharePoint List to Excel?
4 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Excel data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Excel and SharePoint. Related guides: How to Connect Microsoft Forms Responses to Excel Online, How to Connect Microsoft Forms to Excel Using Power Automate and How to Connect Power BI to a SharePoint Excel File. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
