Guys! Guuuuuysss! Guess what I just found?!?!?! You can export your books from Goodreads into an excel file!!!!
I know that might not seem super exciting , but it means that I can easily use excel to come up with reading stats!!!!
I know, I’m a nerd, deal with it!
Basic Stats:
- Books Read: 475
- Pages Read: 137,331
I only started tracking books in Goodreads in late 2016. I went back and added as many books as I could, but I am sure I am missing a lot. Obviously these are only stats on the books I have entered into Goodreads.
Stats Based on Dates:
How many books that I read that were published in each century
How many books I read every year. Note – I didn’t start keeping track until late 2016 so most books I don’t know when I read them.
Stats based on Publisher
How many books I have read that were published by each company.
Stats based on Ratings
Of the books I rated on goodreads, what rating I gave them.
The Average goodread ratings of the books I have read.
Stats Based on Titles
The words that appear most in the titles of the books I have read. I didn’t count small words like “The” or “a”
Stats Based on Series
How many books I have read that were part of a series vs stand alone.
Of the books that are in a series, how many were the first book in the series, or the second book in the series, etc.
That was fun! I love numbers ❤ Haha I was a math major after all. Do you keep stats of the books you have read? What are your numbers like?
That’s super cool! I’ll have to check it out! Thanks for sharing.
LikeLiked by 1 person
Thanks 😀
LikeLike
Oh I love this because I’m a stats nerd. You’d think I actually liked numbers, but only when they’re stats:)
LikeLiked by 1 person
I was a math major haha so I like numbers! I like stats like this but I hated probability and statistics.
LikeLiked by 1 person
Oh I like to play with numbers but was a history major:)
LikeLiked by 1 person
I am happy for you stats nerds, but not a biggie for me.
LikeLiked by 1 person
😀 haha thanks! And to each their own 😀
LikeLiked by 1 person
Ooooooohhhhhh
🤓🤓🤓🤓
I can’t wait to try this!!!
😊😊😊
LikeLiked by 1 person
🤓 Good Luck 🤓
LikeLiked by 1 person
Thanks for the tip Brittany!!!!
LikeLiked by 1 person
You are welcome! 🤓
LikeLike
This was awesome I will have to see what mine is!
LikeLiked by 1 person
🤓 Thanks!! 😀
LikeLike
Love it!
LikeLiked by 1 person
Thanks 😀
LikeLiked by 1 person
Yes, I love reading stats! I knew you could export your Goodreads books into an excel file, but it’s never occurred to me to make charts using the data, this is great!
LikeLiked by 1 person
😀 me too! Reading Stats are the best. It was the first thing that came to mind once I found you could export it! Thanks 😀
LikeLike
Cool! For the first time I feel an urge to start using Goodreads but I think my homemade spreadsheet will have to do.
LikeLiked by 1 person
Depending on the info you put into your homemade spreadsheet you could still do the stats! I have a homemade one as well, but it doesn’t have as much info as the goodreads export does.
LikeLiked by 1 person
Oh, I do stats whenever I have an excuse. Right now I’m mostly interested in author’s country of origin and that I do track.
LikeLiked by 1 person
Oh nice! That would be super interesting to look at! Tho I would guess most of my books are written bu American or British authors! I might have to pull those stats!
LikeLike
Honestly? This is amazing! Thanks for letting me know 😊
LikeLiked by 1 person
😀 You are welcome!! 😊
LikeLiked by 1 person
This is one of my favorite things about Goodreads tbh! Stats are the only good numbers but I love them!
LikeLiked by 1 person
I was always kind of disappointed in goodreads stats section, so I was ecstatic when I figured out I could pull my own! Stats are great 😀
LikeLiked by 1 person
Dude. This is the most glorious discovery! Thank you for sharing!
LikeLiked by 1 person
😀 Thanks!! 😀 and you are welcome!
LikeLiked by 1 person
Great post! I find stats like this so fun! I haven’t exported mine from GR in a long while… hmm… I might want to check that out again! I have no idea what my numbers look like…
Now that you have all these stats, what do you hope to do with the data?
LikeLiked by 1 person
Thanks 😀 Haha if you do, let me know what your numbers look like!
Annnd, probably nothing? Hahah I just like seeing the stats. Maybe in a year I will pull them again and compare them? Do you do anything with your stats?
LikeLiked by 1 person
I like to pull my stats at the end of the year and devise reading goals for the next year with them. For example, I am trying to make 5% of everything I read non-fiction. Last year I only read 1% nonfiction! I like using data to drive my goals. #Nerd
LikeLiked by 1 person
That makes sense! Thats a great way to use them. My only goal is total books, but I guess I do base that off the previous year and how many I was able to read 😀
LikeLike
Wow! This is great! How did you do it? Im so excel illiterate.
LikeLiked by 1 person
Thanks 😀 I wish it was simple enough to explain on here! You have to use either pivot tables or the count function to separate out the data you want for each graph and then you can create the graph. Google is a great tool for learning excel!
LikeLike