Power Query Problems

Fix the Missing SharePoint Data Import Option in Excel Power Query

Maira MehtabMaira Mehtab Nov 12, 2026 869 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Check the signed-in Microsoft 365 account

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.

2
Install available Excel updates

Go to File > Account > Update Options > Update Now. Restart Excel after the update finishes, then check the Data tab again.

3
Open the SharePoint Online List connector

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.

4
Check other connector locations

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.

Connector availability varies: The exact connector names and locations depend on the Excel edition, operating system, update channel, and Microsoft 365 licensing.
Free Microsoft Office alternative

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. 1. Install WPS Office: Download and open WPS Office, then launch WPS Spreadsheet from the home screen.
  2. 2. Open an Excel workbook: Select Open from the WPS Office home screen and choose an .xlsx or .xls workbook from your device.
  3. 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.
Work with everyday spreadsheet data in a lightweight alternative while Excel connector access is reviewed.Use a familiar spreadsheet interface for editing tables, formulas, and reports.Open and save Microsoft Excel .xlsx and .xls files with broad format compatibility.Also work with Microsoft Word .docx and PowerPoint .pptx files in the same office suite.
microsoft office alternative - wps office

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.