Permission & Access Issues

How to Hide the Export Option in a SharePoint Online List

Adam Davis Oct 10, 2026 869 views

Question details

The user needs to remove or hide the Export to Excel/CSV option for specific users in a SharePoint Online list.

How to Hide the Export Option in a SharePoint Online List

Product: SharePoint Online
Device & OS: not provided
Scenario: Restricting data exfiltration by preventing users with read-only access from exporting list data.
Observed behavior: The Export option remains visible to users even after custom permissions are applied because SharePoint permissions are cumulative, and inherited permissions often override the restriction.

Before you start

Ensure you have Site Collection Administrator or Full Control privileges on the SharePoint site to create and assign custom permission levels.

Solution 1Recommended

Disable Client Integration Features via Custom Permissions

Create a new custom permission level based on the default Read permission, but with client integration features disabled, to successfully hide the Export option.

SharePoint permissions are cumulative. If a user is part of multiple groups and even one of them allows client integration, the Export option will remain visible. You must ensure the user relies solely on the new custom permission.

Access Site Permissions

Navigate to your SharePoint site. Click the Settings gear icon, select 'Site permissions', and then click 'Advanced permissions settings'.

Copy the Read Permission Level

Click on 'Permission Levels' in the ribbon. Click on the standard 'Read' permission, scroll to the bottom of the page, and click 'Copy Permission Level'.

Disable Client Integration

Provide a name for your new permission level (e.g., 'Read Without Export'). Scroll down to the 'Site Permissions' section and uncheck the box for 'Use Client Integration Features'. Click 'Create' to save.

Assign the New Permission

Return to the list or site permissions page. Remove the target group's existing 'Read' permissions and assign them the new 'Read Without Export' permission level.

Disable Client Integration Features via Custom Permissions

Check Effective Permissions: Use the 'Check Permissions' button in the ribbon to verify that the target user does not inherit 'Use client integration features' from another group (like Site Members or an AD group).

Solution 2

Restrict Attachment Downloads Separately

Hiding the export option does not automatically block users from downloading list attachments. You must address attachment downloads separately if total data restriction is required.

Free Microsoft Office alternative

A Lightweight Alternative for Managing Exported Data

While SharePoint administrative settings are required to manage access, you don't need expensive software to manage the data you do export. WPS Office is a powerful, free alternative to Microsoft Office that easily handles exported list data, spreadsheets, and documents.

1. Download the Installer: Visit the official WPS Office website and download the free installation package.
2. Install WPS Office: Run the downloaded installer and follow the simple on-screen instructions to set up the software.
3. Open Exported Spreadsheets: Launch WPS Spreadsheet to instantly open, edit, and analyze any CSV or Excel files exported from your SharePoint lists.

Fully compatible with Microsoft Excel (.xlsx) and CSV formats commonly exported from SharePoint.Free, lightweight, and fast-loading office suite.Familiar user interface for a seamless migration with zero learning curve.Built-in PDF editing, document collaboration, and presentation tools.

microsoft office alternative - wps office

Frequently Asked Questions

Why can users still see the Export option after I applied the custom permission?

SharePoint permissions are cumulative. If a user belongs to multiple groups (e.g., Site Visitors and an all-company group), and one of those groups grants a permission level with 'Use client integration features' enabled, the user will still see the Export option. You must use the 'Check Permissions' tool to identify and remove the overlapping access.

Does disabling the Export option also prevent downloading list attachments?

No. Restricting exports and preventing attachment downloads are separate functions in SharePoint. You will need to utilize the Restricted View permission or manage attachment settings independently to block downloads.

Will this custom permission affect all lists on my SharePoint site?

If you assign the custom permission at the site level, it applies to all lists and libraries inheriting permissions from the site. To hide the Export option for a single specific list, you must first break permission inheritance for that list (List Settings > Permissions for this list) and then apply the custom permission there.

Document & File Issues