What copying a page into a database column actually does

When you copy a page into a database column in Notion, you are taking the content from one Notion page and storing a link or reference to it inside a cell. Notion does not paste the page's text directly into the column the way you would paste text into a spreadsheet. Instead, it creates a relation or rollup that connects the two — the column holds a pointer to the page, and you can see that page's properties and content by clicking the link.

The method you use depends on what you want to store. If you want a straightforward link to the page, you use a URL column. If you want to pull specific information from that page into your database row, you use a relation column paired with a rollup. Most people who ask this question actually want a relation, because it lets them see page details without leaving the database view.

Key Takeaways

  • Notion columns cannot hold an entire page's content directly — they hold links or references to pages instead.
  • A URL column stores a straightforward link; a relation column connects your database to another database and lets you pull specific fields into your view.
  • To create a relation, both the page you are linking from and the page you are linking to must be database entries, not standalone pages.
  • Rollup columns work alongside relations to display specific information from the linked page without cluttering your main database view.

Using a URL column for a straightforward page link

The simplest way to store a page reference is to add a URL column to your database and paste the page's link into it. Open the page you want to link to, click the three-dot menu at the top right, and select "Copy link". Then go to your database, create a new column, set its type to URL, and paste the link into the cell.

This method works for any page — it does not matter whether the page is part of a database or standalone. The downside is that you only see the link itself in the column; you cannot see the page's properties or content without clicking through. Use this approach when you just need a way to jump to a page quickly without needing to see its details in your database view.

Creating a relation column to connect two databases

If you want to see information from the linked page directly in your database, you need a relation column. This only works when both pages are database entries — you cannot create a relation to a standalone page. Open your database, click the plus icon to add a column, and select "Relation" as the column type.

Notion will ask you which database you want to relate to. Choose the database that contains the pages you want to link. Then select which property in that database should match a property in your current database — usually this is a name field or ID. Once the relation is set up, you can click into a cell and search for or select the page you want to connect. The relation now exists in both directions: if you go to the linked page's database, you will see a reverse relation showing which pages link to it.

Using rollups to display specific page information

After you create a relation, you can add a rollup column to show specific information from the linked page without opening it. Add a new column, select "Rollup" as the type, and choose the relation column you just created. Notion will then ask which property from the linked page you want to display — this might be a date, a status, a number, or any other field.

For example, if your relation links to a Projects database, you could create a rollup that shows each project's important date or budget directly in your main database view. Rollups can also perform calculations: you can sum numbers, count entries, or find the earliest date across multiple linked pages. This keeps your database view clean while still giving you the information you need without clicking through.

Copying content between pages without a database

If you are working with standalone pages rather than database entries, you cannot use relations. Instead, you have two options: copy the page's URL into a text or URL column, or manually copy and paste the page's content into a text block on another page.

To copy content directly, open the page you want to copy from, select all the content you need (Ctrl+A on Windows, Cmd+A on Mac), and copy it. Then go to the destination page and paste it. This creates a duplicate of the content, not a link — changes to the original page will not update the copy. Use this method only when you need a snapshot of the page at a specific moment, not a live connection.

Why Notion does not let you embed entire pages in columns

Database columns in Notion are designed to hold structured data — text, numbers, dates, checkboxes, and links. A full page contains multiple blocks, formatting, and nested content that does not fit into a single cell. Storing an entire page inside a column would break the database structure and make the view unusable.

Relations and rollups solve this problem by letting you reference page data without storing the page itself. If you find yourself wanting to see a lot of page content in your database view, consider whether you actually need a database or whether a linked page structure would work better for your use case.

Common mistakes when trying to copy pages into columns

The most common mistake is trying to paste page content directly into a text column and expecting it to stay formatted. Notion will paste the text, but it strips out most formatting — images, nested blocks, and complex layouts disappear. If you need formatted content, use a relation to the original page instead.

Another mistake is trying to create a relation between a database entry and a standalone page. Relations only work between database entries. If you have a standalone page you want to reference, use a URL column or manually create a link block on your page instead. Finally, people sometimes create too many rollup columns and end up duplicating information that already exists in the linked database — keep rollups focused on the specific details you actually need to see in your current view.

Frequently Asked Questions

Can I copy a page into a database column and have it update automatically?

Not directly. If you use a relation and rollup, the rollup will show current information from the linked page, so it updates automatically. If you manually copy page content into a text column, it becomes a static copy that does not update. Use relations for live connections.

What is the difference between a relation and a lookup?

A relation creates the connection between two databases. A lookup column (not rollup) shows all the properties from a linked page at once, while a rollup shows only the specific property you choose. Use lookup when you want to see everything; use rollup when you want to see one specific field.

Can I create a relation if the pages are not in a database?

No. Relations only work between database entries. If you have standalone pages, use a URL column to store links to them instead. You can also create a manual link block on a page by typing "/" and selecting "Link to page".

Will copying a page's URL into a column let me see the page content without clicking?

No. A URL column just shows the link. To see page content in your database view without clicking, you need a relation paired with a rollup column that pulls specific information from the linked page.

What happens if I delete the original page after creating a relation to it?

The relation will break and show as empty. Notion does not automatically delete the relation entry — it just becomes a dead link. You can manually remove it from the database, or leave it as a record that the page no longer exists.