Since I started using the Reading Tracking Spreadsheet, my reading QUALITY has improved by 43%!

I built the Rock Your Reading Tracking Spreadsheet to help:

• Enable you to monitor your reading stats in real time…because it automatically compiles your stats throughout the year.
• Track how successful different types of books are for you (in real time), helping you better understand your reading taste...and pick books that better match your taste.
• Track your best and worst recommendation sources.

The Rock Your Reading Tracking Spreadsheet is ideal for bookworms that read a high volume of books each year.

The tracker is ONLY AVAILABLE to Sarah’s Bookshelves Live “Superstars” Patrons ($7 / month)! In addition to the Tracker, you’ll get monthly episodes of the Double Booked podcast series, our annual Best of the Backlist Reading Guide, and 2 other bonus podcast episodes per month (plus more). Sign up to be a patron here.

How the Rock Your Reading Tracking Spreadsheet will help you

• Track key elements bookworms like to keep tabs on (including your reading goals, books and pages read and listened to, diversity, ratings, genre, format, mood, pace, and my personal favorite, reading success rate). They’re built right into the spreadsheet…with Summary Charts that automatically populate as you enter the books you’ve read!

 

• Automatically (for Excel Version 2021 and later) calculates your Best and Worst Book Recommendation Sources and publishers..and use them to pick better books throughout the year.
  • Plus, track people who DISLIKE the same books as you do.
  • And, track the recommendation sources for books you do not finish (DNF’s)…because knowing who gives you bad recommendations is just as important as knowing who gives you great ones!
  • I have a version with a manual Recommendation Sources chart for those who would like to use the Tracker in Google Sheets or an Excel Version earlier than 2021).

 

• Keep your To Be Read (TBR) list and reading tracker in one place.
• Compare your current stats to last year’s stats.
• Customize the spreadsheet for your needs. Delete items you don’t care about tracking. Add columns for anything you’d like to track that I haven’t included. 

Key Improvements to this year’s Rock Your Reading tracking spreadsheet

• Entirely automated New York Times’ Best Books of the 21st Century tracking section and Dashboard stats.
• A “Best Book of the Year Contender?” column.
• Column to add a second author.
• A “Literary Awards Detail” column to track Short List, Long List, Winner, etc.
• A “Book Cost” column and Dashboard stat.
• Ability to input multiple author ethnicities.
• A “Custom Publisher” column and Dashboard chart (i.e. to track publishers that aren’t on my dropdown menu).
• Space to automatically track up to 8 recommendation sources and 3 “dislike sources” per book.

• Stats automatically tracked: 
  • Books needed to reach your reading goal (and average books per week to achieve reading goal)
  • % successful books attempted and read (i.e. the reading quality stat)
  • Books and pages read, and audiobook minutes listened to
  • More Basic Stats: Backlist, Re-Reads, Series, Backlist, Debuts / New-to-Me / Repeat Authors.
  • Most / Least Successful Publishers
  • Most / Least Successful Book Recommendation Sources (for those using Excel 2021 or later)
  • Celebrity Book Clubs and Literary Awards
  • Star ratings
  • Charts: Genre (Fiction / Nonfiction and Detailed Genre), Audience, Format, Books per Month, Book Source, Book Length, Audiobook Length, Mood, Pace, Dislikable Characters, Books by Season, Celebrity Book Clubs, Literary Awards
  • Diversity: Author Gender, BIPOC Authors & Characters, LGBTQ Authors & Characters, Disabled Authors & Characters, Neurodivergent Authors & Characters, Author Race Breakout, Diverse Books %, Geographic Diversity
  • DNFs: number, % of overall reading, genre, backlist, book source, DNF’s by month

New This Year: The LITE Tracker

• The LITE Tracker is a simplified version for readers who want to track basic details about the books they read or DNF.
• Unlike the “big” Rock Your Reading Tracker, the LITE version does not include robust stats for analyzing your reading taste.
• The LITE Tracker is available in Google Sheets.
• When you become a Superstars patron, you get access to BOTH the “big” Rock Your Reading Tracker and the LITE Tracker.

Support

Chrissie (my Assistant) or I am available at sarahsbookshelves@gmail.com to answer any questions before and/or after your purchase and provide support using the tracker. 

Supported Programs:

• The Tracker is an Excel spreadsheet.
• The Tracker WILL NOT work on an iPad or tablet.
• The Tracker IS COMPATIBLE with Google Sheets (see Google Sheets specific details on the “Instructions” tab of the Tracker).
• The Tracker IS COMPATIBLE with Numbers. To open the Tracker in Numbers, right click on the tracker file > Choose “Open with…” > Choose Numbers. You’ll get a warning about anything in the Excel file that’s not compatible with Numbers (ex: unconditional formatting not supported, but I’ve tested the affected formulas and they still work.)

Become a Superstars Patron to Get the Tracker Here…

Get the Reading Tracker!

Testimonials

Kristen B.:

I have tried reading journals (both pre-made and bullet journal) in the past, and I always seem to lose interest or get behind and have tons of books to log. With the tracker, that hasn’t happened because I’m DYING to see how my latest book will effect the charts and graphs. The tracker has been especially helpful as I try to branch out with different genres, and in helping diversify my books. A quick glance at the data tells me how I’m doing on this, and how to adjust.

Tessa:

I like being able to see how my reading this year versus last year compare in terms of male vs female, debuts reds, and especially with the number of BIPOC authors I’ve read. I’ve been making a concerted effort to read more books by BIPOC authors and this helps me keep track.

Heidi G.:

I love that everything is all together and so easy to use! Having all of my reading information so visual has improved my reading more than I can explain. […] I have been tracking things that I didn’t know I even cared about – like publishers – but I’m really getting interested in that part of my reading life.

Heather B.:

I wanted to have a more genre-diverse reading life instead of just reading all historical fiction and literary fiction. I loved seeing my pie graph get colorful! I also realized I wasn’t checking for e-book deals before buying the hardcover. So it has saved me money and broadened my reading horizons!