You want to share a Notion database with someone but limit them to only exporting or downloading the data as a CSV file. Notion does not offer a built-in permission setting that restricts a guest or member to CSV-only access directly. This article explains how to use Notion’s sharing features, database views, and external tools to achieve CSV-only sharing while preventing the recipient from editing or viewing the full database inside Notion.
By following the steps below, you will create a locked, read-only database view, generate a share link that hides the original database, and teach the recipient how to export that view to CSV. You will also learn how to revoke access after the export is complete. This method works for both free and paid Notion plans.
Key Takeaways: Share a Notion Database as CSV-Only
- Database view > Lock: Prevents the viewer from editing any property or row in the shared view.
- Share > Invite with “Can view” permission: Grants read-only access without edit or comment rights.
- View > Export to CSV: The recipient downloads the database data as a CSV file from the locked view.
Why Notion Does Not Have a Native CSV-Only Permission
Notion’s permission system is built around roles: Full Access, Can Edit, Can Comment, and Can View. There is no role named “CSV Only” or “Export Only.” When you share a database with someone, they can interact with it inside Notion at the permission level you set. The CSV export feature is available to anyone who can view the database, but it is not a separate permission toggle.
To simulate CSV-only sharing, you must restrict the recipient’s ability to modify or see the full database inside Notion while still giving them access to the export function. This is done by creating a dedicated database view, locking it, and sharing that view with read-only access. The recipient can then export that view to CSV but cannot edit the original data or see other views.
What a Locked Database View Does
A locked view prevents any changes to the database through that specific view. The viewer cannot add, delete, or edit rows. They cannot drag columns, change filters, or modify properties. The lock applies only to that view; the original database remains fully editable for you and other collaborators with edit permissions.
What the Recipient Sees
The recipient sees the database exactly as you configured the view: specific columns, filters, and sorting. They can click the three-dot menu in the top-right corner of the database and select Export to CSV. They cannot switch to another view or access the database in a different context unless you explicitly share additional views.
Steps to Set Up CSV-Only Sharing for a Notion Database
Follow these steps to create a locked, read-only view of your database and share it so the recipient can only export to CSV.
- Open the database and create a new view
Navigate to the page containing your database. Click the + button next to the last view tab at the top of the database. Name the view something like “CSV Export View.” Choose any view type — Table view is the most natural for CSV export. Click Create. - Configure the view properties and filters
Set up the columns you want the recipient to see. Hide any sensitive or irrelevant properties by clicking the property name and selecting Hide. Add filters to limit the rows if needed. Sort the data as you want it to appear in the CSV. This is the exact data that will be exported. - Lock the view
Click the three-dot menu in the top-right corner of the database view. Select Lock. You will see a small lock icon appear next to the view name. This prevents the viewer from making any changes through this view. - Share the view with the recipient
Click the Share button in the top-right corner of the page. Under Invite, enter the email address of the person you want to share with. Set the permission to Can view. Do not grant Can edit or Can comment. Click Invite. The recipient will receive an email with a link to the page. - Test the shared view
Open a private browser window or log in with a different account. Click the share link. You should see the locked view. Try to edit a cell — you cannot. Click the three-dot menu and verify that Export to CSV is available. - Instruct the recipient to export to CSV
Tell the recipient to open the shared page, click the three-dot menu in the database view, select Export to CSV, and save the file. The CSV will contain all visible columns and rows from that view. - Revoke access after export (optional)
After the recipient confirms the CSV download, go to Share > Invited people. Click the three-dot menu next to their name and select Remove access. This prevents further access to the database.
Common Issues When Sharing a Notion Database for CSV-Only Access
The recipient sees the full database instead of the locked view
This happens when you share the entire page instead of the specific view. Make sure you are on the correct view tab before clicking Share. If the recipient has access to the parent page, they may navigate away from the locked view. To prevent this, create a new page that contains only the locked database view and share that page instead.
The Export to CSV option is grayed out
The Export to CSV option is grayed out when the database is embedded in a page that does not allow export. This can occur if the page is shared as a public link with the “Allow duplicate as template” option disabled. To fix this, ensure that the share link is an invite link, not a public link. For invited guests, the export option is always available.
The recipient can still edit the database through another view
If the recipient is a member of your workspace with edit permissions, they can access the database through other views or the full page. CSV-only sharing only works for guests or members who have been restricted to Can view on the specific page. For workspace members, you must also change their workspace-level permissions or move the database to a page they cannot access.
| Item | Guest with Can View | Workspace Member with Can View |
|---|---|---|
| Access to other views | Only the shared view | All views on the page |
| Can edit data | No | No |
| Can export to CSV | Yes | Yes |
| Can see other pages | Only the shared page | All pages they have access to |
To ensure CSV-only access, use a guest account for the recipient. Workspace members always have broader access unless you restrict them with page-level permissions.
If You Need to Share a Database to CSV Without Any Notion Access
If you want to give someone CSV data without giving them any Notion access at all, you can export the database yourself and send the CSV file directly. Open the database, click the three-dot menu, select Export to CSV, and download the file. Then share the CSV via email or cloud storage. This method bypasses Notion sharing entirely and is the most secure option when the recipient does not need ongoing access.
For recurring CSV exports, consider using Notion’s API. You can write a script that queries the database and outputs a CSV file on a schedule. This requires technical setup but automates the process without manual sharing.
You now know how to share a Notion database so the recipient can only export it to CSV. Create a locked view, invite the person with Can view permission, and instruct them to use Export to CSV. For maximum security, revoke access after the export or export the CSV yourself and send the file directly. If you need to automate CSV exports, explore the Notion API for scheduled data pulls.