Connect to a SharePoint List

[This documentation is for preview only, and is subject to change in later releases.]

  1. In the DATA EXPLORER ribbon tab, click From Other Source > From SharePoint List.
  2. In the Microsoft SharePoint Lists dialog box, enter the URL for a SharePoint site.
  3. Click OK.
  4. 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