Microsoft Lists cannot download — fix export failures

If Microsoft Lists won’t download, the cause is usually a local browser/security problem, a SharePoint permission or policy, or list-level data/format limits. Try quick local fixes first (different browser, private window, disable extensions); if those fail, capture the exact error and check permissions, IRM/Conditional Access, or complex columns as described below.

What exactly happens when the download fails and what to capture first

No file saves or the browser shows a spinning cursor.
Export to Excel returns a blank or corrupt .iqy or .odc file.
Excel or SharePoint dialog shows an error like "Failed to download" or "Access denied".
The browser downloads a file but it’s 0 bytes.

When it appears

• Note whether the problem happens for a single list, several lists, or all site collections.
• Reproduce the failure once while you keep developer tools or the Excel dialog open so you can copy errors.

Where to copy errors

• Browser console: open developer tools (usually F12), go to Console, reproduce the action, then copy the last error lines. Those often show network failures, 403/401, or blocked resources.
• Network tab: in developer tools, reproduce and look for failed HTTP calls (status codes, response text). Copy the Request URL and response body.
• Excel/SharePoint dialogs: if Export to Excel or the sync dialog shows a message, highlight and copy it or take a screenshot.
• Attachment downloads: if item attachment fails, note whether the URL attempts to open SharePoint download or a direct file server URL.

Why this matters

• The exact message distinguishes local issues (browser blocked content) from server-side policies (403, IRM or Conditional Access). If you plan to ask IT, include the copied console lines or a screenshot of the dialog.

Does this apply to your situation — which download method and account are involved

Product and scope

• Applies to Microsoft Lists and SharePoint lists/libraries in Microsoft 365. The exact UI names used: "Export to Excel", "Sync (OneDrive)", item attachments, and "Save list as template".

Privileges and safe first checks

• Privileges: member-level actions need no admin rights. Changing permissions, IRM, Conditional Access or tenant policies requires a SharePoint or Azure AD admin.
• Safe first checks: try a different browser and a private window; don’t change permissions or tenant settings yet.

Which download methods to identify

• Export to Excel button on the list command bar.
• Sync (OneDrive) for a library or list attachments.
• Download attachments from item menus or forms.
• Save list as template (with or without content).

Account/role mapping

• List member: run client-side troubleshooting, capture errors, and request permission changes if needed.
• List owner: can change list/library permissions, views and templates.
• Tenant or SharePoint admin: can change Conditional Access, IRM, DLP and view audit or sign-in logs.

How this helps

• Export to Excel often fails because of column types or view complexity. Attachment downloads commonly fail for permissions or blocked file types. Identify the failed UI action before proceeding with fixes.

Quick local fixes to try first (safe, fast, often resolve it)

Try these in order — each is reversible and quick.

1. Try a different browser and a private/incognito window.

• Where to act: your browser.
• Privilege: user.
• Expected result: If a browser extension or cached data caused the issue, the export/download should work in a different or private window.
• If it works in another browser, the problem is local to your original browser.

2. Clear the browser cache and sign out/in.

• Where to act: browser settings.
• Privilege: user.

Browser settings > Privacy & security > Clear browsing data (cached images and files)

• Expected result: Fixed stale tokens or corrupted cached files. If it still fails, continue.

3. Disable browser extensions or test with extensions off.

• Where to act: browser extensions/add-ons menu.
• Privilege: user.
• Expected result: Extensions that block popups, scripts, or cross-site requests can stop downloads. If it works with extensions off, re-enable them one-by-one to find the culprit.

4. Temporarily disable antivirus or web-scanning that intercepts downloads.

Temporarily disable only if you understand the risks and re-enable immediately after testing.

• Where to act: local security software settings.
• Privilege: user (may require admin on the device).
• Expected result: Some security software rewrites downloads or blocks Office connectors; disabling should reveal that cause.
• If disabling doesn’t help, re-enable your antivirus and continue troubleshooting.

5. Try the classic list experience for Export to Excel.

• Where to act: list settings or URL.
• Privilege: user.
• Steps:

1. On the list, open Settings (gear) > List settings and at the bottom switch to Classic experience, or add ?env=WebView to the list URL to open classic mode.

• Expected result: Classic Export to Excel uses an .iqy file approach that sometimes works when the modern command fails. If classic works but modern doesn’t, the problem is in the modern client path or a tenant policy affecting modern endpoints.

If none of these fixes help, capture the browser console and network errors as described earlier and proceed to the permission and policy checks.

Permission and SharePoint settings that commonly block downloads

Where to check and what to ask an admin to verify.

List and library permissions

• Where to act: List settings or Library settings.
• Privilege: list owner or site collection admin.

List settings > Permissions for this list

• Look for: Limited access, unique permissions, or a custom permission level that lacks "Open" or "View Items". If attachments or files inherit stricter permissions, request appropriate read permissions.

Information Rights Management (IRM)

• Where to act: Library settings > Information Rights Management.
• Privilege: site collection admin or tenant admin.

Library settings > Information Rights Management

• Effect: IRM can prevent downloading or saving copies. If IRM is enabled, an admin must change IRM settings or provide an exception.

Conditional Access and device policies

• Where to act: Azure AD Conditional Access (tenant admin).
• Privilege: tenant admin.
• Effect: Policies can block downloads for unmanaged devices, non-compliant clients, or require MFA for certain actions. Ask your admin to confirm if a Conditional Access policy applied to SharePoint/OneDrive blocks downloads for your user or device.

