Last year I really enjoyed tracking the books I read omg NEEEEEEERRRRRDDDDD! Goodreads is great for tracking basic info such as books read, page count etc. But ya see, I’m a Senior Business Intelligence Officer during the day,
and a crime fighting, shape shifting, wolfman superhero at night which sounds mighty fancy doesn’t it? Well, it’s not. It means I sit in a room looking at spreadsheets, inspection and public health reports all day. It also means that my mind works well with stats, charts, target projection and attainment. This mindset leaks through into my love of books and reading. Which means I wanted to track more than just what Goodreads offers. And what better way to do this than with a nice little simple spreadsheet?! There is no better way. It was a rhetorical question. Stop trying to answer me. La la la I’m not listening.
Last year I used a spreadsheet that was good, but it had a lot of things in it that I didn’t use. So this year I decided to create my own. It has taken me a while to get around to it, because I’m supes busy with really important things like playing vidya games. I know how to prioritise life. But last night I sat at my PC and decided to get it done. A couple of hours later and here it is. Anyone is welcome to use this. You can change it and do whatever you like with it, just don’t come running to me when it breaks! But if you find a broken link or errors in formulas, let me know. I will update this post with any amendments etc.
Hey ho, let’s go!
File – Make a Copy – save a copy in your own drive. You could download this as an excel spreadsheet, but I haven’t tested to see if it converts well, because, ew – Microsoft Office. This isn’t 2011.
This is where you enter all the info on the books you read. It’s pretty self explanatory, but for those who want a step by step guide – I am here to please. wink wink, nudge nudge, say no more
Title – The title of the book.
Author – The Author(s) of the book.
Author Gender – I like to track the genders of the authors I am reading so I can try and read a balance throughout the year. Enter the gender of the author(s) here.
Author Country – The country of which your author comes from.
Protagonist Gender – The gender of your protagonist. If your story has a group of protags, you can enter ‘ensemble’ here.
Category / Type – Is your book a comic, a novel, a short story collection? Enter that info here.
Age Group – Sometimes it is difficult to decide on this one. But do your best. Or don’t, whatevs. It’s your sheet now.
Genre – Occasionally I read things other than Fantasy. Maybe you do too?
Sub Genre – But what kind of Fantasy? Of course, those with witches.
Physical / Digital – Did it flap in the wind or glow in the night?
Format – Bit like above, but… I got nothing. It’s self-explanatory. If you select Audiobook, it will highlight yellow to remind you to complete the next two columns.
Narrator – For use with audiobooks. Who read the book to you? Was it Stephen Fry? Or Neil Gaiman? Or someone else?
Hours – For use with audiobooks. How long was it? If you read at more than 1x speed, put the full amount of hours in here, your total hours will be calculated on the charts sheet.
No of Pages – How many pages does it have?
Year Published – What year was it published in? Is this not due to be published until 2019? That’s ok, you can put that.
Publisher – Who published it?
Acquired – How did you get it? Was it second hand? A gift from someone? Did you buy it new?
Acquired From – When you got it, where did you get it from?
Read Status – Was this a new read? A re-read? DNF’d it – bummer! I tend not to record DNFs on the spreadsheet, it skews my numbers. But it is there for if you want to use it.
Date Started – What date did you start reading this? This is a sheet put together by an English man. That means dates are entered in the correct way as follows – DD/MM/YYYY. You know, in the logical way.
Date Finished – What date did you finish reading this? This date is vital – no other stats will count if this cell is not completed. Again, this is a sheet put together by an English man. That means dates are entered in the correct way as follows – DD/MM/YYYY. You know, in the logical way.
Reviewed – Have you reviewed it? Do you plan to? Did you update Goodreads without posting a blog review?
Star Rating – I’ve been super nice and put quarter stars in this. I only use full stars because THAT’S HOW RATINGS WORK! But the quarter stars are there for if you’re a hippy kind that uses them. 🙂
Diversity? – I like to track whether the books I am reading contain an element of diversity. This column is a simple yes or no for any kind of diversity. The next few columns help break that down a little. Again, they are a simple yes/no answer. GSD refers to Gender and Sexual Diversity. Ain’t noone got time for LGBTQIAPAHSBIGLKDLDKBHSVALADIBHSVK.
These are your charts, full of your stats. Most people seem to like pie charts, because, everyone likes pie. But I find it easier to work with bar graphs, because I choose not to fit in with society. So I included them both!
You only need to enter data in the yellow boxes. They are:
Cell F2 – How many books do you want to read this year?
Cell F3 – How many pages do you want to read this year?
Cell AD16 – If you listen to audiobooks, at what speed? I listen to them at 1.5x.
That’s it, you do not need to change anything else on this sheet. But look at all those fancy tables full of your stats!
Drop Down Ref Sheet
This is where you can add new options for your drop down lists on the BooksRead sheet. DO NOT REORDER OR SORT THE LISTS! I know we all love a list sorted in alphabetical order, but sorting the lists will break everything… EVERYTHING! The world will collapse in on itself, and it will all be your fault. Think how bad you will feel. No one will get to see the end of Game of Thrones!! Don’t be that guy. Just continue adding new options next in line. You can add as many as you want, up to (but not including) the grey box.
And that’s it. That’s the google sheet. I hope you like it if you decide to use it. Until next time, Peace and Love!