Organizing data is one of the most crucial aspects of businesses of all sizes. Be it a one-person business with a Notion portfolio or a large organization, the ease of processing data and generating insights from it determine how agile the company is and how smoothly it functions.
Notion tables simplify the storage and management of data. They offer flexibility, an excellent user experience, and the ability to collaborate with your team on projects.
Here are the 5 steps to creating tables in Notion:
1. Create a Notion table block
First, create a new Notion page or navigate to an existing one where you want to set up the table. Next, create a table block by typing ‘/’ and selecting Table from the list of Notion blocks.
For this example, we are creating a travel planner in a tabular format. So we have set the table name to Travel Planner.
And here is what it looks like:
It has a bunch of columns and rows to include all the details about the day-to-day activities. We will use this as an example to show all the steps for creating and using a table.
2. Add columns to the Notion table
The simplest way to add a column is by clicking on the ➕button at the rightmost point of the table.
If you want to insert a column to the left or right of another column, click on the 6 dots icon that shows up every time you hover over a column and select Insert Left or Insert Right depending on where you want to place it.
You can also use the same view to add color to the column, duplicate it, clear all content, or delete it. You can also rearrange your Notion table columns by clicking on the 6 dots icon and dragging the columns anywhere in the table.
3. Add rows to the table
To add a new row at the bottom of the table, click on the ➕button that appears when you hover over the current last row for both full-screen and inline Notion tables.
If you intend to insert a row between two rows, click on the 6 dots icon towards the extreme left of the row and click on Insert Above or Insert Below depending on where you want to insert the row.
You can also use all other options that were available for columns. You can move rows around for consistency or setting up a cleaner Notion table format.
4. Set header rows and columns
This option lets you set a different color for the first row and column of your table. To activate it, click on Options at the top-right of your table can turn either or both toggles for the Header column and Header row.
5. Share your table
Notion allows you to share your tables, just like any other block. Click on Share at the top right of your screen and select the audience. You can share with individuals, your teamspaces, or with everyone on the internet by making the table public.
How to put tables side-by-side in Notion?
Use the Notion ‘Columns’ block to place multiple tables next to each other. Here’s how to do that:
1. Open a Notion page
Here’s the same Travel Planner page with two tables.
2. Type ‘/column’ and select the number of columns
In our example, we need to place two tables next to each other, so we will select the ‘2 columns’ option.
Notion inserts a 2 column block, as highlighted in the image below.
3. Drag Notion tables into individual columns
Drag tables into columns one by one by clicking on the six-dots icon that appears when you hover over them and dragging it into the columns block.
A faster way to place Notion tables side-by-side is by dragging one table next to the other. You can do that by clicking and holding onto the six-dot icon that appears when hovering over one table and moving it next to the other.
FAQs
How many rows can a Notion table have?
There is no limit on the number of rows that your Notion table can have. You can include as many as you require.
How do I copy a table from Notion to excel?
- Go to the page where your Notion table is located. Next, click on the '⋯' icon at the top right corner of your screen, and click on Export. Set the download file format as CSV.
- Create a new Google Sheet and import the CSV file there.
How do you enter a new line in a Notion table?
Use the SHIFT+RETURN keyboard shortcut to enter a new line in a Notion table. Using the RETURN key alone will take you to the cell below the current one.
How to add a page to a Notion table?
Use the ‘@’ operator to add a page to your Notion table. To add an existing page, type ‘@’ in the desired cell and start typing the name of the page. Notion will display the desired page, clicking on it will insert the page into the cell.
To add a new page, type ‘@page’, and click the ‘New “page” sub-page’ option. This will insert a new page inside the cell, which will appear as a subpage under the page containing the table
How to delete a table in Notion?
Click the six-dots icon that appears when hovering over the table and click the ‘Delete’ option to delete the Notion table.
How to convert Notion tables into a database?
Hover over the Notion table to make the six-dots icon. Click on it and select the ‘Turn into database’ option to convert the table into a Notion database.
How to delete columns in a Notion table?
Click the six-dots icon that appears in the top cell of a table column that appears when you hover over it and select the ‘Delete’ option to delete the column of your Notion table.
How to change column width in a Notion table?
1. Take the cursor to the line separating two columns.
2. Click on the line and drag it around to change the width of the column to the left of the line.
How to move a Notion table to another page?
1. On hovering over the Notion table, you will notice a six-dots icon. Click on it and select the ‘Move to’ option.
2. Select the destination page for the table
How to make a Notion table smaller?
Minimize the width of columns to make the table appear smaller. Double click on each vertical line between columns to set the column to the left of the line to the thinnest width possible.
How to change the row height of a Notion table?
Unlike Notion columns, you can’t alter the width of rows by clicking and dragging the arrow separator lines. You can only increase the row height by creating new lines in one cell of the row.
To do that, click inside any cell within the row you want to alter and use the SHIFT + RETURN keyboard shortcut.
