Book Tracker Google Sheets Template | Reading Journal Spreadsheet | Reading Log,
📚 BOOK TRACKER — Your Personal Reading Companion A premium Google Sheets template that turns every book you read into stats, charts, and a personal library you'll actually want to open. Made by Big Tone ✦
✨ WHAT YOU GET A beautifully designed digital workbook with 6 fully-linked tabs that update automatically as you log your reading: ⚙️ SETUP — Configure your name, reading year, annual goal, and dropdown options. Two minutes and you're off. 📖 BOOK TRACKER — The heart of the spreadsheet. Log every book with title, author, genre, format, status, pages, rating, start/finish dates, and notes. Days-to-read calculates automatically. 50 rows ready to go, with 5 sample entries to get you started. 🖼️ BOOKS GALLERY — A visual grid of every book you've logged. Auto-syncs from your tracker so you can see your year at a glance.
📅 CALENDAR — A month-by-month view showing exactly when you finished each book, with running totals and a built-in heatmap.
💫 WISHLIST — Plan your next reads with priority tags (High / Medium / Low), genres, and notes. Never lose track of a recommendation again.
📊 DASHBOARD — Live KPIs and charts: books read, pages read, average rating, goal progress, books per month, genre breakdown, and rating distribution. Updates automatically.
💡 FEATURES ✓ Smart dropdowns for Genre, Status, Format, and Rating — keeps your data clean ✓ Colour-coded statuses (Read · Currently Reading · TBR · DNF · Re-read) ✓
Auto-calculated days-to-read between start and finish dates âś“
Live charts and stats — no manual updates needed ✓
Priority colour coding on your wishlist âś“
Frozen panes so headers stay visible while you scroll ✓ Premium navy + gold design throughout ✓ 293+ working formulas — fully tested
