Reading Tracker 2024
Welcome to 2024! I’m starting something new this year that I wanted to share, if you’re a data geek like me. Every year the last week of December I spend downloading data from Storygraph, going through my top reads of the year, but no longer! Thanks so much to @sadiereads_ for creating the most amazing Reading Tracker for 2024! (Clicking on the link will force you to make a copy in Google Sheets). Sadie mostly reads romance so I had to go in and change some of the genres, but since I also read a good amount of romance I left the tropes column just so I could see how many different tropes I read throughout the year.
Reading Tracker by Columns
Column A: Month you read the book
Column B: Title of the book *these two columns are frozen so that when you scroll to the right you’ll still see the title of the book to know which row you’re looking at
Column C: Author(s) of the book
Column D: Series, if applicable
Column E: # in the Series (if applicable)
Column F: Release year(s)
Column G: Recent release (if applicable)
Column H: Format of the book (physical, ebook, audiobook)
Column I: Length (in pages or hours, if an audiobook) of the book
Column J: Pages (exact number) of the book
Column K: Hours (exact number) of the book
Column L: Rating of the book (half ratings, if applicable)
Column M: Genres (if you want to change/add some make sure you start at the top entry box, add your change and apply to range: Read!M2:M30 (or however many rows down it goes for you)
Column N: Age of book (picture book, middle grade, young adult, new adult, adult)
Column O: BIPOC representation (yes or no)
Column P: Ethnicity representation (edit/add any you want—I will be adding more as I think of them)
Column Q: LGBTQIA+ representation (yes or no)
Column R: Orientation specification (edit/add any you want—I will be adding more as I think of them)
Column S: Pairing specification (M/M, NB, F/F, etc.)
Column T: Theme (disability rep, body image, mental health, war, etc. I’ll be adding to this as I think of them)
Column U: Main Trope (for romance genre only; I will be adding more as I think of them)
Column V: Acquired (how I read it: Public Library, ARC-Netgalley, ARC-Edelweiss, ARC-physical, Scribd, Kindle Unlimited, etc.)
Column W: Reread (yes or no)
Column Y: Reviewed (did I write a review, yes or no)
Column Z: Link to my review (Goodreads link to review)
Column AA: Content Warnings: pulled from my review
More Tabs
The second tab at the bottom is for Authors specifically. I will probably hide that one, as I can filter authors using the first tab. The 3rd tab is to keep up with my ARCs. Currently I feel like I’m drowning in them and I want to honor my commitments to read the ones I am approved for or that I download or that are sent to me in physical form. In this one I’m just looking at title, author, series, # in the series, ARCs so it will be physical, audiobook, ebook, the genre, age, format, how it was acquired, when I’ve read it and the review link. This will help keep me organized and accountable with my ARCs because that’s my 2024 Readolution: read more ARCs to bring up my Netgalley percentage. Hopefully this helps with that. The last tab at the bottom is Overview and this where the statistics will go at the end of the year.
If you’re data driven like me, I’m hoping this Google Sheet makes your heart happy. We’re not far into 2024 so if this is something you want to do, feel free to head back to the first book you read this year and start adding it and then make it a habit to add this info after each book read. Happy reading!
