Excel Online - Consuming SharePoint Lists


Here is how to Consume a list in SharePoint Online via Excel Online:

Open Excel > Data tab > From Other Sources  > From Odata Feed


Important: You need to enter the location and call the List Data Service (you need to add _vti_bin/listdata.svc to the end):

Example: https://microsoft.sharepoint.com/teams/officetechnologies/_vti_bin/listdata.svc

Click Next


Select Tables.  In this example, we chose TestList

 

Modify the File Name: & Friendly Name: click Finish

 

Choose the radio button next to PivotTable Report > OK

 

Build the PivotTable and Save it to SharePoint Online.

When you open it, you will see the PivotTable

Now add to the SharePoint List

Go back to the Excel Online and choose Data > Refresh All Connections

Click Yes

 

You will now see the updated values in Excel Online!

Comments (2)

  1. Anonymous says:

    Update:
    You can consume a SharePoint Online list in Excel Online:
    Excel Online - Consuming SharePoint

  2. Gejza Horvath says:

    Great post,
    I was looking for exactly this. Thank you.

Skip to main content