2027 Reading Journal & Series Tracker – Book Tracker Spreadsheet (Excel + Google Sheets) with TBR Jar, Stats Dashboard + Printable Reading Journal Pages

Reading a lot of series? Keep track of where you are in every one, let a jar pick your next read, and see your whole reading year in one dashboard.

The tracker spreadsheet (Excel + Google Sheets)

• Library: log up to 300 books with author, series and book number, genre, format, pages, dates, a half-star rating, a spice level, mood and two tropes. Days to read are worked out for you.
• Series tracker: type each series once. See how many you've read, your progress, which book is next and whether you're in progress, caught up or complete.
• TBR jar: every book on your TBR goes in the jar. Filter by genre, mood or format, type a number and the jar picks your next read (with a runner-up).
• Monthly wrap-up: books, pages, average rating, audiobooks, series books and your top-rated book for every month, a goal pace check and a chart.
• Stats + dashboard: goal progress, pages read, average rating, longest book, most-read author, and your top genres, tropes and moods.
• Blank file plus a filled-in example so you can see it working. Edit the drop-down lists to add your own genres and tropes.

15 printable pages (US Letter + A4)

• 2027 goals with 12 reading challenge ideas and a 52-book tracker
• A 100-book bookshelf to color in as you read
• A TBR jar page and jar slips to cut out
• Series tracker (six series per page) and a series deep dive
• Full book review page and mini reviews
• Trope and mood tracker, monthly wrap-up, reading log
• DNF and wish list, a year-in-books page and a favorite quotes page

Good to know

• Works in Excel (Windows, Mac, web), Google Sheets (File → Import) and LibreOffice. No macros, no add-ons, no sign-ups.
• Print at home, or use the PDFs in a note-taking app.
• Undated, so you can start any month. Instant digital download. Nothing is shipped.

License: personal use. Please don't resell or share the files.

Refunds: because this is a digital download, sales are final. If a file won't open or something is broken, contact me through the link in your receipt and I'll fix it or refund you.