Yes, you can export a Notion table to Excel. The simplest method is to open the table’s menu (the three dots at the top-right of the table), choose Export, select CSV or Excel as the format, and then open the downloaded file in Excel. For a one-time export, that’s all you need. For ongoing syncing or more control over formatting, you’ll want to use Notion’s API or a third-party tool—details below.
Why Export a Notion Table at All?
Notion tables are great for organizing tasks, notes, and databases inside a workspace. But Excel is still the standard for data analysis, pivot tables, charting, and sharing with colleagues who don’t use Notion. You might need to export for a monthly report, to perform calculations Notion can’t handle, or to hand data to a finance team. Understanding the export options ensures you don’t lose data or formatting in the process.
Method 1: Built-in CSV Export (Simplest)
Notion’s native export creates a .csv file (comma-separated values) that Excel opens directly. Here’s the step-by-step:
- Open the page containing your table.
- Click the ••• (three dots) in the top-right corner of the page.
- Select Export.
- In the dialog, choose CSV as the format. (You can also choose Excel—see note below.)
- Click Export and save the file.
- Open the .csv file in Excel. If the data doesn’t separate into columns automatically, use Data > From Text/CSV and choose comma as the delimiter.
Note: Notion’s “Excel” option actually exports a .csv file too, but with a .xlsx extension in some cases. For maximum compatibility, choose CSV and then open in Excel.
Method 2: Using Notion API for Automated Exports
If you need to export the same table regularly (e.g., weekly), you can use Notion’s official API to pull data into Excel automatically. This requires a bit of setup:
- Create an integration in Notion (visit notion.so/my-integrations).
- Copy the API token and share your database with that integration.
- Use a script (e.g., in Python or Power Automate) to fetch the database and write to an Excel file.
For example, a Python script using the requests library can call POST /v1/databases/{database_id}/query to get all rows, then use pandas to write to Excel. This method gives you full control over formatting and can run on a schedule.
Method 3: Third-Party Tools and Integrations
Several no-code tools connect Notion to Excel without writing code:
- Zapier: Create a Zap that triggers on new Notion database items and creates/updates rows in an Excel Online sheet.
- Make (formerly Integromat): Similar to Zapier, with more complex scenarios.
- Whalesync: Syncs Notion databases to Google Sheets or Excel continuously.
- Notion2Sheets: A dedicated tool for two-way sync with Google Sheets (then you can copy to Excel).
These tools are ideal if you want a live connection rather than a one-time export.
What Gets Lost in Export (and How to Minimize Damage)
Notion tables can contain more than plain text: checkboxes, select tags, relations, rollups, files, and media. When exporting to CSV, here’s what happens:
- Text and numbers: export cleanly.
- Checkboxes: become “true” or “false” (or 1/0 in some tools).
- Select and multi-select: become comma-separated lists in one cell.
- Relations: export as the linked page’s title, not the actual relation data.
- Rollups: export as the computed value (e.g., a number or text).
- Files and images: are NOT included; you get a link to the file in Notion.
To minimize data loss, consider flattening complex properties before export: convert relations to text, or use formulas to combine values. Also, if you have a database with sub-items, export only the main table view.
Formatting and Formulas After Export
Once your data is in Excel, you’ll likely need to clean it up:
- Remove extra columns or rename headers.
- Convert text dates to real Excel dates (use
DATEVALUEorText to Columns). - Apply filters and conditional formatting.
- If you exported a CSV, use Data > From Text/CSV to control delimiter and data types.
Remember that Excel formulas are not imported from Notion. If you had formulas in Notion (e.g., a calculated property), they export as static values. You’ll need to recreate them in Excel using standard functions.
Frequently Asked Questions
Q: Can I export a Notion database to Excel without losing the checkbox values?
A: Yes, but they come as “true”/”false” text. You can use Excel’s Find & Replace to change them to TRUE/FALSE or 1/0, or use a formula like =IF(A2="true",1,0).
Q: Why does my exported CSV show dates as numbers like 44562?
A: Excel stores dates as serial numbers. If Notion exported a date as text, Excel might interpret it incorrectly. Use Data > Text to Columns with the date format, or use the DATEVALUE function on the text.
Q: Is there a way to sync Notion to Excel automatically for free?
A: Notion’s API is free, but you need to write a script. If you don’t code, some third-party tools have free tiers (e.g., Zapier’s free plan allows 100 tasks/month). For continuous free sync, you could use Google Sheets with a free integration and then copy to Excel.
Q: Can I export only a filtered view of my Notion table?
A: Yes. Apply your filter in Notion first, then export. Notion exports the current view, so only visible rows are included.
Q: What if my table has sub-items (linked databases)?
A: The export only includes the top-level rows. Sub-items are not included. You’ll need to export each linked database separately.
Q: Does Notion export to .xlsx or .csv?
A: Notion’s export dialog offers both “CSV” and “Excel” options, but both produce a .csv file in practice. The “Excel” option may add a .xlsx extension, but it’s still comma-separated. For true .xlsx with formatting, use the API or a third-party tool.
Choosing the Right Method for Your Situation
To decide, ask yourself:
- One-time export? Use the built-in export.
- Need to repeat weekly/monthly? Use a third-party sync or API script.
- Need two-way sync? Use Whalesync or Notion2Sheets.
- Need complex transformations? Export to CSV and use Excel Power Query.
For most users, the built-in export is enough. For power users, the API offers unlimited possibilities.
Related
- Excel Template for Paying Off Debt: Free & DIY
- Excel Template for Personal Expense Tracking
- Excel Template for Project Budget: How to Build One
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel: How to Hide Every Other Column in a WorksheetTo hide every other column in Excel for Microsoft 365 on Windows, select the column headers you want…
- How to Check for Duplicates in Excel Step by Step GuideTo check for duplicate values in Excel, select the cells you want to inspect, then choose Home >…
- How to Add a Watermark in a Word Document on Any PageIn Word for Microsoft 365 on Windows, open the document and choose Design > Watermark to add a…
- Excel Text Box Linked to Cell: Setup, Uses, and FixesYes. In Excel for Microsoft 365 on Windows, select the text box by its outer border, click the…
- Vacation Budget Spreadsheet by Day: Build and Use OneA vacation budget spreadsheet by day puts each travel date on its own row and groups expected costs…
- ISBLANK in Excel: How It Works and When to Use ItIn Excel, ISBLANK checks whether a cell is genuinely empty and returns the logical value TRUE if it…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.