Connecting Excel Online to a SharePoint list?


I know how to connect regular Excel to a SP list but is it possible to do it using Excel Online?  In the Data section of Excel Online, I don't see a create connection type setting.


Is this possible?

2 Replies
best response confirmed by Bryan123 (Contributor)


No, you may create Power Query connections only in desktop version.

@Sergei Baklan 


I was afraid so.  Oh well, I'll just manually paste data into a "data" sheet in Excel Web when I need to update it.