Data Import & Export

Fix SharePoint List Connector Missing in Consumer Excel Microsoft 365

Rana GarciaRana Garcia Oct 1, 2026 870 views

Question details

The user is unable to find the 'From SharePoint Online List' connector in their Microsoft 365 Excel application.

How to Fix the Missing SharePoint List Connector in Consumer Excel Microsoft 365
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.
Before you start

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.

Solution 1Recommended

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.

1
Log into your Microsoft Account

Visit the official Microsoft 365 website and sign in with the account currently linked to your consumer subscription.

2
Navigate to commercial plans

Go to the Microsoft 365 plans and pricing page and select the 'For business' or 'For enterprise' tab to view eligible upgrades.

3
Select a qualifying plan

Choose a subscription that includes advanced Excel features, such as Microsoft 365 Business Standard, Microsoft 365 Business Premium, or Office 365 E3.

4
Complete the upgrade and refresh Excel

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.

Upgrade to a Business or Enterprise Microsoft 365 Subscription
Work or school accounts: If you already have a work or school account provided by your organization, try signing out of your personal account in Excel and signing in with the organizational account, as it may already have the required licenses.
Free Microsoft Office alternative

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. 1. Download the software: Visit the official WPS Office website to download the free installation package for your operating system.
  2. 2. Install WPS Office: Run the installer and follow the straightforward on-screen instructions to set up the suite on your computer.
  3. 3. Open existing Excel files: Launch WPS Spreadsheet and seamlessly open your existing .xlsx workbooks to continue your data management without formatting loss.
Highly compatible with Microsoft Excel (.xlsx), Word, and PowerPoint formats.Cost-effective alternative that doesn't lock essential tools behind expensive enterprise tiers.Familiar user interface requiring zero learning curve for seamless migration.Lightweight design ensuring fast installation and smooth performance on any device.
microsoft office alternative - wps office

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'.