Guest and external user restrictions

• Where to act: Site collection settings and Azure AD guest policies.
• Privilege: tenant or site admin.
• Effect: Guests often have restricted download rights; a tenant admin can allow specific actions or add the external user to a group with expanded rights.

Blocked file types and content filtering

• Where to act: Tenant DLP and blocked file type settings (tenant admin).
• Privilege: tenant admin.
• Effect: Files with blocked extensions or sensitive content detected by DLP will be prevented from downloading. Admins can review DLP logs and create a temporary exception for export.

What to provide to IT

• Provide the copied browser console/network error, the list URL, the time of the attempt, and your account name so admins can correlate logs with the failure.

Data and format limits that break exports and reliable workarounds

Export to Excel and other methods can fail because of list size, view thresholds, or column types. Identify and work around them.

Common blockers

• Large lists and the List View Threshold (filtered view required).
• Complex columns: Lookups, Managed Metadata, Person fields, multi-line with rich text, or JSON column formatting.
• Conditional or JSON formatting on the view that modifies cell rendering.

Workarounds and step-by-step alternatives

1. Filter or create a simple view and export in batches.

• Where to act: list view settings.
• Privilege: list owner or member with view/edit rights.
• Steps:

1. Create a view with only the columns you need and a filter that limits rows to under the threshold.
2. Use Export to Excel on that view.

• Expected result: Smaller, simpler exports succeed. If it still fails, reduce columns or rows further.

2. Use Sync with OneDrive for libraries or list attachments.

• Where to act: library command bar > Sync.
• Privilege: user.
• Steps:

1. On the library, click Sync and follow OneDrive sign-in.
2. Use Windows Explorer or Finder to copy files locally.

• Expected result: Attachments and files sync to your device and can be copied without the Export to Excel path.

3. Save list as template (if allowed) and include content.

• Where to act: List settings.
• Privilege: list owner or site admin.

List settings > Save list as template

• Expected result: A template .stp can be downloaded; note that large lists or certain column types may prevent including content. If the template creation fails, use a different export method.

4. Use Power Automate to export items to CSV or to a SharePoint document library.

• Where to act: Power Automate (flow designer).
• Privilege: user (depends on connectors used) or admin for tenant flows.
• Steps:

1. Create a flow: trigger Manual > Get items from the list > Create CSV table > Create file in OneDrive/SharePoint.

• Expected result: You get a CSV file you can download; works around Export to Excel limits and lets you split by pages.

5. Use SharePoint REST API or PowerShell for admins to pull list data in pages.

• Where to act: admin workstation or automation runbook.
• Privilege: tenant admin or script account with list access.
• Expected result: Admins can script paged retrieval and export complex columns after converting them.

Handling specific column types

• Lookups and Managed Metadata: Export the underlying ID or text value by creating a calculated field or using a simple view.
• Multi-line rich text: Export to CSV strips formatting; if you need rich text, use a flow to save the item body to individual HTML files.
• If JSON formatting on columns is present, create a plain view without formatting for the export. JSON only affects presentation but can break client-side export attempts.

How to verify the fix and prevent this from happening again

Verify the fix

• Steps:

1. Attempt the same export/download action you used initially.

Downloaded file opens in Excel and shows the expected rows and columns.
Attachment files open locally from Explorer or Finder with correct sizes and types.

• If you used a batch or filtered export, open multiple batches and compare counts to the list item count.
• Check attachments: open a few random attachments to confirm they aren’t corrupt.

Prevent this from recurring

• Create a plain "Export" view: keep a view with only exportable columns (no JSON formatting, no managed metadata where possible).
• Document standard export steps for users: preferred browsers, using private windows for troubleshooting, and how to capture error messages.
• For admins: monitor Azure AD sign-in logs and SharePoint ULS or audit logs around the time of failure. Watch for Conditional Access blocks or DLP matches.
• Use Power Automate flows or scheduled exports for very large lists so users don’t rely on Export to Excel for heavy datasets.

If the problem recurs, gather the captured console/network logs and the exact error text and provide them to your SharePoint or tenant admin for deeper investigation.

Conclusion

If a quick browser or cache fix doesn’t restore downloads, capture the exact error and contact your SharePoint or tenant admin to check permissions, IRM, Conditional Access, or DLP. While they investigate, use a filtered export, Power Automate, OneDrive sync, or an admin-run PowerShell/REST export to get the data out safely.

Frequently Asked Questions

Why does Export to Excel give me an .iqy file instead of a .xlsx?

Export to Excel provides an .iqy web query file that Excel uses to pull data from SharePoint. If Excel won’t fetch data from that .iqy, the issue is usually authentication, blocked network requests, or complex column types. Try opening the .iqy in Excel while signed into the same account in the browser, or use a simple view to reduce complexity.

Can Information Rights Management (IRM) stop attachments from downloading?

Yes. IRM can prevent users from downloading, saving, or printing protected files. If IRM is enabled on the library, an admin must change the IRM policy or create an exception for the export.

Is there a size limit for Export to Excel?

Export to Excel can fail with very large lists or views that exceed SharePoint thresholds. Rather than a single fixed number, use filtered views, batch exports, or a Power Automate flow to export data in pages.