'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix SharePoint List Connector Missing in Excel Get Data
Question details
The user is unable to find the SharePoint List connector under the 'Get Data' menu in Excel for Microsoft 365 Business, despite recent updates to the application and subscription.
- Product
- Excel for Microsoft 365 Business
- Device & OS
- not provided
- Scenario
- Attempting to import data from a SharePoint list into an Excel workbook.
- Observed behavior
- The SharePoint List connector option is entirely missing from the Data > Get Data > From Other Sources menu.
Verify that your Microsoft 365 Business subscription is active and that your organization's IT policies have not restricted access to specific data connectors.
Escalate to Microsoft 365 Administrator
Since this missing connector issue often affects multiple users across a tenant, opening an official support ticket is the most effective resolution.
When features like the SharePoint List connector unexpectedly disappear after being available, it is frequently caused by a backend service change or a tenant-wide syncing issue rather than a local software glitch.
Verify if colleagues are also missing the SharePoint List connector under Data > Get Data > From Other Sources to confirm it is a tenant-wide issue.
Collect the affected account email addresses, the exact Excel version numbers in use, and any recent Office update logs.
Ask your managed service provider or internal Microsoft 365 administrator to open a support ticket in the Microsoft 365 admin center.
Try WPS Office for Seamless Spreadsheet Management
If you are experiencing ongoing tenant or backend service issues with Microsoft 365 that prevent you from managing your data effectively, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for viewing and managing complex spreadsheets without unexpected subscription-based feature removals.
- 1. Download and Install: Visit the official WPS website to download and install WPS Office for free.
- 2. Open your files: Launch WPS Spreadsheets and seamlessly open your existing .xlsx or .csv files.
- 3. Manage your data: Use the built-in data tools to filter, sort, and analyze your information without relying on complex backend connectors.
Frequently Asked Questions
Why did the SharePoint List connector suddenly disappear from Excel?
This typically happens due to backend service changes by Microsoft, tenant-wide policy updates, or subscription licensing syncing issues within Microsoft 365 Business.
Does Microsoft 365 Business Premium include the SharePoint List connector?
Yes, the SharePoint List connector is generally included in Business Premium. If it goes missing, it often requires investigation by an administrator through the Microsoft 365 admin center.
Can I still import SharePoint data if the connector is missing?
As a workaround, you can navigate to your SharePoint list in a web browser, select 'Export' from the top menu, and choose 'Export to Excel' to download an .iqy file that Excel can read.
