All About Books

A book blog, mostly touring foreign worlds of fantasy novels with occasional detours into space and explorations of magical realism, featuring book reviews, random bookish thoughts and hand lettered quotes.

Spreadsheet: Books 2018

spreadsheet screenshot

We can’t have a new year without a new spreadsheet, right? I even managed to make some minor changes to the one from 2017 even though I thought I was out of ideas (and time). 

Before you get the spreadsheet, please read:

  1. This spreadsheet is read-only. You have to make yourself a copy via File > Make a copy. You will not get access to my own one. (The number of requests I get each year is frustrating AF to be honest and I’ll blatantly ignore those without explaining how it’s done instead.)
  2. Not everything in the spreadsheet is self-explanatory, so please read this manual! (same as with (1), I get way too many questions every year about things that are all explained already)

 

For those of you who have already been using my spreadsheets from the last few years, especially the one from 2017: the 2018 version is almost the same but handles authors differently, so please read in the manual how those stats work now, if you want to use the new spreadsheet!

 

The spreadsheet

I’m not going to explain much about the spreadsheet because that’s all in the manual linked above. Just some general hints and tips:

  • Date format: MM/DD/YYYY
  • Number format: decimals with a dot
  • Duration as HH:MM:SS (audiobook length), typing HH:MM will be enough! The spreadsheet adds the seconds on its own
  • Challenges aren’t part of the spreadsheet, but you can track them via tags!

Have fun with the filter tab! You can get a lot of stats with that one. Some suggestions:

  • get the average rating for a genre by only filtering by genre
  • get the average rating of books released this year by only filtering by release year
  • combine format + status to find out which format is used most for reads/rereads (e.g. I mostly use audiobooks for rereads)
  • tag books with “diverse read” and combine with a genre and/or audience

If you have any problems, feel free to ask! (just make sure it’s nothing basic that’s covered in the manual please).

 

Open the spreadsheet and make yourself a copy via File > Make a copy.

Leave a reply:

Name*
Email*
Website

Comments:

  • Thank you for creating it. I didn’t use it in 2017, but I’m excited to return in 2018.

  • thank you! your last year version was so helpful to me, but honestly i didn’t get to finished D: 2018 will be different, I KNOW IT

  • This looks amazing.

    Would anyone who used last years spreadsheet be willing to post a read-only link to it so that I can see what it looks like in action?

  • Brenna • December 30th, 2017

    I love love love these spreadsheets!! I used the 2017 one religiously. I do have one question; I like to track both when I start and end a book, rather than just the date completed. In the 2017 one, I added a column before date, but I believe that messed up quite a few of the formulas, specifically on the filter and tag sections. My guess is that a column is hardcoded into the formulas and I just need to update that. Do you have any suggestions of what I should look for to make sure it’s correct? I appreciate it!

    • Yeah, there are a lot of functions that use “query” and google drive doesn’t automatically update the columns inside those queries. You would have to update pretty much every formular of the filter tab. I’ll see if I have the time to make you a different copy today. (would be faster than going into the details I think)

      • Would I be able to get this version too as I also would like to be able to track both start and finish dates?

        Many, many thanks for not only creating this, but for sharing it too as it must have taken you hours to do.

      • I would also REALLY love this modified spreadsheet with the start and end date. Fingers crossed, but totally OK if you can’t ♥

      • Brenna • January 3rd, 2018

        Thank you so much for potentially putting this together!!

  • Paula V. • December 30th, 2017

    Thank you for doing this and making it available for us! I used it in 2017 and it was awesome.

  • hofehrke • January 4th, 2018

    Thank you for making this again this year too! It’s great! Just one thing, you cannot add the gender of the author or maybe I just can’t find it?

  • a silly question but… the date column is for finished or started date?

Pings: