TBR List Template: Columns That Help You Choose
TBR list template with practical columns for what you own, what you want next, and why it caught your eye. Use a simple view to pick a book.
By Ultimate Book Tracker by Cosmo Suite · Editorial policy
Published · 8 min read

A TBR list starts as a place to save a title. Later, the list can become a long scroll with no clue about which books you own, can borrow, or still want to read. A useful TBR list template keeps those decisions visible without asking you to plan an entire reading year.
Use one row per book. Keep a few fields that help you find it and choose it, then filter the full list into a short view when you are ready to read. You can keep saving titles without turning every save into a commitment.
For a TBR list template, start with title, author, access, format, priority, and one short note. Add page count, mood, or series order only when they help you choose.
The Short Version
- Keep one complete list, then make a smaller view for choosing.
- Record where a book is and why you saved it.
- Treat priority as a current signal, not a reading deadline.
What does a TBR list need to help you decide?
A TBR list is a place to collect books you may want to read. A useful one answers two questions: can you get the book, and do you want it now? Start with those decisions instead of collecting every detail. A note about why you saved a book can help more than a category you rarely filter.
The first question prevents a frustrating choice. A book may be on your list because it is already on your shelf, available through a library, or something you still need to find. The second question separates a title you are curious about from one you are in the mood to read soon.
You do not have to decide an order for every title. A meta-analysis found that the effect of assortment size depends on factors such as task difficulty, preference uncertainty, and decision goal, so the choice that feels manageable can vary. Keep a full TBR, then make a shorter view when you want to choose one book. The review of choice-overload research explains these factors. If your mood changes, pick a different title. Saving a book now does not mean you have to read it next.
TBR list template at a glance
A practical template uses a title and author field, a way to find the book, and a small number of choice fields. Add a column only when it helps you locate, remember, or pick a title. These fields work in a spreadsheet, notebook, or printable page.
| Field | What to record | How it helps |
|---|---|---|
| Title and author | The edition or author detail that distinguishes the book | Find the right title later |
| Access | Owned, library, borrowed, subscription, or find a copy | See whether it is ready to read |
| Format | Print, ebook, audiobook, or your own label | Match the book to how you want to read |
| Priority | Up next, soon, or someday | Separate current interest from the full backlog |
| Why it caught your eye | A recommendation, series, topic, or one-line reminder | Remember the reason you saved it |
| Length or mood | Pages or a simple mood label, if useful | Narrow choices for a particular moment |
| Review note | Keep, reconsider, or remove | Let the list change with your interests |
Begin with title, author, access, format, and priority. Add length, mood, or a review note only if you use them. Priority is a reader-set label for current interest, not a date or a rating. If you are making the list in Google Sheets, its sort and filter guide explains how to make a view from a range. A dropdown list can keep repeated entries such as access or priority labels consistent.

One reading year, worked through
Picture a reader starting the year with 20 TBR titles. Each row has ownership, priority, a rough length band, a mood for the day, and why the title was saved. Methodology: the titles and authors are real; every other entry is fictional to show how a filter might work. This is not survey data, a customer record, or product testing.
| Title and author | Owned? | Priority | Length band | Mood today | Why it was saved |
|---|---|---|---|---|---|
| A Wizard of Earthsea, Ursula K. Le Guin | Yes | Up next | Medium | Focused | Series |
| A Wrinkle in Time, Madeleine L'Engle | No | Someday | Short | Curious | Recommendation |
| And Then There Were None, Agatha Christie | Yes | Soon | Medium | Light | On my shelf |
| Beloved, Toni Morrison | No | Someday | Medium | Focused | Topic of interest |
| Braiding Sweetgrass, Robin Wall Kimmerer | No | Soon | Long | Reflective | Saved from an article |
| Dune, Frank Herbert | Yes | Someday | Long | Immersive | Series |
| Frankenstein, Mary Shelley | No | Up next | Medium | Curious | Classic |
| Hamnet, Maggie O'Farrell | No | Soon | Medium | Reflective | Recommendation |
| Jane Eyre, Charlotte Brontë | Yes | Someday | Long | Focused | On my shelf |
| Kindred, Octavia E. Butler | No | Up next | Medium | Focused | Book group |
| Little Women, Louisa May Alcott | Yes | Soon | Long | Comforting | On my shelf |
| Middlemarch, George Eliot | No | Someday | Long | Patient | Classic |
| My Ántonia, Willa Cather | No | Soon | Medium | Reflective | Recommendation |
| Never Let Me Go, Kazuo Ishiguro | Yes | Up next | Medium | Thoughtful | On my shelf |
| Piranesi, Susanna Clarke | No | Soon | Short | Curious | Recommendation |
| Pride and Prejudice, Jane Austen | Yes | Someday | Medium | Light | Classic |
| The Fifth Season, N. K. Jemisin | No | Up next | Long | Immersive | Series |
| The House on Mango Street, Sandra Cisneros | No | Soon | Short | Curious | Book group |
| The Left Hand of Darkness, Ursula K. Le Guin | Yes | Someday | Long | Focused | On my shelf |
| The Secret Garden, Frances Hodgson Burnett | No | Soon | Medium | Comforting | Recommendation |
At the start of the year, the reader filters to owned books with an "Up next" priority, then checks the mood and reason notes before choosing. A reader-defined length band can help when time is short. Those labels are not page counts for a specific edition or judgments about the books.
When that choice changes, the reader can clear the filter and choose again. When a book moves into their reading history, the TBR view gets shorter without losing the other titles.
Later in the year, a different choice might depend on format, length, or access. Add those fields only when they help narrow the current decision. Clear the filter when the choice changes; the rest of the TBR can stay untouched.

