Get data from online services in excel is missing, and how admin of ogranizations can enable it?

Question

I want to get data from sharepoint list online and the get data - online services is missing. I have MS365 buisness License so should be there. What admin of organization can do to enable it?

Answer 1

Hello, 

I appreciate you contacting Microsoft Community! 

Based on the images you provided, you need to upgrade your license to see that option. Microsoft 365 Business Standard or Apps for Business typically do not include this connector in the Excel interface. 

To enable "Get Data from SharePoint Folder" in Excel, you can ask your admin to assign a license such as: 

• Microsoft 365 Apps for Enterprise
• Office 365 E3 or E5

Hope this helps! Please reach out to us again if you have any further questions or concerns. 

Best Regards,

Alina-Le - MSFT | Microsoft Community Support Specialist

Answer 2

Have a nice day,

It has been a while and I am writing to see how things are going with this issue. Have you had a chance to check the reply I provided?

If you think my information is helpful to you, it will mean a lot if you could mark it as the answer and vote up. The answer will be highlighted so that everyone in the community can quickly find the information they need.

If you’ve already resolved the issue, would you mind sharing the steps you took? You can provide your troubleshooting steps in the answer of this thread. Your contribution could be really helpful to others in the community who might face a similar issue in the future.

Any update would be appreciated.

Warm Regards,   

Alina-Le - MSFT | Microsoft Community Support Specialist