Reading Tracker Spreadsheet for Google Sheets and Excel

TBR SPREADSHEET AND READING TRACKER FOR GOOGLE SHEETS AND EXCEL

A TBR spreadsheet and reading tracker for readers with library due dates and book club nights. It turns every book into a few honest numbers: when it will actually finish, and how far ahead or behind your goal you are.
Works for physical books, ebooks and audiobooks, at your own pace, not a guess.

📊 WHAT IT DOES

✓ Library: every book in one place — status, where it came from, what it cost, when you started and finished it.
✓ Now reading: how far along each book is, and the day it will finish at the pace you actually read.
✓ Deadlines: library due dates, book club nights and review copies, with pages a day to make each one.
✓ TBR and Unread shelf: what to read next, longest-waiting first, and the shelf you already paid for.
✓ Pace and Goals: the year against your reading goal, plus a few goals of your own you can track to the finish.
✓ Spending: what reading costs you each month, and what the free books saved.
✓ Ratings and DNF: your best-rated books, and the ones you stopped, with the usual reason.

📂 WHAT'S INSIDE: 30 TABS AND 64 CHARTS

✓ Start with these: Home, Start here, Setup, Library
✓ Every day: Reading log, Now reading, Deadlines
✓ What next: TBR, Unread shelf, Series, Have I read it, Spending
✓ The year: Pace, Goals, Challenge, Streak, This month, Months, Year in books
✓ What you like: Authors, Genres, Ratings, Score card, DNF, Recommenders
✓ Keeping it going: Quotes, Check-in, Catch-up, Read me, Free gift

📝 HOW IT WORKS

1. Open the PDF and click the link to make your own copy in Google Sheets. Or open the Excel file.
2. On Start here, fill in the shaded cells: your name, your books-a-year goal, pages a year and minutes a day.
3. Add each book once on Library, then add a short line on Reading log after every session.
4. Everything else fills in by itself. Home shows what's finished this year, what you're reading now and your streak.

📥 WHAT YOU GET

✓ Google Sheets version (the link is in the PDF)
✓ Excel version (.xlsx) for desktop Excel on Windows or Mac
✓ A filled example to look around, and a blank copy for your own data
✓ A PDF with the links and the first steps
✓ A video guide for this planner (the link is in the PDF)

💻 GOOD TO KNOW

✓ Works with a free Google account. No add-ons, no subscription, no bank connection.
✓ Type only in the shaded cells. Formulas are protected, so you can't break them by accident.
✓ Best on a computer. The Google Sheets app works for quick entries on your phone.
✓ Amounts on Spending show in dollars. The formulas work the same in any currency.
✓ The Excel version may look slightly different from the photos (fonts, colors, charts). The photos show Google Sheets.
✓ English only. Not made for Apple Numbers.
✓ Free updates for life.

This is a digital download. Nothing will be shipped. Because it is a digital file, it can't be returned, but if anything is unclear, message me and I will help you set it up.