Back when I did my Big Ass Book Survey, I ran into a problem. I had only kept up with most of the books on Goodreads. Even there I lacked data. All I kept track of was the fact that I read the book. There was no data on if the author was a POC or if the book was about a marginalized person or any other data that I wanted to know. It is sad that in the past I didn’t care about stuff like that but Trump winning this election was like a slap in the face that we still have a hell of a long way to go and I want to be able to do my part in helping marginalized communities get their voices heard. One way to do that as a book blogger is to but and also to read and talk about books by authors that would normally not get any attention. And plus, I just wanted some hard data to see what I read how much of a genre I have read and all of that. I was even going to try and make beautiful charts but alas..no data at ALL.ZILCH..
As I can’t make an excel spreadsheet to save my life (I spent a whole semester of stats class in college trying to get the professor to notice me instead of learning how to make spreadsheets) I had to go looking at what other people had come up with. I quickly noticed that some y’all must have paid close attention to your stats professor as some spreadsheets were too complicated for me even to figure out what I was looking at. Some did not have EVERYTHING that I wanted to be tracked. I also wanted it to be somewhat reasonable to figure out how to add stuff to it if need be.
I learned that there is a LOT of reading tracking spreadsheets out there. I must have looked through at least 20, but none of them felt right. I also wanted to be able to track what books I BOUGHT, but I reasoned that if need be, I could have two separate spreadsheets.
I spent the next few days hunting down and pouring over spreadsheet after spreadsheet. Then finally I came to this booktuber site on Youtube, and he was showing the people that watched the video his spreadsheet. I was enthralled with the video, so I downloaded his spreadsheet, and it was as perfect as a spreadsheet could get. It covers everything. You can track books that you bought, books that you read and get this finally a way to track those pesky DNF’s If you are anything like me you want a place to track that you read SOME of the books but that you did not finish it for whatever reason.AND….ARE YOU READY…YOU CAN MARK A BOOK AS RETURNED UNREAD FROM THE LIBRARY! I have never in my life seen a spreadsheet do that. I have tried various things to mark them as unread. Last year I cobbled together a shelf on Goodreads but this spreadsheet sooooo much better. And for the first time, I can count my rereads without it messing up my stats. On Goodreads, you can’t even make how many times you have read a book, and I haven’t seen it on other spreadsheets. I am a huge re-reader, so this is important to me. I can still count the book in my totals for the year, but it is also marked clearly as a reread on the spreadsheet. It has a ton of other features and best of all…..IT IS FREEEEEE!!!
You can download the spreadsheet here
Join my Newsletter
Sign up to get a copy of the tools I use to run my business and a free email course on book blogging!