Learning how to export Notion database to CSV takes about two minutes, and every guide on the internet says the same thing: click the three dots, choose Export, and pick Markdown and CSV. That answer is correct, and it is not enough. The real questions start after the file downloads: why do the relations show up as long codes, why are some columns missing, why does the file look messy in Excel, and how do you export everything at once. This guide covers the short answer first, then everything around it: what the CSV actually contains, how to clean it in Excel and Google Sheets, whole-workspace export, and the live-sync alternative for data that keeps changing.
A Notion database is a table, board, or list of pages with properties such as dates, tags, and relations to other databases. Exporting it to CSV turns it into a plain spreadsheet file you can open anywhere. The export is a one-time snapshot, not a live connection. If the database changes tomorrow, the CSV does not change with it, and that distinction drives most of the decisions in this guide.
How to Export a Notion Database to CSV
Follow these steps for a standard database export:
- Open the database in Notion, in full-page view or as an inline database on a page.
- Click the three dots in the top right of the database, or the three dots next to its title.
- Choose Export.
- Select Markdown and CSV as the export format.
- Make sure the option to include subpages is set the way you want it, then click Export.
- Notion downloads a zip file. Open it to find a CSV file for the database, plus a folder of any attached files.
That is the whole process for one view of one database. Two limits matter immediately. First, the export covers one view at a time, so if your database has five views, you export the one you have open, not all five. Second, Form views cannot be exported, so switch to a table view before exporting if you need the data.
What the CSV Actually Contains
A CSV file is plain text with commas between values, so Notion has to flatten its rich properties into that simple format. Knowing how it flattens them prevents most surprises.
- Formulas become values: a formula column exports as the result it showed, not as the formula itself. If the formula changes later, the CSV stays as it was.
- Relations become IDs: a relation to another database exports as a long UUID, a string of letters and numbers, not as the page title you see in Notion. The titles are not in the CSV, so you will need to look them up or replace them by hand.
- Rollups become values too: a rollup that counts or sums related pages exports as the number or text it displayed.
- Hidden columns are excluded: if a property is hidden in the current view, it does not appear in the export. Check the view before exporting, or the file will be missing columns you expected.
- Files and images become links or separate files: attachments are included in the downloaded zip as separate files, and the CSV holds a reference to them.
- Multi-select and people become lists: several values in one cell are joined together, usually separated by commas, which can make the file harder to read in Excel until you split them.
If you need the page titles behind a relation, the practical fix is to add a rollup in Notion that pulls the title into a text column before exporting, then export that column. It takes a minute to set up and saves a long session of manual lookups.
Getting the CSV into Excel or Google Sheets Cleanly
Double-clicking a CSV file usually opens it in Excel, but the result is not always clean. Dates may change format, long numbers may turn into scientific notation, and commas inside a cell can split the row. A cleaner way is to import the file deliberately.
In Excel, use Data, then Get Data, then From Text or CSV, and choose the file. In the import window, set the delimiter to comma, set the file origin to UTF-8, and check the preview before loading. If a column of IDs or codes is being mangled, set that column’s data type to Text during the import, before the data loads. That single step fixes most formatting complaints.
In Google Sheets, use File, then Import, then Upload, and choose the CSV. Pick “Replace current sheet” or “Insert new sheet” as needed, set the separator to comma, and confirm. Sheets handles UTF-8 well, and it keeps long IDs intact more reliably than a double-click open in Excel. If a column still looks wrong, select it, go to Format, then Number, then Plain text, and re-import rather than retyping the values.
There is no direct export from Notion to an Excel .xlsx file. The path is CSV first, then open the CSV in Excel, or sync to Google Sheets and download that sheet as .xlsx from File, then Download. Both routes give you a real spreadsheet file at the end.
Can I Export All Views at Once, or a Whole Workspace?
You cannot export all views of a database at once. Each export covers the view you have open, so a database with five views needs five exports, one per view. Views that show the same data with different filters will produce different files, so label each downloaded file with the view name as soon as you export it, or the files become hard to tell apart.
A whole workspace is a different feature. In Notion, go to Settings, then Export all workspace content. Notion prepares the export and sends you a download link by email, and the link expires in seven days, so download it promptly. The workspace export includes all pages and databases, each as its own files, and it can be large, so it takes longer than a single database export. This is the right tool for a full backup, and the wrong tool for a quick copy of one table.
Is There a Way to Keep the Export Live?
A CSV export is a snapshot, and it never updates itself. If your data changes often and the spreadsheet must stay current, you need a sync tool instead of an export. Several tools connect Notion to Google Sheets and keep the two in sync, either one way or both ways, on a schedule or when the data changes. Sync2Sheets is one such tool, and similar options exist for Excel and Airtable.
Sync tools cost money and need setup, so use them only when the data genuinely changes often enough to justify it. For a weekly report, a manual export each week is usually fine. For a dashboard the whole team reads daily, a live sync is worth the cost. Before buying a sync tool, check three things: whether it handles relations and rollups the way you need, how often it syncs, and what happens to your data if you cancel.
Troubleshooting Common Export Problems
- Missing columns: the columns were hidden in the view you exported. Unhide them in the view, then export again.
- Relations showing as IDs: this is normal. Add a rollup that pulls the related page title into a text column, then export that column.
- Dates in the wrong format: set the column type to Text during import, or change the date format in Excel or Sheets after importing.
- Broken rows: a comma inside a cell value can split a row in a badly formed file. Import with the delimiter set to comma and the text qualifier set to double quotes, which is the default in both Excel and Sheets.
- Empty export: check that the view has rows and that no filter is hiding them. A filtered view exports only the rows it shows.
- Export button missing: you may not have permission to export that page. Workspace owners can restrict exports, so ask the workspace owner if the option is greyed out.
FAQs About Exporting a Notion Database to CSV
Can you export a Notion database to Excel directly?
No, there is no direct .xlsx export in Notion. Export the database to CSV, open the CSV in Excel, and save it as .xlsx, or sync the database to Google Sheets and download that sheet as .xlsx from File, then Download. Both routes give you a working Excel file.
Why are my relations showing as IDs?
Relations export as UUIDs, the internal IDs Notion uses for pages, rather than the page titles you see on screen. To get titles in the export, add a rollup property that pulls the related page title into a text column, then export that column with the rest of the database.
Can I export all views at once?
No, one export covers one view at a time, and Form views cannot be exported at all. Export each view separately from a table view, and label each file with the view name as you go, so the files do not get mixed up.
How do I export a whole workspace?
Go to Settings, then Export all workspace content. Notion prepares the export and emails you a download link, which expires in seven days, so download it promptly. The export includes all pages and databases, and it can be large, so allow time for it to prepare.
Is there a way to keep the export live?
Yes, with a sync tool that connects Notion to Google Sheets or Excel and updates on a schedule. A one-time CSV export never updates itself. Use a sync tool when the data changes often and the spreadsheet must stay current, and check how it handles relations, how often it syncs, and what happens to your data if you cancel.
Related Reading
- What Is Inventory Management Software and How Does It Work?
- Best Project Management Software for Small Business
- How to Schedule Posts in Buffer
Conclusion
Exporting a Notion database to CSV is simple: three dots, Export, Markdown and CSV, and you have a snapshot of one view. The useful part is what happens next: knowing that formulas become values, relations become IDs, and hidden columns are left out, and knowing how to import the file cleanly into Excel or Sheets. For a one-time copy, the export is enough. For data that keeps changing, a sync tool is the right answer, and for a full backup, the workspace export is the tool to use.
One thought on “How to Export Notion Database to CSV (And Fix the Messy Parts)”