I have loved tracking my reading and books with this spreadsheet this year. I discovered the tracker on Smart Bitches, Trashy Books near the end of last year and fell in love with it! It suited my needs better than most of the trackers I’ve come across and their post was so helpful for someone like me who knows feck all about using spreadsheets. Thanks to them, I figured out how to edit their tracker to make it really work for me and eventually, after some tinkering around, I figured out how to prettify it as well.
Please check out their post on how to do these things. I wish I could explain it all but I am very much a novice at this stuff and probably wouldn’t do it right.
Since I got my 2020 spreadsheet looking just how I liked I made a copy of it for 2021 and decided to share it with you all. The screenshots below show you what I entered and how the data was used for the graphs. You can change all of these things for your own spreadsheet though and the Smart Bitches, Trashy Books post can help you with this.
I’m such a nerd for all of those graphs and pie charts. I freaking love ’em! Once December 31st passes I will be printing my spreadsheet on tea-stained paper and adding it to my 2020 reading journal. Click the button below to get a blank copy of this spreadsheet for 2021. Be sure to create a copy of the spreadsheet so you can add your own data.
*Note: there was a mistake in the first version of this spreadsheet I released (September was missing) but this has since been fixed.
The spread sheet is set to view only so you must make a copy to use as your own.
Thank you so much to Smart Bitches, Trashy Books for creating and sharing such an amazing spreadsheet 🧡🧡
Don’t forget to share this post with your friends using the Sharing Buttons below 🧡
Where to Find Me
This is really cool! However, September is missing!
LikeLiked by 1 person
I did not notice that!! Thank you so much for pointing it out
LikeLike
Wow this is organised. I have spreadsheets for lots of things but never reading, I like the idea of tracking your thoughts and ideas about books. I’ve got your spreadsheet and I’ll try and keep up with it but I’m not very good at this sort of thing!
LikeLiked by 1 person
I usually update mine when I think of it. There’s no need to put pressure on yourself when tracking your reading. It should be for you and you should enjoy it 🙂
LikeLike
Thank you for sharing this ! I am going to try to use it this year.
LikeLiked by 1 person
You’re welcome!! I’m so glad you like it. Thanks for using it 🙂
LikeLike
I love spreadsheets and use them all the time for my accounts and writing. This has given me a great idea to track my reading now too!
LikeLiked by 1 person
Yay!! Tracking is so satisfying I think!
LikeLiked by 1 person
Thanks for sharing
LikeLiked by 1 person
Oooh I love your spreadsheet!! How I finally have more than 24 hours off in a go I’m going to be taking a look at my 2020 spreadsheet and seeing how I want to play with it for 2021!
LikeLiked by 1 person
This spreadsheet is really cool!! Also it’s a great idea to print it out and add it to your reading journal. I’ve mainly been relying on goodreads to monitor my reading stats and all that but this looks like an awesome alternative.
LikeLiked by 1 person
I use Goodreads too. I love how it recommends books based on what you’ve read
LikeLiked by 1 person
Ooh yes that’s a really helpful feature.
LikeLiked by 1 person