Book Tracker Notion: Step-by-Step Setup
This guide walks you through building a personal book tracker in Notion, so you can log what you read, track your progress, and review your reading history. You’ll create a database with custom properties, set up views for different statuses, and add a dashboard for quick stats. By the end, you’ll have a functional system that works on desktop and mobile.
What You’ll Need
- A Notion account (free or paid).
- A workspace where you can create a new page.
- Basic familiarity with Notion’s interface (creating pages, adding properties).
Step-by-Step
- Create a new page. In your workspace, click + New page in the sidebar. Name it “Book Tracker” (or something similar).
- Add a database. Type
/tableand select Table – Inline. This creates a database inside your page. Alternatively, you can use a full-page database, but inline keeps the dashboard layout flexible. - Set up properties. By default, a table has a Name column. Add these properties (click + in the last column header):
- Status (Select): options like “To Read”, “Reading”, “Finished”, “DNF”.
- Author (Text).
- Genre (Select or Multi-select).
- Pages (Number).
- Current Page (Number) – for tracking progress.
- Rating (Select or Number, 1-5).
- Date Started (Date).
- Date Finished (Date).
- Notes (Text or Rich Text).
- Add a formula for progress. Create a Formula property named “Progress %”. Use this formula:
if(prop("Pages") > 0, round(prop("Current Page") / prop("Pages") * 100), 0). This shows the percentage read. - Create views. Click the + next to the current view name (e.g., “Table”) to add views. Useful views:
- All Books (Table) – default.
- Currently Reading (Board or Gallery) – filter by Status = Reading.
- To Read (List) – filter by Status = To Read.
- Finished (Gallery) – filter by Status = Finished.
To set a filter, click Filter in the view toolbar, add a condition (e.g., Status is Reading).
- Sort and group. In a view, click Sort to order by Date Finished (descending) or Rating. Use Group to group by Status or Genre.
- Add a dashboard (optional). Above the database, create a section with linked views or stats. You can use Inline databases with filters, or add a Linked database that shows only certain books. For stats, you can use Notion’s Rollup or Formula properties, but for simplicity, just add a few linked views (e.g., “Currently Reading” and “Recent Finishes”) by typing
/linkedand selecting the database. - Add book entries. Click the + New button in the database to add a book. Fill in the properties. For the cover, you can add a Files & media property to upload a cover image, or use the page’s cover.
- Customize the layout. Drag properties to reorder columns. Change property types if needed (e.g., Rating as stars via a formula).
- Test it. Add a few sample books, change statuses, and see how views update.
Common Mistakes
- Forgetting to set the property type. If you type “Reading” into a text column, it won’t work as a status filter. Use a Select property.
- Using the wrong formula syntax. Notion formulas are case-sensitive and use
prop("Name"). If you get an error, check for typos. - Not creating separate views. If you filter the main table, you lose the overview. Always create new views instead of filtering the original.
- Overcomplicating the database. Start with the basics; add more properties later if needed.
Tips
- Use a Relation property to link books to a separate “Reviews” database if you want longer notes.
- Add a Template for new books so properties are pre-filled (e.g., Status = To Read).
- Use the mobile app to quickly add books or update current page.
- Color-code statuses via the Select options for visual clarity.
- If you read multiple formats, add a “Format” property (Paperback, Kindle, Audiobook).
Troubleshooting
- Formula shows an error. Check that property names match exactly. Use
prop("Pages")notprop("pages"). Also ensure the property type is Number. - Filter not working. Make sure the property is a Select type and the filter condition matches the exact option name (case-sensitive).
- View not updating. Click the refresh icon in the view toolbar, or close and reopen the page.
- Can’t find a property. Scroll right in the table; columns may be hidden. Use the Properties menu (three dots) to show/hide.
- Database is too wide. Switch to a board or list view for better mobile experience.
Frequently Asked Questions
Can I track reading progress automatically?
Not fully automatically, but you can manually update the “Current Page” number, and the Progress % formula will recalculate.
How do I add a book cover?
Add a Files & media property and upload an image, or use the page’s cover by clicking Add cover on the book’s page.
Can I share my book tracker with friends?
Yes. Click Share in the top right and invite people with edit or view permissions.
How do I create a yearly reading goal?
Create a separate database or use a Rollup to count books with a Date Finished in the current year. Or simply filter your Finished view by date.
Can I import books from Goodreads?
Not directly, but you can export your Goodreads data as CSV and import it into Notion via the database’s Import option (though property mapping may be manual).
Is this template free?
Yes, you build it yourself using the free Notion plan. No paid features are required.
Related
Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.