# How to Connect a SharePoint List to Excel

> 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.

Canonical: https://livedemo.ai/tutorials/how-to-connect-a-sharepoint-list-to-excel/
Apps: Excel, SharePoint
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3325ab56e05a00fd71e6/preview?step=1

## Steps

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.