Connect to a SharePoint List (Power Query)

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

2016 2010-2013



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.

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.

   

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