My Book Series Tracker
I have a spreadsheet where I log all the books I've read. I call it my “My ALL-Time Reading Log”.
It has books from as early as 1992, which I logged based on the physical books I've read at the time. These early entries don't have too much info other than book title, author, number of pages and the year I've read them.
In 2012, when I got my first e-reader (the 4th Generation Kindle) I started to add more details, such as start/finish dates, book format, genre and some notes about the books I’ve read.
This spreadsheet has gone through different format iterations over the years, but I still like to keep it simple (or as simple as I can!). I update it once a month, gathering data from The Storygraph app, which I use as my daily reading tracker.
The last update I did on my spreadsheet was adding a tab to track Book Series!
I was inspired by the CAWPILE spreadsheet created by Book Roast. I'm not using her whole CAWPILE rating system, but I liked that she had a book series tracker.
So, my Series Tracker tab has the following columns:
- Series name
- Author
- Books # (Total) : total number of books in the series
- % Read: percentage of books I've read in the series
- Columns with the books: They are just numbered as “Book 1”, “Book 2”, etc. I mark with an “x” the books I’ve read in the series. I grey out the cells and add a “-” marker to indicate not applicable books for each series.
- DNF (Did not Finish): I mark when I do intend to keep on reading the series
- Finished: to mark the series I’ve finished
And at the bottom I added a section for series I want to start reading someday.
On the side of the spreadsheet there is a simple stats count, showing ongoing series, how many series I abandoned (DNF) and total number of series finished.
I didn't go back in time to log ALL the series I've finished or DNF'ed, only the ones that I quickly remembered when I was creating this. Mayne someday I will go back to my log and list those forgotten series.
But for now, I just want to track what currently has my attention.
—-
Post 45/100 of 100DaysToOffload challenge (Round 2)!
#100DaysToOffload #100Days #Books #Reading
Thoughts? Discuss... if you have a Write.as account or Reply by email
By Noisy Deadlines Minimalist in progress, nerdy, introvert, skeptic. I don't leave without my e-reader.