Build the fields around your next choice
Build the list around the decisions you often make. If you have bought books twice, record whether a title is already owned. If your list mixes physical, digital, and audio books, record format or where to find each one. If recommendations blur together, keep a short note about the source or reason.
Start with a header row and enter one title per row. Keep title and author separate so you can sort by either. Use one access label consistently, such as owned, library, borrowed, or not found yet. Avoid mixing a location like "bedroom shelf" with a status like "borrowed" in the same field.
Then choose a priority that helps today. A small set like "up next," "soon," and "someday" is easier to understand than several overlapping rankings. The label can change when your interest changes. It does not need to represent how good a book is or how long it has waited.
If you use Google Sheets, you can make a dropdown for repeated labels. Google's instructions for in-cell dropdowns show how to add a rule to a cell or range. In Excel or on paper, use the method you already know. Keep the setup simple enough to update.
How do you choose from a long TBR?
A shortlist is a temporary view of titles you can access and feel ready to read now. Keep it separate from the full TBR, which can hold every book you may want. A saved title needs no month, order, or finish date unless that kind of plan helps you.
When you want to choose, filter by access first. Remove books you cannot get right now. Then narrow by format, length, mood, or priority if those details matter in this moment. A spreadsheet can filter several fields; on paper, you can mark a few current choices with a pencil or move them to a separate card.
Keep the shortlist temporary. When you finish a book, move it into your reading history. When your mood changes, clear the view and make another. You are not behind because a book stayed in the full list longer than expected.
If you already keep a separate record of finished books, the book tracker spreadsheet guide shows how a reading list can sit beside the rest of your reading history. You can link a title to that record or keep your TBR in its own simple list.
How often should you review your TBR list?
A TBR review is a quick check that each saved title still earns its place. You do not need a monthly purge or a fixed reading quota. Open the list when it feels too crowded, or when you need to make room for books you are excited about now.
- Check whether you still want to read the title.
- Confirm that you can access it, or note what you need to find it.
- Keep it in the current view, move it to a later group, or remove it.
Some books will remain in the full list for years. That is fine if you still want the reminder. A TBR is allowed to reflect changing taste. It does not need to prove that every saved book will be read.
If you stopped a book and want to record that separately, the guide to what DNF means in books covers that status. This template stays focused on what you might read next, so it does not need to explain or judge that decision.

Where the Ultimate Book Tracker fits
If you want the TBR beside your reading history, use a ready-made workbook called Ultimate Book Tracker (by Cosmo Suite: one Excel and Google Sheets file, 14 tabs, $9 once). Its TBR & Wishlist tab has priority and estimated cost. The connected Reading List records each book's status. One entry updates the other tabs.
That structure is useful when your TBR overlaps with books you own, books you have bought, a series you are following, or a year-end wrap-up. The status field includes TBR, Reading, Read, DNF, and Rereading. The book tracker template guide explains the layout of a connected reading workbook. The file also includes a printable reading journal. You can start with a blank row for each title and choose whether a full workbook or a smaller personal list fits you better.
The Ultimate Book Tracker contents and file details show what comes in the Excel and Google Sheets files. You can also keep your current Goodreads or StoryGraph list and make a separate shortlist for the kinds of choices those lists do not help you make. Learn about the site behind the file on the Ultimate Book Tracker About page.
Frequently asked questions
What should be on a TBR list template?
Start with title and author, then add only the details that help you find and choose the book: where you can get it, format, priority, and a short note about why it interests you. Add page count or mood only if you use those details to narrow your next choice.
How do I make a TBR list in Google Sheets?
Add one book per row, use a header for each detail, then create a filter so you can show only books that fit the choice in front of you. Google's Sheets help explains how to sort and filter a range. A small list of fields is easier to keep current than a wide form.
How many books should I keep on my TBR list?
There is no useful universal cap. Keep the full list as a record of books you may want, then make a smaller view for books you can access and feel ready to read. That lets you save a title without treating it as a promise or a deadline.
How can I organize a long TBR list?
Separate books you are curious about from books you can read soon. Track whether you own or can borrow each one, and add a priority only when it changes what you would pick. Review the list when a title no longer interests you, rather than sorting every book into many categories.
Is a digital or printable TBR list better?
Use the format you will reach for when you want to choose a book. Paper is easy to keep beside a reading chair; a spreadsheet can be searched and filtered as the list grows. You can also keep a short paper shortlist while the full record stays digital.
Sources
Keep reading

Reading Life
What Does DNF Mean in Books? (And How to Track the Ones You Quit)
What does DNF mean in books? It means Did Not Finish. Learn when readers use it, how it differs from pausing, and how to record the page where you stopped.
· 8 min read

Reading Life
Reading Slump: How to Find Your Way Back to a Book
Reading slump: notice what changed, set aside a book that feels like work, and choose one gentle next step without turning reading into another goal.
· 8 min read

Reading Life
Reading Nook Ideas for Small Spaces: Make a Corner Work
Reading nook ideas for small spaces can start with a chair you own. Add useful light, a place for your book, and one detail that feels like you.
· 8 min read