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…