Merge Notion Databases: A Step-by-Step Guide

LAST UPDATED
September 4, 2024
Jason Gong
apps
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.
__wf_reserved_inherit
__wf_reserved_inherit

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.
__wf_reserved_inherit
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
Schedule a demo

Related frequently asked questions

Tagging in HubSpot: A Step-by-Step Guide

Learn how to use custom properties and Deal Tags in HubSpot for effective CRM data organization, despite the lack of direct tagging functionality.

Read more
3 easy ways to insert an arrow in Google Sheets

How to add arrows in Google Sheets? Discover 3 ways: using shapes, symbols, or images. Also, learn how dynamic arrow insertion works, and what add-ons exist.

Read more
Use ChatGPT in Gmail: A Step-by-Step Guide (4 Steps)

Learn how to integrate ChatGPT with Gmail using plugins for AI-powered email drafting and responses, enhancing productivity and efficiency.

Read more
Earn Your HubSpot Certification: A Step-by-Step Guide

Learn how to earn HubSpot certification in marketing, sales, service, and design with this step-by-step guide. Enhance your professional profile.

Read more
Ultimate Guide to Amazon Web Scraping: 5 Steps

Learn to web scrape Amazon in 5 steps: Setup Python, use BeautifulSoup, handle pagination, and export data. Ideal for price monitoring and product analysis.

Read more
Troubleshooting Clearbit Connect Issues: A Step-by-Step Guide

Resolve Clearbit Connect issues with our guide on installation, checking credits, and privacy concerns. Learn to troubleshoot for seamless usage.

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.