Export a Notion database to Google Sheets manually via CSV, or set up an automatic sync. Covers relations, rollups, formulas, and Excel.
You can export a Notion database to Google Sheets in two ways: a one-time manual CSV export, or a live sync that updates automatically. This guide covers both, plus a detail most guides skip: what actually happens to your relations, rollups, and formulas when you export.
If you just need a snapshot for today, the manual method below takes about 5 minutes. If you need the Sheet to stay current without repeating that process every day, skip ahead to the automated sync section. Whether you call this export notion to csv or notion export to csv, the file only contains plain text and numbers. For the bigger picture on connecting the two tools, see our complete guide to syncing Notion with Google Sheets.
Notion lets you export any database as a CSV file directly from the page menu. Open the database, click the three-dot menu in the top right corner, select Export, and choose CSV as the format. This works from any database view, though the view's filters and sorts are not always preserved in the file.
This process goes by several names. You might see it called export notion database to csv, notion export database to csv, or export csv notion. Other guides call it notion export csv, download notion table as csv, or notion download table as csv. All of these describe exporting a database's rows into a plain file you can open in Excel or Sheets.
If you only need one table rather than a full database, the same menu lets you export notion table to google sheets. You get there by way of export notion table to csv first.
A Notion export to CSV includes every row in the database, not just the rows visible in a filtered view. Double-check the file before sharing it.
To summarize this notion export database to csv workflow in one sentence: open the database menu, choose Export, pick CSV, and download. Every row exports, but relations, rollups, and formulas do not carry over cleanly, which the next section explains in detail.
Open Google Sheets and create a new spreadsheet. Go to File, then Import, then Upload, and select the CSV file you exported from Notion. Choose Replace spreadsheet or Insert new sheet, then click Import data. Your Notion rows now appear as plain values in Google Sheets.
Yes, this works in reverse too. Open a Notion page, click Import, choose CSV, and select your file. Notion creates a new database and turns each CSV column header into a property automatically.
This reverse process is sometimes called import csv to notion, or just import csv notion. It is useful when you already have data in a spreadsheet and want to bring it into Notion for the first time.
A CSV file only stores plain text and numbers. Notion properties that reference other databases or calculate values on the fly do not survive that format the same way they appear in Notion.
None of this means CSV export is broken. It means CSV export freezes a single moment in time and flattens anything that depended on Notion's live database structure.
The CSV format works the same whether you import it into Excel or Google Sheets, since CSV is a plain-text format that neither tool owns. If you searched for how to export notion database to excel specifically, the process is identical. Export the CSV from Notion, then import it into Excel instead of Google Sheets.
The real difference is what happens after import. Google Sheets supports live formulas that reference other sheets and connects to add-ons. It is also easier to share as a link than emailing an Excel file back and forth.
If your team already works in Google Workspace, Google Sheets is usually the simpler destination. Excel remains a reasonable choice if your reporting already lives in Microsoft 365, since the same CSV file imports cleanly into either program.
A single export works fine for a one-time report. The trouble starts when you need the Sheet to stay current.
Every export is a snapshot, not a connection. The moment someone edits the Notion database, the CSV file you already downloaded stops matching reality.
Instead of exporting a CSV every time your Notion database changes, you can connect Notion and Google Sheets directly so updates happen on their own. Notion Sheets is a one-way sync tool built for exactly this. Connect both accounts, choose a database, and every new row or edit appears in your Google Sheet automatically, typically within seconds. There is no script to maintain and no CSV file to keep track of.
Whether you search for notion google sheets sync, sync notion with google sheets, or link notion to google sheets, these phrases describe the same thing. So do sync google sheets with notion and sync notion database with google sheet. Each one means connecting the two tools so data flows automatically, instead of relying on a manual export.
Notion Sheets is not the only option for this. If you want to compare tools before picking one, see our comparison of 5 tools to sync Notion with Google Sheets.
A live sync earns its setup time once a Notion database needs to be visible to people who are not editing it directly in Notion. A few patterns come up often.
Your spreadsheet ID is the string of characters in the Google Sheets URL between /d/ and /edit.
Connecting Notion and Google Sheets through Notion Sheets takes about 5 minutes for a single database. That covers authorizing both accounts, picking the database, and mapping properties to columns. Once the first sync config is created, adding a second database takes less time since both accounts are already connected. There is no ongoing maintenance beyond checking the mapping if you add a brand new property in Notion later.
A live sync reads the current value of each property every time it updates, not a frozen snapshot. Rollup and formula values in your Google Sheet reflect the latest calculation from Notion. Relation properties map to the linked page's title, so the connection stays readable in Sheets, even though Sheets still cannot open a Notion page directly.
Notion Sheets maps each Notion property to a column individually, instead of flattening everything into plain text the way a CSV export does. This keeps the data usable once it lands in Google Sheets.
Use a manual CSV export for a single, one-time snapshot. That fits a report for a specific meeting, an audit at a point in time, or a backup you plan to store and never update. Use an automatic sync instead when the Sheet needs to reflect Notion's current state, such as a live dashboard or a report stakeholders check often.
If you are also weighing whether to manage this data in Notion or Sheets at all, see our comparison of Notion databases and Google Sheets.
Notion Sheets connects to your Notion workspace and Google account through OAuth, so it never asks for your password directly. It reads only the databases you choose to sync. It writes only to the spreadsheet you connect, without touching any other files in your Google Drive or any other page in your Notion workspace.
CSV export does not preserve relation links, live formula logic, or view filters. Notion Sheets solves the freshness problem, but it is a one-way sync from Notion to Google Sheets. It does not push edits made in Sheets back into Notion, and it does not sync google sheets to notion in the reverse direction. If you need two-way editing, you still need to make changes in Notion directly.
Notion Sheets is also not an official Notion or Google product. It is a third-party tool that connects to both through their public APIs.
Open the Notion database, click the three-dot menu, and select Export, then choose CSV. Save the file, open Google Sheets, and use File, then Import, then Upload to bring the CSV in. This gives you a one-time snapshot. If you need the Sheet to stay current, set up a live sync instead of repeating the export by hand.
Yes. Tools like Notion Sheets connect a Notion database directly to a Google Sheet so new rows and edits appear automatically, without a manual export. You connect both accounts, choose a database, map the fields, and the sync runs in the background whenever your Notion data changes.
No. CSV export converts relation properties into plain page titles with no link back to Notion, and it converts rollup and formula properties into their calculated result at that moment, not the underlying logic. If the source data changes later, the CSV values do not update.
CSV export always strips rich formatting like colors, bold text, and embedded files, since CSV only supports plain text and numbers. To preserve select colors or linked records, you need a sync tool that maps properties individually instead of a flat CSV export.
Notion does not have a native scheduled export feature. To get updates on a recurring basis without exporting by hand, connect Notion and Google Sheets with a sync tool such as Notion Sheets, which updates the Sheet automatically whenever the Notion database changes, rather than on a fixed schedule.
In a notion csv export, file and image properties export as a list of file names or URLs, not the actual attached files. Notion does not download the underlying files, so anyone opening the CSV only sees a reference, not the image or document itself. To view the actual files, you still need to open the record in Notion directly.
Yes. Notion's built-in CSV export is free and takes about 5 minutes: export the database as CSV, then import that file into Google Sheets. This works well for a one-time snapshot. Automated sync tools typically offer a free tier for getting started, with paid plans for larger or more frequent syncs.
With Notion Sheets, updates happen automatically whenever the Notion database changes, rather than on a fixed interval. New rows are detected and appended, and edited properties update in the connected Sheet without you needing to trigger anything manually. Most changes show up within seconds of being made in Notion, so the Sheet stays close to real time.
Notion's CSV export includes every row in the database regardless of the current view's filter, so a filtered view does not export as a filtered file. To sync only specific rows, you need a sync tool that supports filtering during setup, rather than the built-in export.
A one-time export gives you a snapshot of your Notion database at that exact moment, and it will not change again unless you repeat it manually. A continuous sync keeps the Google Sheet updated automatically every time the Notion database changes, so the Sheet never goes stale.
Notion does not publish a hard row limit for CSV exports, but very large databases take noticeably longer to export and produce a larger file that can be slow to open in Excel or Sheets. If you regularly work with large databases, a live sync processes changes incrementally instead of exporting every row in one batch each time.
Yes, though very large databases take longer to process on the first sync than a database with a few dozen rows. After the initial sync, only new rows and changed properties need to update, so ongoing syncs are faster than the first one. Extremely large databases may need the sync to run in batches depending on API limits.
No. Notion Sheets is an independent, third-party tool that connects to Notion and Google Sheets through their public APIs with your permission. It is not built, owned, or endorsed by Notion Labs or Google, and connecting your accounts through OAuth means Notion Sheets never sees or stores your account password.
Connect Notion and Google Sheets in under 5 minutes. No code required.
Get started free