You can achieve this by creating a
Custom Permission Level. By default, SharePoint doesn't offer "View-level" permissions (if a user can see the list, they can technically switch views), but you can restrict their ability to manage views or edit content by following these steps.
Step 1: Create a "Download Only" Permission Level
You need to create a role that allows users to see items and download them, but strips away the ability to edit or create their own views.
- Navigate to your SharePoint site and click the Gear icon (Settings) > Site permissions.
- Click Advanced permission settings at the bottom.
- In the top ribbon, click Permission Levels.
- Click on the existing Read permission level, scroll to the bottom, and click Copy Permission Level.
- Name it: e.g., "Download Only - No View Switching."
- Uncheck these specific boxes under Personal Permissions:
- Manage Personal Views: This prevents users from creating their own views to see hidden data.
- Ensure these remain checked under List Permissions:
- View Items and Open Items (Required for downloading).
- Click Create.
Step 2: Assign the Custom Permission to the List
Now, apply this restricted role specifically to your SharePoint list.
- Open your SharePoint list.
- Click the Gear icon > List settings > Permissions for this list.
- Click Stop Inheriting Permissions in the ribbon (this allows the list to have different rules than the rest of the site).
- Select the users or groups you want to restrict, click Edit User Permissions, and check your new "Download Only - No View Switching" level while unchecking everything else (like "Contribute" or "Edit").
Step 3: "Hide" the Admin View from Public Users
While SharePoint doesn't natively "lock" views per user, you can make the Public View the only easy option for them:
- Set the Default View: In List Settings, scroll down to Views and set the "Public View" as the Default.
- Remove from Menu (Optional): If you use a List Web Part on a SharePoint Page instead of sending users directly to the list URL, you can disable the "Show view selector" option in the Web Part settings. This makes it much harder for standard users to find the Admin view.