Notion databases help you organize information clearly and work faster. They turn lists, notes, or ideas into a system you can sort, filter, and view in many ways. Learning how to create a Notion database is the first step to building a setup that actually works.
This guide shows each step in plain language - how to start a new database, set properties, and switch between views. You’ll understand how Notion stores and connects data so you can manage projects, tasks, or content more easily.
Follow along to build your first Notion database from scratch. It’s simple, practical, and takes only a few minutes to learn.
How to Create a Database in Notion
1. Start a New Database
Open the page where you want to create your database, then type /database to bring up the block menu. Choose “Inline Database” if you want the database to appear within the current page, or “Full Page Database” if you prefer it as a standalone page.
Notion will instantly create a blank database block for you. From there, you can choose different view options such as Table, Board, Gallery, or List to organize your data. This is how your empty database will look.
2. Add Columns and Properties
Notion begins with default columns such as Name and Tags, but you’ll likely need to add more based on what you’re building. To create a new column, click the ➕ icon next to the existing ones. To add a new row—or a new item—use the ➕ New button.
Each row acts as a record, like an employee name, start date, client name, and so on, ready to hold related data. The updated database now includes basic details such as employee names, reporting information, date of joining, and compensation. While real-world employee databases are often more detailed and complex, we’ll keep this example simple for this guide.
3. Assign Proper Property Types and Add Your Entries
Every column in Notion is a “property.” You should define the type depending on the data you want:
Click the column header → choose Property Type → and select (e.g.) Date, Person, Number, Select, Multi-select, etc.
For instance:
A “Project Name” column → Name of the Project
A “Client Name” column → Name of the Client
A “start date” or “Deadline” column → Number
This ensures data consistency - e.g., when you click a Date-type cell, you get a calendar picker.
This is how the table looks after setting types for all columns
4. Add Details to Each Entry (Page)
Each row in your database is not just a record - it’s a full Notion page. Click on any entry to open it. Inside, you can add notes, files, images, checklists, or any content you want - just like a normal Notion page.
This makes each item a rich data container, not just a spreadsheet row.
5. Sort, Filter, and Search Your Data
Once your data is in:
Use Sort and Filter buttons to organize and narrow down your entries (e.g., show only items with status = “In Progress”).
Use the built-in Search to quickly find what you need - useful when your database gets large.
Notion also offers a Calculate (or “sum/average/min/max”) feature for columns typed as Number - great for totals, budgets, or metrics.
6. Change How You View Your Database
Your data isn’t rigid. Notion lets you view the same information in different formats to suit your workflow:
Calendar View - great for scheduling deadlines, events, or timelines (for columns of Date type).
Gallery View - perfect for portfolios, visual content, or anything with media.
List View - a clean linear list if you want a minimalist overview.
7. Connect Database (Optional, but powerful)
Once you know the basics, you can link databases in Notion to connect related information. For example, link a Tasks database with a Projects database so each task is tied to its project. Add a Relation property to connect the two, and use a Rollup property to display summary data such as completed tasks. This creates a connected, automated system for better organization.
How to Use Databases in Notion
Notion databases are where the real magic happens. They give you a flexible, visual way to organize anything - from a simple task list to a full business workspace. Once you learn how to use them well, your Notion setup becomes more than just a collection of pages - it becomes a system that works for you.
Here are some of the most practical and creative ways to use databases in Notion
1. Managing a Portfolio
Your portfolio isn’t just a static list of projects - it’s a reflection of your progress and creativity. With a Notion database, you can neatly organize your work samples, add visuals, client names, tags, and dates, and keep everything up to date with new projects. You can even set reminders to refresh your portfolio weekly, so it always stays relevant and professional.
2. CMS (Content Management System)
Think of Notion as your own personal content hub. You can store blog ideas, drafts, SEO notes, images, and publish schedules all in one place. But when it’s time to take that content live, Bullet.so comes in handy. It transforms your Notion pages into beautiful, fast-loading, and SEO-optimized websites, so your Notion workspace isn’t just for planning, but publishing too.
3. CRM (Customer Relationship Management)
Notion makes it surprisingly easy to build your own mini-CRM. Create a database to store client names, contact details, meeting notes, deal stages, and follow-up dates. You can sort leads by status, set reminders for check-ins, and maintain a full record of communication history — all in one central dashboard.
4. Content Planning
If you’re tired of managing content across endless spreadsheets, a Notion database can change that. You can design your editorial calendar with different views — like Board View for your content pipeline or Calendar View for scheduling posts. Add columns for platforms, deadlines, and content types to keep your team aligned and creative output consistent.
5. Building a Knowledge Base
Every team needs a single source of truth - and Notion databases make that effortless. Build a central knowledge base to store FAQs, SOPs, tutorials, and internal documentation. You can tag each entry by topic, use linked databases to connect related guides, and make information instantly accessible to your team.
Conclusion
This guide explained how to create and use databases in Notion - from adding columns and setting property types to sorting, filtering, and switching between views. Once you master these steps, you can organize tasks, projects, or content efficiently and turn Notion into a powerful all-in-one workspace.
Frequently Asked Questions
1. How do I create a database in Notion?
Type /database on any page and choose between Inline or Full Page. Then add columns, set property types, and start adding entries.
2. How to turn a Notion page into a database?
Convert an existing page by typing /table, /board, or another database view. You can then copy your existing content into the new database.
3. Are Notion databases free?
Yes. Databases are available on Notion’s free plan with full functionality for individuals and small teams.
4. Can I link two databases in Notion?
Yes. Use the Relation property to connect entries across databases and Rollup to display related info.
5. How do I switch between different database views?
Click + Add a View at the top-left of your database, then choose formats like Table, Board, Calendar, or Gallery.