Merge Notion Databases: A Step-by-Step Guide

Jason Gong
LAST UPDATED
June 6, 2024
TL;DR

Use CSV exports or the Relation function to combine Notion databases.

By the way, we're Bardeen, we build a free AI Agent for doing repetitive tasks.

If you're organizing Notion databases, you might love Bardeen's AI Agent for Notion. It can automate your workflows and save you time.

How to Combine Databases in Notion

Combining databases in Notion is a common need for users looking to streamline their data management and organization. While Notion does not offer a direct one-click solution for merging databases, there are effective methods to achieve this goal. Below, we explore two alternative methods to combine databases in Notion, along with a solution for merging multiple databases into a single master database.

Alternative Method 1: Exporting Table as “Markdown & CSV” File to Merge Databases in Notion

  1. Select the 3-dot icon on the top right corner of the Notion page.
  2. Click “Export” from the dropdown menu.
  3. Choose the “Markdown & CSV” file option.
  4. Select the “Export” button and wait for the process to complete.
  5. Save the CSV file on your computer.
  6. Extract the CSV file you downloaded.
  7. Click the 3-dot icon again and choose “Merge with CSV” on the main database page.
  8. Select the CSV file and click “Open” to import it into the main database.

This method allows you to export the data from one database and import it into another, effectively combining them.

Alternative Method 2: Using the Relation Function to Merge Databases in Notion

  1. Click the “New” button on the upper-right of the main Notion database.
  2. Select “Add a property” after the last entry on the side peek page.
  3. Scroll down or type “Relation” in the search bar and select it.
  4. Choose the database to be linked with the main database.
  5. Select “Add relation” after making necessary adjustments.
  6. Exit the side peek page to see the second database merged as a new property.

The Relation function allows you to link data from one database to another, enabling you to view and manage related data across databases without physically merging them.

How to Merge Multiple Databases in Notion

  1. Create a new page for the master database.
  2. Add a database to the new page or select one from the existing databases.
  3. Move other databases into the master database by selecting “Move to” from the 3-dot icon menu of each database.
  4. Ensure all properties in the databases are of the same type and label.
  5. Highlight and drag the rows of the databases you wish to merge into the master database.
  6. Delete any excess or redundant properties from the master database.
  7. Add another view to the master database if needed, customizing it to your preference.
3. Move other databases into the master Move other databases into the master database by selecting “Move to” from the 3-dot icon menu of each database.database by selecting “Move to” from the 3-dot icon menu of each database.

This approach is suitable for combining multiple databases into one central database, allowing for a unified view of all related data.

By following these methods, you can effectively combine databases in Notion to enhance your data organization and streamline your workflow.

Automate Your Notion Databases with Bardeen

Merging databases in Notion can be a manual process that involves a lot of copying, pasting, and organizing. However, with Bardeen, you can automate the combination of Notion databases, saving you time and ensuring consistency across your workspaces. Automating these tasks allows you to focus on more strategic work, like analyzing the combined data or planning your next steps based on the insights gathered.

Here are examples of automations that can be built with Bardeen using the provided playbooks:

  1. Copy all Notion pages from one database to another: This playbook makes it easy to consolidate pages across multiple Notion databases, perfect for when you're reorganizing your workspace or creating a master database for your projects.
  2. Copy all Pipedrive organizations to Notion: Ideal for sales and marketing teams, this playbook simplifies CRM data management by bringing all your Pipedrive organization data into Notion for easy access and analysis.
  3. Copy all Notion data to SmartSuite: For teams using SmartSuite for project management, this playbook ensures that all relevant data from Notion is seamlessly transferred, optimizing project tracking and collaboration.

To explore more ways Bardeen can automate your workflow in Notion, download the app at Bardeen.ai/download.

Contents
Bardeen's AI Agent for Notion

Automate your Notion workflows with Bardeen's AI Agent. No coding required.

Get Bardeen free

Related frequently asked questions

Master Salesforce Filter Logic: A Step-by-Step Guide

Discover how to use Salesforce filter logic to manage data efficiently. Learn to apply conditions for precise data retrieval and optimize CRM management.

Read more
Convert Fractions to Percentages in Google Sheets: Easy Steps

Learn to convert fractions to percentages in Google Sheets using simple formulas and formatting. Ideal for data analysis and calculations.

Read more
Master IMPORTRANGE in Google Sheets: A Step-by-Step Guide

Learn to use Google Sheets' IMPORTRANGE function for easy data import between spreadsheets, ensuring data consistency and efficient collaboration.

Read more
Easy Guide to Add Footnotes in Google Docs: 4 Steps

Learn to easily add footnotes in Google Docs, including Chicago style and multiple footnotes, for both web and mobile app versions.

Read more
Sync Apple Calendar with Notion: A Step-by-Step Guide

Learn how to connect Apple Calendar to Notion using two methods for streamlined scheduling and productivity, despite the lack of direct integration.

Read more
AI Data Automation: 7 Key Insights for 2024

Unlock the potential of AI in data automation with our guide on 7 essential insights for enhancing accuracy and efficiency in 2024.

Read more
how does bardeen work?

Your proactive teammate — doing the busywork to save you time

Integrate your apps and websites

Use data and events in one app to automate another. Bardeen supports an increasing library of powerful integrations.

Perform tasks & actions

Bardeen completes tasks in apps and websites you use for work, so you don't have to - filling forms, sending messages, or even crafting detailed reports.

Combine it all to create workflows

Workflows are a series of actions triggered by you or a change in a connected app. They automate repetitive tasks you normally perform manually - saving you time.

get bardeen

Don't just connect your apps, automate them.

200,000+ users and counting use Bardeen to eliminate repetitive tasks

Effortless setup
AI powered workflows
Free to use
Reading time
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
By clicking “Accept”, you agree to the storing of cookies. View our Privacy Policy for more information.