Losing track of all of your reading? Can’t keep up with Goodreads? Love Google Sheets and numbers? Hate numbers and wish that someone would make it for you? I have a reading spreadsheet for you!
Updated 1/4/2022
My name is Emily and I have a spreadsheet problem.
Whew. That feels better. As a teacher, I have a spreadsheet for tracking students grades, homework, and behavior. I also have a spreadsheet that I use for a calendar, another for curriculum mapping, and another for tracking cheerleading expenses. But who cares about those boring ones?
My reading spreadsheets have brought me so much joy and excitement, and I feel like I’m constantly tweaking them, adding new information, and trying to fill out as many lists as possible. One may even claim that I’ve spent more time this summer playing with these spreadsheets than I have actually reading. One may be correct.
So today, I’m sharing my spreadsheet goodness with you! I track my books on Goodreads, of course, but my spreadsheets give me a lot more information and allow me to be more flexible in my statistics.
For a peak at my spreadsheet, you can look here!
My Reading Spreadsheet
On the first tab, I have a running list of all of the books I have read this year. This includes date started and finished, title and author, year published, number of pages, star rating, and what month I’m counting it for in my What I Read posts.
Also on this tab, I track my diversity goals and other statistics. I like to watch where I’m pulling my books from (and make sure I’m actually reading books I own from time to time…). I also like to see the genre and age of the books I’m reading. I have my usual diversity challenges of reading BIPOC authors, LGBTQIA+ characters, and nonfiction books. Finally, I’m watching where the authors are from and the setting of the book, as I am trying to read books from around the world.
What About the Statistics?
This is my pride and joy! All of those statistics that were put in on the first tab now gets tallied and totaled and calculated into this gorgeous array of numbers. I have my totals (books, authors, pages, etc.), as well as my totals for my diversity goals, types of book, and sources of books.
I also wanted to see a grouping of the books I read by page length, year published, and star rating. Those formulas take the data I input on the first page and magically sort it into categories. They are, of course, my own arbitrary categories. I also tally how many books, authors, and pages I’ve read each month, just to compare month to month. The page numbers have been especially nice, and I added audiobook hours to track that as well.
The Other Features
One of my favorite tabs is my “On My Shelf” tab. Here, I track all of the books on my shelf. I divide my bookshelves between Adult Fiction, YA Fiction, Nonfiction, Classics, and Unread — well… I would if I had more space on my shelves. I also mark if I stamped the book with my personalized embosser that my husband gave me for Christmas (he’s the best), and I track who I loaned books out to and what date I gave it to them. No more lost books for me!
The Free Ish
Of course, you can take my spreadsheet that I posted above, make a copy of it, and use it for yourself. But! I made a clean copy of this same spreadsheet (minus the stuff that you probably don’t care about at all), and will share it with you for you to use!
It is on Google Drive, which just means you need to have a gmail email address to be able to access it and make your own copy of it.
You can get that clean copy HERE!
What’s included?
- Reading Tracker for 2022 and Beyond
- Statistics Page that auto-fills based on the 2022 tab
- Graphs Page that pulls straight from the Statistics Page
- Currently Reading Tab that allows you to track current and upcoming books
- Library Tab that you can use for your own bookshelves
Come back in December for your 2023 update! Let me know if you use it and love it!
