Forum Discussion
How to query data from SharePoint Online list in Excel
I am trying to import data into Excel from a list on SharePoint Online. I am able to connect to the list using the standard data connections feature in Excel, which allows connection to various web s...
Have you tried to follow this support article where Power Query is advised? https://support.office.com/en-us/article/Import-data-from-external-data-sources-Power-Query-be4330b3-5356-486c-a168-b68e9e616f5a