Fix the Missing SharePoint Data Import Option in Excel Power Query
Question details
The user needs to restore or locate the SharePoint data source option in Excel Power Query.
- Product
- Microsoft Excel Power Query
- Device & OS
- not provided
- Scenario
- The user is trying to import SharePoint data, but the expected SharePoint connector is unavailable even though the Microsoft 365 license appears to support Power Query.
- Observed behavior
- The SharePoint data import option or connector is missing from Excel Power Query.
Confirm the exact SharePoint site or list URL and note the Microsoft 365 account currently signed in to Excel. Also check whether the organization manages Excel updates or connected experiences through an administrator.
Verify the Excel account, version, updates, and SharePoint connector
Use this solution when the connector may be hidden because Excel is signed in with the wrong account, is outdated, or the wrong import command is being used.
Power Query connectors can vary by Excel version, update channel, license, and platform. The SharePoint Online List connector is different from importing a page through From Web, so selecting the correct command is important.
In Excel, open File > Account and verify that the signed-in account is the Microsoft 365 account licensed for your organization. If necessary, select Sign out, restart Excel, and sign in again with the correct account.
Go to File > Account > Update Options > Update Now. Restart Excel after the update finishes, then check the Data tab again.
Select Data > Get Data > From Online Services > From SharePoint Online List. Enter the SharePoint site URL when prompted; use the site URL rather than a specific list-view URL unless Excel requests the list address.
If the command is not shown in the Online Services menu, select Data > Get Data > From Other Sources and review the available connectors. Do not use Data > From Web unless you specifically need to retrieve web content rather than connect to a SharePoint list.
Ask the Microsoft 365 administrator to review Power Query access
Use this solution when the connector remains unavailable after Excel is updated and the correct account and import path have been confirmed.
Use WPS Office as a Lightweight Alternative for Everyday Spreadsheet Work
WPS Office does not restore a missing Microsoft Excel Power Query connector or change Microsoft 365 administrator policies. However, it provides a free, lightweight spreadsheet alternative with a familiar interface and strong compatibility for opening, editing, and sharing common Office files while you resolve the Excel issue.
- 1. Install WPS Office: Download and open WPS Office, then launch WPS Spreadsheet from the home screen.
- 2. Open an Excel workbook: Select Open from the WPS Office home screen and choose an .xlsx or .xls workbook from your device.
- 3. Edit and save the spreadsheet: Use the spreadsheet tools to update data, formulas, and formatting, then select Menu > Save As to keep the workbook in Excel format when needed.

Frequently Asked Questions
Why is the SharePoint connector missing from Excel Power Query?
Common causes include an unsupported Excel edition, an outdated build, the wrong Microsoft 365 account, a restricted update channel, disabled connected experiences, or an organizational policy that blocks online data connections.
Which Excel menu should I use to connect to a SharePoint list?
In Excel, select Data > Get Data > From Online Services > From SharePoint Online List. This connector is different from Data > From Web, which is intended for general web content.
Should I enter the full SharePoint list URL or the site URL?
Start with the SharePoint site URL when using From SharePoint Online List. A list-view or item URL may not be accepted, depending on the Excel version and connector.
What should I do if the connector is still unavailable after updating Excel?
Verify the account under File > Account, then ask your Microsoft 365 administrator to check the license, connected experiences, Power Query access, SharePoint permissions, and organization policies.




