Welcome to something new that I have been working on for quite a while now, and this has been something that I have been wanting to share. As book lovers, its always important and it can be FUN too, to track what we read, to accomplish our reading/bookish goals, and see the progress that we make in our reading. As a book blogger, I have come to appreciate what tracking books and blog goals can be in a spreadsheet. And there are so many options out there for us bookish lovers. But I will admit that many of them don’t have what I need, and so I thought I would combine aspects of all the various spreadsheets that I like to bring together something that is more extensive on the tracking. This is something that I have found very useful and I wanted to create something that would be adaptive to your needs. Now the base of this spreadsheet is off of the spreadsheet template Ezra @ I Heart Romance shared last year (which the original base was from NovelTea plus other aspects of spreadsheets from Brock and Ali’s templates), but I added some things and made some tweaks here and there to create something more expansive. I hope you all enjoy it and find it useful for you!
Download The Template
All you need to do is select the button here below, to send you to the file on Google Sheets. Now, this file is protected to make sure it’s available for everyone to use. So if you are new to this, all you need to do is go to File>>>then Save As Copy. And then its yours to use and adjust and start tracking all of your bookish stuff.
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).
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:
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.
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.
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.
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.
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.
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.
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.
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)
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!