The Kerensa 2025 Reading Spreadsheet

Happy New Year! 

At the end of the year, one of the things I start doing is preparing my reading tracker spreadsheet for the new year. I have become a spreadsheet fiend over the last few years, mostly because of reading tracking (but have I also found excuses to work more spreadsheets into my job? Well, yes, yes I have). 

Near the end of 2023, one of my friends asked if she could use my reading tracking spreadsheet to start tracking her books as well, and I said, "Of course!" and then frantically began checking over the new spreadsheet I was making for 2024 to make sure it wasn't too esoteric and tailored to me specifically.

Now it's a new year, so I made a new spreadsheet, and now that someone else has used my spreadsheet for a year with no major mishaps I thought it could be fun to share it more broadly. So if you're in the market for a reading tracker spreadsheet, please feel free to try this one!

Additionally, I thought I would do a quick-ish bullet point list explaining the different pages of the spreadsheet, in case they're not all 100% intuitive (I'm erring on the side of slightly over-explaining).

• Books Read: The main page of the spreadsheet, where you can record all the books you read in 2025! This page mostly requires manual entry, but there are a few self-populating columns under the "Reading averages" header on the right. These will fill themselves out.
• I've added some placeholder titles onto the page so that you can see what the graphs will start to look like, but you can delete those from this page before you start adding your own books, and everything should work fine!
  
• Stats: The main stats page of the spreadsheet! This page provides info for a lot of the cool graphs on the "Graphs" page. It's mostly self-populating, but you may want to update the reading goal to whatever your personal reading goal is (I have it set to 75 because that's the goal I like to aim for these days). 
• Credits info: This page was heavily inspired by the incredible and very exhaustive table stats that Bookriot includes in their yearly reading tracker spreadsheet. I don't track as exhaustively as they do, but if you've used their spreadsheet before, the basic structure of this page will look similar!
  
• Monthly Stats: Another stats page, also self-populating. The purpose of this page is to show how your reading changes month to month. It also contributes data for some of the graphs. If you're not interested in looking at this graph, you can hide it, but I wouldn't recommend deleting it, because...you'll break the graphs.
  
• Graphs: The GRAPHS PAGE! It's a little bit self explanatory, because like...graphs! But this is where you can see visual representations of your reading year and reading data. This one also shouldn't need any input from you - as you fill out your books read, this one should fill out as well. 

 

• Daily Reading Tracker: An optional page where you can track how many days you read during each month! I have it set up with checkboxes, but in theory, you could get rid of the check boxes and put the exact number of pages you read, if you want. I'm personally not that good at tracking my reading so closely, so I stick to checkboxes. Scroll down a little to see some data about your monthly averages, including days read, average pages per day, average book length, and so on.
• Reading Calendar: Another optional page where you can visually track which books you were reading at different times of the month. I was inspired to make this page by Storygraph's recent addition of a monthly reading calendar in the monthly wrap-up. Unfortunately, unlike Storygraph's version, this one is totally manual. I like to use this sheet like it's a planner page. Scroll all the way to the bottom for an example of how I like to fill it out - it's a little hard to explain without just demonstrating.
• Library Loans: A page to track your library loans and how much you saved by using your libraries! This one has quite a bit of manual entry again, but seeing the number rack up is worth it in my opinion (Plus you can always copy and paste from the books read page). Filling out the date borrowed/date returned columns is optional and up to personal preference. I originally made a version of this page to try and track how many books I actually read out of everything I check out from the library, but in truth I find it kind of troublesome to keep up with. Feel free to either track all of your loans or just the ones you read. It's up to you.
• Yearly Data: This page is also optional, but it's fun if you like comparing your reading over multiple years! Basically I used Goodreads to look up my books and pages read over the months of previous years and added them into the spreadsheet manually, and then created a graph that compares those numbers, month by month! It's very optional and the graph is definitely a bit messy, but I personally like it a lot.
• Previous Years: This one sort of goes along with the Yearly Data page and is also very optional. I have been tracking my reading through Goodreads and personal spreadsheets since 2021, so I kind of just copy and paste all the necessary data from my spreadsheets into this list. It is also possible to export your Goodreads library and copy the relevant columns, but the downside to that is if you've read a book multiple times, it will still only show up once on your export file. It's up to you whether or not that matters to you. If you DO decide to fill out this page, then the yearly "average rating" data on the Yearly Data page should auto-populate. So that's fun! 
• Categories: This is just a page for the dropdowns that appear on some pages of the spreadsheet. You can use it to edit categories, if you really want to, but the dropdowns might not auto-update, so watch out for that. You can also hide this page.

Okay, and now for the actual link to the spreadsheet.

Well. Links, plural. I may have gone a little off the deep end? I like to revamp the colorscheme I use from year to year, and this year I had trouble deciding between different options. So I may or may not have made 6 different spreadsheets, with 6 different colorschemes. 

I've included screenshots below so that you can get a bit of a sense of the vibe of each of them before you follow the links.

 

1. The Raspberry Latte version of the spreadsheet

2. The 70s Fun version of the spreadsheet 

3. The Frog Green version of the spreadsheet

4. The Sunset Purple version

5. The Barbie Pink version

6. The Cranberry Red version

So there you go! These are my beloved spreadsheets...If you use them, I hope you enjoy them and that they give you some fun data about your 2025 reading.