Fix SharePoint List Connector Missing in Consumer Excel Microsoft 365
Question details
The user is unable to find the 'From SharePoint Online List' connector in their Microsoft 365 Excel application.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to import or export data using the SharePoint Online List connector while signed into a consumer Microsoft 365 account.
- Observed behavior
- The SharePoint Online List connector is entirely unavailable in the interface, and attempts to add it via third-party add-ins fail because the feature is unsupported on the current tier.
Open Microsoft Excel, click on the 'File' tab, and select 'Account' to verify your current subscription plan under Product Information. Confirm whether you are using a Microsoft 365 Personal or Family plan.
Upgrade to a Business or Enterprise Microsoft 365 Subscription
The SharePoint Online List connector is exclusively available to commercial plans. Upgrading your account is required to unlock this enterprise data connection feature.
Consumer subscriptions like Microsoft 365 Personal and Family do not support enterprise-level data connectors. Third-party add-ins cannot bypass this restriction, as the underlying architecture is not present in consumer builds of Excel.
Visit the official Microsoft 365 website and sign in with the account currently linked to your consumer subscription.
Go to the Microsoft 365 plans and pricing page and select the 'For business' or 'For enterprise' tab to view eligible upgrades.
Choose a subscription that includes advanced Excel features, such as Microsoft 365 Business Standard, Microsoft 365 Business Premium, or Office 365 E3.
After purchasing the upgrade, restart your computer, open Excel, ensure you are signed in with the newly licensed account, and navigate to the 'Data' tab to access the SharePoint Online List connector.

Looking for a high-performance alternative to Microsoft Office?
If upgrading to an expensive enterprise Microsoft 365 plan for advanced features doesn't fit your budget, consider trying WPS Office. It provides a comprehensive, lightweight, and highly compatible productivity suite without the steep commercial licensing costs.
- 1. Download the software: Visit the official WPS Office website to download the free installation package for your operating system.
- 2. Install WPS Office: Run the installer and follow the straightforward on-screen instructions to set up the suite on your computer.
- 3. Open existing Excel files: Launch WPS Spreadsheet and seamlessly open your existing .xlsx workbooks to continue your data management without formatting loss.

Frequently Asked Questions
Can I use a third-party add-in to enable the SharePoint connector on a consumer plan?
No. The ability to connect to a SharePoint Online List requires underlying enterprise data architectures that Microsoft completely excludes from consumer versions of Excel. Add-ins cannot restore or emulate this missing foundation.
Which specific Microsoft 365 plans include the SharePoint Online List connector?
You need a commercial tier plan to access this feature. Eligible plans typically include Microsoft 365 Business Standard, Microsoft 365 Business Premium, Office 365 E3, Office 365 E5, and their enterprise equivalents.
Where should the SharePoint connector appear if I have the correct license?
If you are using a supported enterprise license, you can find the connector by navigating to the 'Data' tab on the Excel ribbon, clicking 'Get Data', selecting 'From Online Services', and then choosing 'From SharePoint Online List'.




