Data Import & Export

Fix SharePoint List Export to Excel and Access Connection Errors

Elise WilliamsElise Williams Nov 22, 2026 868 views

Question details

The user needs to export a SharePoint list to Excel or connect it to Microsoft Access without an authentication error.

Fix SharePoint List Export to Excel and Access Connection Errors
Product
SharePoint Online, Microsoft Excel, and Microsoft Access
Device & OS
not provided
Scenario
An authenticated Microsoft 365 user tries to export a SharePoint list to Excel or connect it to Access.
Observed behavior
Export to Excel prompts the user to sign in again and then returns an error. The Access connection also fails, although Excel Get Data can connect to the list.
Before you start

Have the SharePoint site URL, the affected list name, and the exact error message ready. Confirm which Microsoft 365 account you use for the site and whether you can open the list in your browser.

Solution 1Recommended

Isolate the SharePoint Authentication Problem

Compare lists, browsers, and networks to identify whether the error is specific to the site, session, or environment.

1
Test another list

Open a different SharePoint list, preferably on another site, and select Export to Excel. Note whether the same sign-in prompt and error appear.

2
Try a clean browser session

Open the list in another browser or a private browsing window, sign in with the account that has access to the list, and select Export to Excel again.

3
Compare networks

With your organization's approval, try the export on another trusted network. Ask your administrator to check whether a VPN, proxy, firewall, or conditional-access policy is affecting authentication; do not disable security controls without approval.

4
Check permissions and policies

Ask the SharePoint administrator to check your list permissions and any site security, sharing, or client-access restrictions that could affect exporting or connecting from Office apps.

Isolate the SharePoint Authentication Problem
Free Microsoft Office alternative

Work With Exported Excel Files in WPS Office

WPS Office is a free, lightweight Office alternative with a familiar interface. Once you have obtained the list as an Excel file, you can open and edit it in WPS Spreadsheets for an easier transition between office suites. WPS does not fix SharePoint authentication or the Access connection.

Open and edit exported SharePoint list data as a spreadsheetCompatible with Microsoft Excel formats, including XLSX and XLSUse a familiar spreadsheet interfaceGet a free, lightweight Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

Why does SharePoint ask me to sign in again when I export a list?

The export may use a different authentication flow from the browser session. Test in a private window and ask your administrator to check conditional-access, proxy, VPN, firewall, and site policies.

Can I get the list into Excel if Export to Excel fails?

If the connector works in your Excel version, select Data > Get Data > From Online Services > From SharePoint Online List, enter the site URL, and sign in with your organizational account.

Does a working Get Data connection mean SharePoint export is fixed?

No. Get Data is a separate way to load the list. The SharePoint export command and the Access connection can still fail and may need an administrator or Microsoft Support to investigate.

What should I send my administrator about the Access and Excel errors?

Provide the exact error text, site and list details, browser and Office versions, failure time, and results from other lists and networks. Mention that Excel Get Data connects successfully, but do not send passwords or tokens.