Microsoft Lists not downloading: export fixes

If Microsoft Lists’ Export/Download button does nothing, produces no file, or creates a corrupted file, the cause is usually one of four things: a browser/download client issue, a permission or tenant policy, an export-format incompatibility, or a transient client problem. Try quick local fixes first (refresh, another browser or Incognito, clear cache); if that fails, check list permissions and tenant policies, then use export workarounds such as a filtered view, Power Automate or PowerShell.

My export/download button did nothing or I didn’t get a file — what exactly is happening?

Button click produces no response
Export appears to start but no file in Downloads
Browser blocks popup/download
Downloaded file is empty, truncated, or won’t open
Export/Excel dialog shows an error message (exact message varies)

When it appears

• Immediately after clicking Export/Download or Export to Excel.
• After a short progress indicator but no file arrives.
• After an .iqy file downloads but Excel fails to fetch data.

One quick reproducibility check: try the same list in a different browser or an Incognito/Private window. If it works there, the problem is local to your browser profile, extensions, or cache.

1. Try the list action in a private window now.

Open a Private/Incognito window in your browser and sign into Microsoft 365, then open the list and click Export/Download.

Expected result: the export starts and a file appears in Downloads or you see a clear browser error. If that works, the issue is local to your normal browser profile. If it fails the same way, the problem may be permissions, tenant policy, or the list content itself.

Does this apply to me or is it an admin/tenant policy issue?

Before you start

• Product: Microsoft Lists in SharePoint Online or the Lists app in Microsoft 365. Applies to browser-based exports (Export to Excel / Download a copy / Sync).
• Privileges needed: your normal user account. Admin rights are not required for the initial checks.
• Restart/backup: no restart required; these checks are non-destructive.

Safe checks to decide where the fault lives

1. Ask a coworker to export the same list. If their export works and yours doesn't, the issue is likely your account, device, or browser.
2. Test from a different network (home vs office or mobile hotspot). If it works elsewhere, a network conditional access policy or proxy may be blocking downloads.
3. Try exporting a simple test list or a publicly shared list. If that exports, the original list may have item-level restrictions, IRM, or DLP rules preventing downloads.

What the outcomes mean

• Works in private browser but not normal: browser cache, extension, or download settings.
• Fails for everyone: tenant-level policy (Conditional Access, DLP, IRM) or SharePoint configuration blocking downloads.
• Works for others but not you: account-level Conditional Access or permission scope problems.

Fast fixes you should try now (no admin rights required)

start with the least intrusive steps.

Act here: your device / browser. Privilege: normal user.

1. Sign out and sign in again.

Browser: Sign out of Microsoft 365 account, close tab, open new tab, sign in, open Lists, try Export.

Expected result: temporary token/auth issues cleared. If it still fails, continue.

2. Clear browser cache for SharePoint/Microsoft 365 sites.

Browser -> Settings -> Privacy & security -> Clear browsing data -> Cookies and cached images/files (for microsoft.com / sharepoint.com)

Expected result: removes stale scripts or auth cookies. If export works after this, it was a cached client-side problem.

3. Try a different browser or an Incognito/Private window.

Open Edge/Chrome/Firefox -> sign in to Microsoft 365 -> open the list -> try Export.

Expected result: succeeds in at least one browser if the issue was local.

4. Disable extensions that affect downloads (download managers, ad blockers, security extensions) and retry.

• If that fixes it, re-enable extensions one at a time to find the culprit.

5. Check popup/download settings and temporarily pause antivirus/endpoint scanning to test.

• Ensure the browser allows automatic downloads from the site and does not block pop-ups.

do not leave security disabled; pause only to test.

If none of these work, proceed to permission and tenant checks.

If fast fixes don’t help, check permissions and SharePoint settings

Act here: list owner or admin may be needed. Privilege: list owner or SharePoint admin for some checks.

1. Confirm list/library permissions and inheritance.

List -> Settings -> List settings -> Permissions for this list

Expected result: you see whether the list inherits permissions or has unique permissions. If you lack Read permission, export actions can fail or be blocked. If you lack permissions, ask the owner to grant at least Read access and retry.

