Lifestyle

·

TBR List Spreadsheet: How to Organize Your To-Be-Read Pile in Google Sheets

TBR List Spreadsheet: How to Organize Your To-Be-Read Pile in Google Sheets

TBR List Spreadsheet: How to Organize Your To-Be-Read Pile in Google Sheets

Organize your to-be-read pile in a Google Sheets TBR list

Every reader knows the feeling: a pile of books on the nightstand, a wishlist on three different apps and no idea what to read next. A TBR list in Google Sheets fixes that. One sheet holds every book you want to read, where it came from and how long it will take, and it can even pick your next read for you.

Quick answer: A TBR spreadsheet is a Google Sheet that lists the books you plan to read, with columns for title, author, pages, format, source and priority. Sort by priority or length to choose your next book, or use a random picker formula when you can’t decide. The Book Tracker includes a TBR list with estimated reading hours and a TBR Jar that picks a book for you.

What does TBR mean?

TBR stands for “to be read.” Your TBR is every book you own or plan to read but haven’t started yet. Some readers keep one long list. Others split it into books they own and a wishlist of books they want to buy.

The columns every TBR list needs

Keep it simple. A long, complicated TBR is just another pile. These columns cover almost everything:

  • Title and author. The basics.

  • Pages. Lets you pick a short read when you need a quick win.

  • Format. Physical, ebook, Kindle or audiobook.

  • Source. Bookshop, library, gift or a friend’s recommendation, so you remember why it’s there.

  • Priority. High, medium or low. High priority books are the ones you’ll read next.

  • Date added. Helpful for spotting books that have been waiting for years.

How to build a TBR list in Google Sheets

  1. Add your headers. Title, Author, Pages, Format, Source, Priority, Date added and Status, in columns A to H.

  2. Add dropdowns. Use Data > Data validation for Format, Source, Priority and Status.

  3. Estimate reading time. If you read about 40 pages an hour, =C2/40 shows hours per book. Change 40 to your own pace.

  4. Sort without breaking anything. Use Data > Create a filter, then sort by Priority or Pages.

  5. Pick a random book. =INDEX(FILTER(A2:A,H2:H="TBR"),RANDBETWEEN(1,COUNTIF(H2:H,"TBR"))) returns a random book from your TBR. Edit any cell to pick again.

  6. Count your pile. =COUNTIF(H2:H,"TBR") tells you how big your TBR really is.

TBR list in a Google Sheets book tracker with pages, format and source

How to actually get through your TBR

  • Read from your own shelf first. Set a simple rule, like one owned book for every new purchase.

  • Use a short list. Pick three to five books for the month from the big list. A smaller choice is easier.

  • Mix moods and lengths. Alternate a heavy book with a lighter one to avoid slumps.

  • Let books go. If something has sat on your TBR for years and no longer appeals, remove it. That’s progress too.

  • Use a wishlist for future buys. Keep books you don’t own yet in a separate wishlist so your TBR stays honest.

A ready-made TBR tracker: the Book Tracker

The Book Tracker has all of this built in. Its To Be Read tab lists your pile with pages, estimated reading hours, format and where each book came from. When you can’t choose, the TBR Jar picks your next read for you.

The Wishlist Tracker keeps books you want to buy with priority, price, release date and a buy link, and adds up the total cost. Coming soon covers count down the days until new releases. When you start a book, change its status once and the tracker, shelves and dashboard all update.

Wishlist and to-be-read tabs in the Book Tracker Google Sheets template

TBR list vs. wishlist vs. reading log

  • TBR list: Books you own or have access to and plan to read.

  • Wishlist: Books you want to buy or borrow later.

  • Reading log: Books you’ve started or finished, with dates and ratings.

Keeping all three in one connected file means a book moves from wishlist to TBR to finished without being typed again. Our guide to the Google Sheets book tracker covers the reading log side, and our reading goal tracker guide shows how to track your yearly target.

Frequently asked questions

What is a TBR spreadsheet?

It’s a spreadsheet listing the books you plan to read, usually with pages, format, source and priority so you can choose your next read quickly.

How do I randomly pick a book from my TBR in Google Sheets?

Use =INDEX(FILTER(A2:A,H2:H="TBR"),RANDBETWEEN(1,COUNTIF(H2:H,"TBR"))), where column A holds titles and column H holds the status.

How long should a TBR list be?

As long as you like, but keep a short monthly list of three to five books on top. That’s the list you actually read from.

Should I track audiobooks on my TBR?

Yes. Add a Format column. The Book Tracker supports physical books, ebooks, Kindle and audiobooks.

Can I check my TBR on my phone in a bookshop?

Yes. Open the sheet in the Google Sheets app to check your list and wishlist before you buy.

The bottom line

A TBR list in Google Sheets turns a chaotic pile into a clear plan: what you own, what you want and what to read next. Build one with the steps above, or use the Book Tracker for a TBR list, wishlist, release countdown and TBR Jar in one sheet. New here? Enter code WELCOME20 at checkout for 20% off your first order.

About

Organized Dashboard is a cozy corner for aesthetic Notion & Google Sheets templates ♡ helping you become more organized & productive.

organizeddashboard@gmail.com

Explore

About

Organized Dashboard is a cozy corner for aesthetic Notion & Google Sheets templates ♡ helping you become more organized & productive.

organizeddashboard@gmail.com

Explore

About

Organized Dashboard is a cozy corner for aesthetic Notion & Google Sheets templates ♡ helping you become more organized & productive.

organizeddashboard@gmail.com

Explore