Connect to a SharePoint List

  1. In the POWER QUERY ribbon tab, click From Other Source > From SharePoint List.
  2. In the Microsoft SharePoint Lists dialog box, 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.

  1. Click OK.
  2. In the Access SharePoint dialog box, click a credentials option:
  1. Click Anonymous if the SharePoint Server does not require any credentials.
  2. Click Windows if the SharePoint Server requires your Windows credentials.
  3. Click Microsoft Online Service ID if the SharePoint Server requires federated access credentials. For Windows Live ID, log into your account.
  1. Click Save.
 
 
Applies to:
Excel 2013, Excel 2010