Excel SharePoint List Missing From Get Data?

A missing SharePoint list connector in Excel can be down to your Office edition. Compare File > Account with a colleague who has the command before repairing Office again.

A rejected sign-in is a separate problem: the connector exists, but its connection fails. Check the account and site address in that case.

Check whether you need to import list rows, import files from a SharePoint folder, or open an Excel workbook stored in SharePoint. Those are separate connections, even when their addresses begin with the same company name.

1. Compare the installed Excel product first

Open Excel for Windows and choose File > Account. Write down the product shown in Product Information, then open About Excel for its version and build. Ask a colleague with the missing command to compare the same details.

Don't compare just the account's email address or the Windows version. Two colleagues can access the same SharePoint site while their computers run different Office products. Site access doesn't add a connector to the installed Excel app.

Diagram separating a missing Excel connector from a SharePoint sign-in error

Microsoft's Excel connector table lists SharePoint Online List for Office 2019 Professional Plus and Microsoft 365 Apps for Enterprise. Its Windows columns don't show that connector for every business or home edition.

Use the table's actual connector row when asking IT about your license. SharePoint List, SharePoint Online List, and SharePoint Folder have separate rows. A checkmark for one isn't a checkmark for all three.

The original report compared Office 365 Business with colleagues' ProPlus installations. Reinstalls and repairs hadn't restored the menu. Check the product difference, though the owner didn't report whether a license change fixed it.

2. Look in the right Get Data category

In a Windows edition that includes it, choose Data > Get Data > From Online Services > From SharePoint Online List. This is the connection for SharePoint Online list items, such as tasks, contacts or inventory rows.

For a company-managed SharePoint Server list, use Data > Get Data > From Other Sources > From SharePoint List. Ask the administrator which SharePoint service hosts your list.

Power Query imports data into Excel and lets you change how it's organized. Other commands in its menu show that Power Query exists, but your edition might lack a particular source. App repairs don't add an excluded connector.

A workbook file inside a document library needs a file connection instead. Confirm whether the thing you're importing has columns and list items or is an .xlsx file. That answer decides which connector to look for.

3. Use the site address when the connector opens

Enter the SharePoint site's root address, such as https://contoso.sharepoint.com/sites/Finance. Don't paste the long list-view address ending in AllItems.aspx or a sharing link copied from an individual item.

Choose the organizational sign-in method and use an account with permission to read the list. The navigator should offer that site's available lists. Choose yours before loading or transforming its rows.

The SharePoint Online connector offers implementations 2.0 and 1.0. With 2.0, All retrieves all columns, while Default follows the list's default view. Missing columns after a successful connection are different from a missing connector.

If the sign-in is rejected, ask the list owner to confirm your read access with that exact account. Changing a worksheet formula or selecting another view won't grant permission to a list you can't access.

From Web isn't an interchangeable repair: it can return a web page rather than list rows, or fail at organizational sign-in. I'd resolve the connector and account mismatch before building a different import.

4. Use list export when you only need its rows

For another way to get the rows, use the list's Export > Export to Excel command. Open the list using your work account, select the view containing the rows you need, and use that command. Open the exported query file in desktop Excel.

Approve a connection prompt only for the list you intended to export. Excel creates a table connected to that view. Use Data > Refresh All to retrieve a fresh copy of the list's data later.

This is a one-way connection. Editing the exported table doesn't update the SharePoint list. Keep changes intended for the shared list in SharePoint, and use the workbook for analysis rather than assuming it is a second list editor.

If the next task is reorganizing the imported table, follow the safe column-moving steps. Moving columns inside Excel is separate from changing which columns the SharePoint query retrieves.

The export starts on a signed-in list page. Your organization controls access, so a public sign-in page won't show the Export command you're trying to use. A list that won't open needs its owner's permission check first.

5. Check the platform before copying Windows instructions

Excel for Microsoft 365 on Mac has its own Data > Get Data experience. The current platform table includes SharePoint List import and refresh. Use the Mac connector list instead of expecting the Windows menu categories to match.

Excel for the web has another set of supported sources and refresh restrictions. Android and iOS don't support Power Query. Opening the same workbook on a phone therefore won't restore a connector missing from Windows.

After data loads, checking for missing numbers can help compare an expected sequence with imported rows. First confirm that the query or exported view includes the records you intended to retrieve.

What to ask IT when the command is still missing

Send the product name, build, platform and the connector you need. Include a screenshot of the Get Data menu and the matching connector-table row. Have IT compare your installed product with its assigned license before reinstalling.

For an access error, send your helpdesk the site address, account and error text. Remove private list contents from screenshots. That gives the helpdesk the details it needs to work on your connection error.

The Short Version

Compare Excel editions before repairing a missing SharePoint command. Use the correct list connector and site-root address when it exists, or export the list to a one-way Excel table when that meets your needs.

Checked November 17, 2026.

Written by Isaac Smith

Isaac Smith is the founder and editor of PC Glance, a website that covers computers, laptops, and technology. He is a tech enthusiast and a computer geek who loves to share his insights and help his readers make smart choices when buying tech gadgets or laptops. He is always curious and updated about the latest tech trends.

More from Isaac Smith

Leave a Comment