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:

    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