2023 Updated Reading Tracker Spreadsheet

So as some of you know, last year 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. I have updated the spreadsheet for 2023, and fixed some bugs that I learned of just using it for a year. Its 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.

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. 

Also if you would like be to do a video and explain this spreadsheet in-depth and full detail, let me know in the comments, and if I get enough requests, I will definitely do so here. 

Hope you all have fun with this one here, and if you have any questions, feel free to reach out to me!