2021 Reading Tracker Spreadsheet
The 2022 reading tracker is now available here!
2022 Reading Tracker Spreadsheet!
Hi friends! Can you believe 2020 is almost over? I am super excited for 2021 and all of the reading I’m going to do. In 2020 I started using a reading spreadsheet to track my reading and it really worked well for me. My handwriting is terrible, so I don’t enjoy journaling and I always look for electronic alternatives. So for 2021, I decided to make my own spreadsheet and share it with you! Check out my 2021 Reading Tracker Spreadsheet below!
{You might also like – These Books Will Self Destruct in 12 Months}
2o21 Reading Tracker Spreadsheet – How do I get it?
You can download the 2021 Read Better Reading Tracker here!
This is super important, you have to MAKE A COPY of the spreadsheet in order to use it. Simply go to file>make a copy and there you go! You can now edit the copy you’ve made! Or if you prefer to use Excel, you can download a copy straight to your computer.
This spreadsheet is completely free!
You can edit this spreadsheet to your own needs, but PLEASE do not use my spreadsheet as a base to create your own downloadable.
How does it work?
The spreadsheet contains 8 different sheets, each with a different function. I will talk you through all of these sheets, and show you some screenshots from the 2021 Reading Tracker Spreadsheet!
The “Books Read” Sheet
The first sheet you’ll find is the Books Read sheet. This is where you can enter all of the books you’ve read during the year. There are multiple dropdown menus you can use, as well as a “review” column for book bloggers! If you’re not a book blogger, you can simply delete the column.
The “Series Tracker” Sheet
This sheet is one of my favourite sheets. I like to track the series that I read to make sure I finish all of them. I am a serial series starter, but I never finish them. This sheet allows you to fill in all of your series and track which books you’ve read and which books you haven’t read.
Note: On the categories sheet, in column M, there is a note for you to read on how the “status” dropdown menu works.
The “ARC Tracker” Sheet
This sheet is also mainly for book bloggers, so it can be deleted if it is not needed. The ARC tracker basically allows you to track all of your ARCs, including eARCs.
The “Read Better Challenge” Sheet
As you all know, Mouse That Reads and I are doing a reading challenge for 2021 called The Read Better Challenge. So I’ve included a sheet where you can track all of the books you read for the challenge! I even filled in the first prompt for you! Check out our Twitter for a monthly prompt reveal!
The “Readathon Tracker” Sheet
We all love a good readathon, so I’ve made a sheet for you to track your readathons! It’s pretty straightforward and can be removed if you don’t want to use it.
The “Hauls and Unhauls” Sheet
Pretty straightforward again, this is a sheet for you to track all the books you buy, and the books you get rid of. I find that I need to track the books I buy so that I don’t buy too many. It’s always good to track these kinds of things to keep addictions under control.
The “Stats” Sheet
This is by far my favourite sheet! This sheet tracks all of your stats (well most of them). The sheet tracks author gender, author status, genre, publication year, age range, format, source, rating, series, and month read.
Note: These stats update automatically. If you tamper with one of the corresponding columns on the “Books Read” sheet, the stats might stop working. I’ll explain how to add your own options next.
The “Categories” Sheet
The Categories sheet is where all of the options for the dropdown menus are stored. I made it so that you can add some of your own options without fuss. For example, if you would like to add a publisher, you can simply type it into the next open space, and the sheet will update it automatically. The stats will also update automatically.
If you run out of space, simply drag the rows down further.
If you need any more help, or if you want to suggest something, you can join our Discord and head to the Reading Tracker Chat, or DM me on Twitter on Instagram.
Enjoy!
Pin This!
I have been tracking my reading the old fashioned way for years, with pen and paper. I have to to keep up with my TBR list. Thanks for sharing your graphs.
Wow, what an organized and clever approach. Thanks for sharing!!
This is awesome. Thanks for sharing.