Book Stats Google Sheet – Download Link and Guide

GS

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!

LINK TO THE GOOGLE SHEET

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.

BooksRead Sheet
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.

Charts Sheet
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!

Stats Sheet
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!

Come and see what I am reading next, and all that jazz on Goodreads | Be my friend and chat with me on the twitter dot com

26 Comments

  1. Your sheet puts mine to shame! Mine has a measly 7 columns:

    Book – Title of the book
    Series – If its in a series, the name of the series
    Order – If its in a series what number it is and how many total (example: 5 of 10)
    Author – Author’s name
    Date Published – The year it was published
    Date Read – The month and year I finished reading it
    Alternate Title – I should probably delete this column I only have two books in here with alternate titles (can you guess what they are?!?!)

    I have 450 books on my list. It is supposed to be my full list of books I have ever read, but I only started keeping track about a year and a half ago and it was impossible to back fill everything. I know its missing a lot.

    I was a math major so I like stats and lists too 🙂 I thought my list was pretty good until I saw yours! I am not going to be copying your template because I would rather just make my own from scratch, but I will definitely be adding some of your fields so that I can track more stats 🙂

    Liked by 1 person

    1. Thank you! 🙂

      I’m guessing the alternate titled books are Harry Potter. HP is often a safe bet…

      I wouldn’t even know where to start with tracking all the books I’ve ever read. So good on you for giving that a go! 🙂

      Like

      1. Thanks 🙂 and One is Harry Potter and The Sorcerer’s Stone ( Otherwise known as Harry Potter and the Philosopher’s Stone) I think all the others have the same name in both the US and the UK. The other is The Golden Compass (Otherwise known as Northern Lights)

        I used a lot of “must read” book lists to find books I have read already, but I know I am missing a lot!

        Liked by 1 person

      2. Ah yes, the old Philosopher vs Sorcerer situation. I still can’t understand why that was changed when it was translated into American. Surely people in America know what a philosopher’s stone is?

        Liked by 1 person

  2. omg, Stark! This is super cool and THANK YOU SO MUCH for sharing this brilliant sheet. You really have thought of everything… sooo… I nabbed a cope of the sheet and I intend to spend a bit of time tomorrow to catch up with my read titles of 2018 to pop them on the sheet…
    You know, I generally dislike spreadsheets… maybe because I work wth them a lot… daily, a lot and I couldn’t imagine using one in relation to reading, but I am sure as hell excited… and being a total lazy cow, this work you’ve done is a gift! 🙂

    Liked by 1 person

    1. Thank you! 🙂

      I can see the dislike of using spreadsheets if you use them all day at work. But this is a really simple one, and I found that I just kept my other one up to date whilst I was updating Goodreads etc. It just becomes a quick one minute job. I hope you enjoy it. Let me know if you find anything broken. 🙂

      Liked by 1 person

      1. Yeah, it doesn’t really take a long time to update it next to Goodreads, etc.. so I hope I’ll keep this up now for the year- will be good to get the overall stats at the end of the year 🙂

        I have added all 10 books I have read this year this far and didn’t come across any error… (love the little notes you’ve left re reordering, etc 😀 ) and… oh yeah, I think my most troublesome area of updating the sheet will be the genre/subgenre… I can never exactly tell!!! 🙂 😀 Thanks again- this rocks!

        Liked by 1 person

    1. Same! Whenever I need to keep on top of anything, I instantly think ‘spreadsheet’. I have a google folder full of spreadsheets for different things. I’m not even ashamed. 😂🤓

      Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s