2. Check for item-level permissions and view-based restrictions.

• Item-level permissions or views that limit visibility can reduce exported rows or produce an empty file if you have no visible items.

3. Check IRM, DLP and Conditional Access policies.

SharePoint Admin Center -> Policies -> Access control / Information Rights Management / Data loss prevention

Expected result: an admin can confirm whether a policy blocks downloads for the site or content. If a policy blocks downloads, an admin must change the policy or create an exception for your workflow.

What it means if changes don’t help: if an admin loosens a policy and export still fails, return to browser troubleshooting and export-format checks.

Export-specific troubleshooting and alternatives

Act here: user, list owner, or admin depending on the method. Privilege: user for simple workarounds, admin for PowerShell or SharePoint-side fixes.

Export methods and when to use them

• Export to Excel: downloads an .iqy web query file that Excel uses to fetch list data. Requires Excel to allow external data connections.
• Download a copy / Save as: creates a static file (CSV or XLSX). Some column types can break formatting or cause export to fail.
• Sync: uses OneDrive sync and is better for larger sets; requires the OneDrive sync client and permission to sync.

Workarounds when standard export fails

1. Create a view with only simple columns (single-line text, number, date) and a limited item count, then export that view.
2. Use Power Automate to export list items to a CSV file stored in OneDrive or a SharePoint library.
3. Use PnP.PowerShell to export the list to CSV.

Install-Module PnP.PowerShell
Connect-PnPOnline -Url "https://contoso.sharepoint.com/sites/site" -Interactive
Get-PnPListItem -List "ListName" | Export-Csv -Path "C:\temp\ListExport.csv" -NoTypeInformation

Expected result: a CSV with the list items exported. If Connect-PnPOnline fails, you may need admin consent or app permissions.

4. Use the SharePoint REST API to script an export when you can code.

Notes on common export failures

• If you get an .iqy file but Excel never fetches data, your Excel settings or org policies likely block web queries; use a CSV method instead.
• If a downloaded file is corrupted or truncated, test exporting a smaller view to isolate size or a specific column type as the cause.
• Column types that commonly break exports include multi-value lookups, Managed Metadata, complex Person/Group fields, attachments, and calculated fields. Test by exporting without those columns.

How to verify a fix and how to prevent recurrence

Verify the fix

1. Open the downloaded file in Excel (or a text editor for CSV) and confirm row counts and headers match the list view.

Rows: same as list view count
Columns: header names match view and data types look correct
File opens without errors

2. If you used Power Automate or PowerShell, run the same method twice and compare outputs for consistency.

Prevent recurrence

• Document the working method: record browser, whether Incognito was required, account used, and any view or column filters.
• For lists frequently exported, create an export-friendly view with simple column types and a sensible row limit.
• If the cause was tenant policy, ask your admin for a documented workflow or a policy exception for authorized users.

What to do if verification fails: retry with a restricted view (only simple columns) to isolate which column type or size causes the problem.

Conclusion

If a browser switch or clearing cache fixes the problem, use that path and record the exact working browser/account. If the issue requires permission or policy changes, gather test results (screenshots, other-browser/account results) and give them to your SharePoint or security admin. If you need the data now, export via Power Automate or PnP.PowerShell to produce a reliable CSV.

Frequently Asked Questions

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

Export to Excel provides an .iqy web query file which Excel uses to fetch list data from SharePoint. You must open the .iqy in Excel and allow external data connections. If your Excel or tenant policies block web queries, the .iqy will not fetch data; in that case use Power Automate or PowerShell to create a CSV.

Can tenant DLP or conditional access block list downloads silently?

Yes. Conditional Access or DLP policies can prevent downloads or restrict them to managed devices and often produce little client-side feedback. Test with another account or device and involve your admin if the problem appears tenant-wide.

Which column types commonly break exports?

Multi-value lookups, Managed Metadata, complex Person/Group fields, attachments, and calculated fields commonly cause export formatting problems or failures. Create a view with only text/number/date fields to test which column is the issue.