Fix SharePoint List Export to Excel for External Users
Question details
An external SharePoint user needs to export list data to Excel but cannot complete the export.

- Product
- SharePoint and Microsoft Excel
- Device & OS
- not provided
- Scenario
- A guest user accesses a SharePoint site and tries to export a list to Excel while using multiple organizational accounts on the same device.
- Observed behavior
- The export fails for one external user even though other external users with apparently similar permissions can export the list.
Confirm which guest account the user uses to access the list and whether that account can view the required list items. Note any error message and the point at which the export stops.
Retry the export with the correct account and sign-in option
Use a clean browser session and check the account Excel uses when it connects to SharePoint.
Open a private or incognito browser window, navigate to the SharePoint site, and sign in with the affected external account.
Open the list and select Export > Export to Excel. Open the downloaded file in Excel and follow any prompts to connect to the list.
If Excel asks you to sign in, select the account that has guest access to the SharePoint site. If offered, choose The app only or clear Allow my organization to manage my device before continuing.
Allow the data connection if you trust the SharePoint source, then check whether the list data appears in Excel. If it fails, record the error message for the site or IT administrator.

Check guest access and device-management policies
Use this approach if the export still fails or the sign-in prompt requires device management.
Open exported list data with WPS Spreadsheet
WPS Office is a free, lightweight Office alternative with a familiar interface for working with Excel files. Once the SharePoint data is saved as a workbook, you can open it in WPS Spreadsheet for a straightforward transition. WPS does not resolve SharePoint sign-in or device-policy restrictions.

Frequently Asked Questions
Why can a guest open a SharePoint site but not export its list?
Site access alone does not confirm that Excel can authenticate to the list. The export can also be affected by the account selected in Excel or by organizational access and device-management policies.
Can switching between work accounts interfere with the export?
It can cause Excel or the browser to use an account other than the one with guest access. Try a private browser session and select the guest account when Excel prompts you to sign in.
What should I choose when asked to let my organization manage my device?
If the option is available and permitted by your organization, choose The app only or clear Allow my organization to manage my device. If device enrollment is required, ask your IT administrator for guidance.
Can WPS Office fix a blocked SharePoint export?
No. The SharePoint or Microsoft account access issue must be resolved first. WPS Spreadsheet can open the data after it has been saved as a compatible Excel workbook.




