The Mother Of All Reading Tracking Spreadsheets

Posted February 4, 2017 by Hillary in blogging / 2 Comments

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!

Powered by ConvertKit
Related Posts Plugin for WordPress, Blogger...

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!

Powered by ConvertKit
  • Oh…my God. Thank you so much for telling me about this tracker! I’ve had my own spreadsheet for a good many years and could never figure out how to keep track of THIS book is #3 of THIS series and the next book to read in the series is THIS. Finally that problem is solved!!!! Yay!!!! I was going to just download Brock’s spreadsheet and start plugging stuff in but forced myself to watch the video and LEARN about the spreadsheet before touching it so I don’t screw something up. He was very thorough in his teaching and it was a good tutorial, I just don’t have the attention span for stuff like that anymore. But I watched the entire thing and I’m glad I did because there are a lot of bells and whistles. Unfortunately, now I have to force myself to go to bed and can’t start plugging anything in until tomorrow. Will I even BE able to sleep knowing that??? Ugh.

    • hillary roberts

      I know right!!?? I searched high and low for one that I liked. I was about ready to give up but then I found this one. I have a heard time keeping track of series also. Like for comic I am on SOMETHING in Saga but no idea witch Vol LMAO I will figure it out then this spreadsheet will save me.