2024 Reading tracker Spreadsheet

So as some of you know, a couple of years ago, I created a spreadsheet and it was a HUGE success. The massive amount of emails that I received this past year of appreciation was so wonderful, knowing that I was able to create something that assisted so many readers to help track their reading. As some of you are aware, I gathered portions of these spreadsheets from various others spreadsheets but adjusted it to be compatible in a spreadsheet that works for readers in a more conducive way. (If you need it credited it, check at the bottom for those users) I also have included some of my own creations into this spreadsheet as well. The reason for this is not all spreadsheets do what I need it to do. So I decided to combine different aspects into this massive spreadsheet to work within what I needed and wanted to share what I created and adjusted for all of you as well. I have updated the spreadsheet for 2024, and fixed some bugs that I learned of just using it for these past two years. It’s much cleaner and from what I can tell it all works really well. I will say that I am glad that I was able to create this and I USE this myself, as you will be able to see when I share my yearly stats. I wasn’t sure how cohesive it would all end up being, as I combined multiple styles of spreadsheets, BUT, after using it, it worked so smoothly. I will say that some of the charts in the “details” section and “Summary” didn’t add up always if you weren’t using the individual tabbed sheets like the “Series Tracker” and the “DNF” tracker. So if you used the spreadsheet and only using the reading log, you might have noticed some factors like that. I did love using this to track my reading for the year. It just was so much fun, as this is my first year, that I was super consistent with it and to see all the graphs and charts and numbers.

If you are new to the spreadsheet, I have below all the aspects of the spreadsheet, or if you want to use it check out all the features below! Below I will have the link to the spreadsheet, as well as the link is on the “Reader Tracker Spreadsheet” page on the site which you will see on the Menu of this site.

Updated Features for 2024

Series Tracker & Series Location Tracker

This series tracker is something I have LOVED using this year. I recently found it shortly after I put out my template for 2023 so it was a bit late to put it in, but I have it in for this year. I have included both the series tracker + the location tracker. So the series tracker is a tracker you can use independently within your spreadsheet to track your series. And then for the following years so copy it into a new or existing spreadsheet for future years for tracking. I also created a location tracker. If you are anything like me, then you might have quite a few series to track. This location track is simple. Just the name of the series, the author and the location in the grid of the tracker so you can easily locate it. There is a tutorial video for Ali’s Spreadsheet who originally created it HERE that you can watch if you are unsure how to edit it. You can also change the colors to make it look more aesthetically pleasing if you like. I have below a screenshot of what mine looks like if you would like to change it.

Dashboard

So this is something I have been wanting to put in this template all year. I started using it in mine and I really love how the information was laid out a bit differently. So its up to you if you want to keep it with the other charts and just implement a mix of charts and graphs on one page to make it flow more easily. I have really loved using this. I have kept it pretty basic so that you can add graphs or charts as you want to. The graphs are based on the charts if you are unsure how it works. Its pretty self explanatory. If you want to change the colors, go to Format—Theme and there you can customize the colors however you like if you don’t currently like the colors laid out on that.

Features of the Spreadsheet

This spreadsheet contains multiple sheets and there are different uses and needs for each of them. It might seem overwhelming at first, but this is adaptable, in that just find what works for you and then you can delete what you don’t want. I personally, am OCD about my organization and find that many aspects of this spreadsheet to really work for me. There are multiple stats pages, plus 10 main sheets, and then a couple of other sheets (that I will explain the reason for below). 

Book Log 

This is definitely my favorite tab (other than the stats pages) I just love how this one is built and all the features that it has. This log calculates many different elements but you don’t have to use them all. If there is a column you don’t want to use, just delete it. This one will help you calculate your authors, series, genres, tropes, and more. It also has an added feature that I implemented from “The Book Roast” She has a rating system called “CAWPILE” and how it works is that it takes seven subcategories which you judge on a scale of 1-10 and then in this spreadsheet, it will calculate the rating for you. I have included the cheat sheet for this system, I have found it so useful in the past year in helping me calculate a more detailed and accurate rating. But I would also recommend if you are interested, to watch her video on this: 

Cawpile Rating Video

Acquisitions 

This is a page where you can track the books your purchase, get from the library, or even subscriptions. I really love this one because this is where I like to track books I purchase vs. books I read from the library. I know many like to see where they are spending money and the difference in saving money. 

Series Tracker

This is a page where you keep track of your series, and there are some stats tables to help you keep track of where you are going with your series and your progress with them. This spreadsheet also includes a table stat to help you track your series, like how many books are 1st in a series for 2, 3rd, or 4th or series you are completing throughout the year. 

DNF Tracker

I wanted to include this one because I know that many readers like to track what books they DNF, personally, I don’t DNF that much so its not one I use very much. But it does help me see how often I DNF and the reasoning behind doing it. 

ARC Tracker 

This sheet is if you read ARC’s and like to track your books and it also helps you remember and keep track of what books you need to read. This sheet is what really helped me get caught up on my NG ratio (which I recently got to 100%), Because it can be so easy to get behind and lose track of those books for review. 

Author Tracker 

This is a sheet you won’t have to do much with. Once you enter in the authors on the “Book Log” page, then it calculates all authors into this page, with only two other columns that help you keep track if they are “New To You” and “Debut”. This really helps understand your reading habits as it pertains to authors. And its also nice because it will show you the # of times you read certain authors which is good to see in watching your reading habits. 

Buddy Read Tracker 

This is one of my favorites, I have in recent years really enjoyed buddy reading books with friends and this page is super useful in helping to track these. So if you buddy read, I think you will find this one super useful in tracking them. 

New Releases 

I wanted to include this sheet because this one has HELPED me so much this year. I really like to keep track of my new releases and this is the BEST way that really has helped me track them more. 

TBR Pile 

This is a page that will seem overwhelming for some especially if you have a lot of books whether they are physical or digital, to keep track of. But I have found once you have it filled, and keep up on it as you buy books, it’s a good reminder of reading your TBR. This one I really like, I don’t have too many TBR books. I tend to read books when I first buy them (or I try to) so this helps me see where I am at and what I need to work on. 

Categories 

Now it is ESSENTIAL to understand how this sheet work. As you look in the Book Log, you will see quite a few drop-down menus, so on this page, this is where all of your menu items are locations and if you want to add or change them, you can do as many as you want. Like for example if you want to add more publishers or tropes or themes of what you are reading, you can change it. But for example, if you want to change your genres (these genres are really just for romance fiction only, but if you want to add different ones, you will have to adjust some of the stat tables through functions  (if you need help with this, just DM or email me and I can walk you through it, its fairly easy once you understand how to do it) 

Stats Sheets

This is honestly one of my favorite aspects of tracking my reading through spreadsheets, I absolutely love it so much. Its just so fun to see the various charts and grids and all the numbers is really fun to see. Now I have a few sheets for this template. We have the Summary, Monthly Stats, Details Page, and then the Graphs/Pie Charts page. I absolutely love all of these sections. 

I hope that you all find this useful and feel free to change things around, delete what you don’t want, or change the colors to suit your personal aesthetics. For example, I changed the colors to softer hues (the original base I used from Ezrah had SUPER bright colors and I don’t like those haha. 

I have below a video tutorial of old and new features if needed.

Credited Spreadsheets that I combined:

Ali (Book Hoarder)

Lizzie (Happy For Now)

Book Roast

Ezra @ I Heart Romance

Noveltea Corner

Hope you all have fun with this one here, and if you have any questions, feel free to reach out to me @myloveofromance@gmail.com