The 2022 Rock Your Reading Tracking Spreadsheet

2022 Rock Your Reading Tracking Spreadsheet


Since I started using the Reading Tracking Spreadsheet, my reading QUALITY has improved 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.

For the first time, I’m offering the tracker FOR FREE to Sarah’s Bookshelves Live “Superstars” Patrons ($7 / month)! Sign up to be a patron here. In addition to the Tracker, you’ll get monthly episodes of the Double Booked podcast series, a supplement to my annual Summer Reading Guide, and 2 other bonus podcast episodes per month (plus more).

How the Rock Your Reading Tracking Spreadsheet will help you

For $14.99 or FREE if you’re a Superstars Patron, you’ll be able to:

  • 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!

2022 Reading Tracking Spreadsheet


  • Easily find 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!

2022 Reading Tracking Spreadsheet

  • 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. Email me at if you’d like me to customize dropdown menus, summary charts, etc for your specific needs.

And, possibly the best part…no more tallying up your numbers and manually creating Excel pie charts at the end of the year! It’s all done for you on the Summary Charts tab!

Key Improvements to this year’s tracking spreadsheet

  • THE BIGGEST UPDATE: Added “% Successful Stats” for ALL categories to help you better understand your reading taste.

2022 Reading Tracking Spreadsheet

  • Added Reading Taste Section (Mood, Pace, Dislikable Characters).
  • Expanded Diversity stats (Diverse Author vs. Diverse Characters Breakdown, LGBTQ Author / Characters Stat).
  • Divided out Genre from Audience.
  • Added column where you can compare your ratings to Goodreads ratings.
  • 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.
    • Publishers
    • Star ratings
    • Charts: Genre (Fiction / Nonfiction and Detailed Genre), Audience, Format, Books per Month, Book Source, Book Length, Audiobook Length, Mood, Pace, Dislikable Characters
    • Diversity (expanded in 2022): Author Gender, BIPOC Authors, BIPOC Characters, LGBTQ Authors, LGBTQ Characters, Author Race Breakout, Diverse Books %, Geographic Diversity
    • DNFs: number, % of overall reading, genre, backlist, book source, DNF’s by month


I’m available at to answer any questions before and/or after your purchase and provide support using the tracker. I’m also happy to help you customize (within reason) the tracker to meet your needs.

Supported Programs:

  • The Tracker is an Excel spreadsheet.
  • The Tracker WILL NOT work on an iPad or tablet.
  • 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.)
  • The Tracker IS COMPATIBLE with Google Sheets. Just upload it to your Google Drive and choose “Open with Google Sheets” when you open the document from your Drive.

Get the Tracker for Free!

  • Sarahs’ Bookshelves Live “Superstars” Patrons Only – sign up to be a patron here!

One More Special Discount…

  • Returning Customers – If you bought last year’s tracker, I’m offering a 20% discount on your purchase of the new and improved 2022 version. Check your email for the discount code! 

reading tracking spreadsheet

Purchase Here…


Kristen B.:

I had a personalization request and I was amazed at the speed with which you answered that request and with how soon I had the new tracker in my inbox. That isn’t always the case and definitely was not what I expected, so I wanted to give major kudos!

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.


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 POC authors I’ve read. I’ve been making a concerted effort to read more books by POC 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!

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.


  1. Cindy wrote:

    Is there a way to buy the tracker without becoming a patron member?

    Posted 12.3.21 Reply
    • Sarah Dickinson wrote:

      Yes – there is a “Purchase” button on this blog post and you can purchase the Tracker for $14.99 without becoming a Patron.

      Posted 12.3.21 Reply

Get Weekly Email Updates!

Join our mailing list to receive all new blog posts in one weekly email. Plus, news of special updates and offers!

You have Successfully Subscribed!