Connect to a SharePoint List (Power Query)

Use Excel's Get & Transform (Power Query) experience to connect to a Sharepoint List.

Click on the Data tab, then Get Data > From Other Sources > From Sharepoint List. If you don't see the Get Data button, then click New Query > From Other Sources > From Sharepoint List.

In the Power Query ribbon tab, select From Other Sources > From SharePoint List.

Power Query get data from Other Sources dialog

Next

  1. In the Microsoft SharePoint Lists dialog box that appears, enter the URL for a SharePoint site.

    Note:  When connecting to a SharePoint list, enter the site URL instead of the list URL. In the Access SharePoint dialog box, select the most general URL to authenticate against the site correctly. By default, the most general URL is selected.

  2. Select OK to continue.

  3. In the Access SharePoint dialog box that appears next, select a credentials option:

    1. Select Anonymous if the SharePoint Server does not require any credentials.

    2. Select Windows if the SharePoint Server requires your Windows credentials.

    3. Select Organizational account if the SharePoint Server requires organizational account credentials.

  4. Select Connect.

    Excel Power Query connect to a Sharepoint List Connect dialog

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Power Query is known as Get & Transform in Excel 2016

Import data from external data sources

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×