Table view

Uh-oh! It looks like your ad blocker is preventing the video from playing.

A table is the classic database view, but tables in Notion are more than just rows and columns. Each row opens up into its own page, and can contain whatever properties you want 📊
Jump to FAQsHere's how to to add a database in table view to Notion:
Create a new page in your workspace.
Under
Get started with
, click•••
→Table
.
If you want to create an inline table, type /Table view
on any page and press enter
.

Note: Expand inline databases to full page by clicking ⤢
at the top right.
Add table view to a database
You can add a table to an existing database to view its data in that format.
Click
+
next to the name of your database or the name of your current database view.Select
Table
from the dropdown menu.

Note: You can also create simple tables if you want to display plain text visually without database functionalities (such as filters, sorts, and specific property values).
You can select multiple rows in order to edit their properties.
Hover over any row and click the checkbox that appears next to it.
If you want to select all of the rows in your database, hover over the
Name
property and click the checkbox that appears next to it.
From the menu that appears, edit any of your database properties for your selected rows.
Rearrange columns and rows
Switch up how your table is ordered with drag-and-drop on desktop or browser.
For rows, hover, then click and hold the
⋮⋮
icon on the left to drag it up or down.For columns, click and hold their headings to drag them left or right (like below).
Resize columns by hovering over their edges, and dragging right or left.

Tip: You can also rearrange your columns by clicking Properties
at the top right, then using the ⋮⋮
icon next to the properties shown to drag them up or down.
Wrap cell content
If your cells contain a lot of content, you can wrap the content to make it appear across multiple lines. To do this, click the name of a database property. In the menu that appears, select Wrap text
.
Calculations
For each column in your database, you can run calculations that will show you information about the data contained in that column.
Depending on the type of property you’re running a calculation on, you’ll see some or all of the following calculation options:
Count all
: Gives you the total number of rows in the column.Count values
: Counts the number of property values contained in the column.Count unique values
: Counts the number of unique property values contained in the column, omitting duplicates.Count empty
: Counts the number of rows that do not have a value in the column.Count not empty
: Counts the number of rows where the column is filled.Percent empty
: Gives you the percentage of rows that do not have the chosen property filled in.Percent not empty
: Gives you the percentage of cards that do have the property filled in.Earliest date
: If you have time-related properties in your table likeLast edited
orCreated time
, you can choose to show when the oldest row was edited or created.Latest date
: Shows when the newest row was last edited or created.Date range
: Shows you the time gap between the oldest and newest edit or creation time.If you have a
Number
property in your table, you unlock several other calculation options:Sum
: Shows the sum of the numbers in the column.Average
: Shows the average of the numbers in the column.Median
: Shows the median of the numbers in the column.Min
: Shows the lowest number in the column.Max
: Shows the highest number in the column.Range
: Subtracts the lowest number from the highest.
To run a calculation on a property:
Click on a property in your table.
In the menu that appears, hover over
Calculate
. Select from one of the calculation options.

Here are some use cases for tables from our team and the Notion community:
FAQs
Is there a way to add background colors to specific cells? Or conditional formatting?
Is there a way to add background colors to specific cells? Or conditional formatting?
Not at the moment, unfortunately. It's a popular feature request though, so definitely on our radar! For the time being, you can use Select and Multi-select properties to add a pop of color to your table 🎨
Why can't I delete the Name property?
Why can't I delete the Name property?
Our tables are a lot different than traditional spreadsheets, since each row represents a database entry that can be opened as its own page, or visualized in other database views. The Title
property gives you access to database pages. That said, you can drag the column left or right to re-order it however you want!
I don’t want my database pages to open on the side or in the center of my page. Is there anyway to open a database page in full-screen by default?
I don’t want my database pages to open on the side or in the center of my page. Is there anyway to open a database page in full-screen by default?
Yes! To do this:
Open the settings menu at the top of your database.
Select
Layout
→Open pages in
→Full page
.
Does Notion have simple (non-database) tables?
Does Notion have simple (non-database) tables?
How can I turn a full page database into an inline database?
How can I turn a full page database into an inline database?
If it's not already, drag the database from your sidebar into another page. It will become sub-page
Go to that page, click the
⋮⋮
button next to the database sub-page and selectTurn into inline
.Click the
⋮⋮
button and selectTurn into page
to change it back.