Now, this spreadsheet started out innocently enough. I just wanted a way to keep track of the books I already had so I wouldn't buy duplicates. But then I got active online and book recommendations were all over the place and I had little scraps of paper all over the place. What's a spreadsheet junkie to do?
- AUTHOR (last name, first name format cause I'm anal that way)
- TITLE (I include the series name if there is one)
- NUMBER IN SERIES (because I detest reading a series out of order)
- FORMAT (H = hardcover, P = paperback, TP = trade paperback, E = e-book, L = library book)
- A column for the HERO and another for the HEROINE (can't remember why I did this originally but I've kept it up)
- DATE READ (of course, this was a guess for a lot of the books initially)
- NOTES (what I liked or not, if it was a beta read, etc.)
Then, I worked on all those scraps of paper with all those recommendations and created my TO FIND LIST. (And I do print this out, at least in part, before I ever hit a brick-n-mortar store!)
- NUMBER IN SERIES
- NOTES (for things like release dates, who recommended it, etc.)
- NUMBER IN SERIES
Since I started tracking I've revamped this baby.
The READ sheet now has the additional columns of:
- NUMBER OF PAGES IF LESS THAN 300 (I inhale books at a rate of about 100 pages per reading session with this as my average book length. That's not to say that a shorter work isn't as good but when I'm looking back over the year it helps me gage how much I read better.)
- KEEPER? (a simple 'Y' in the column for the ones I want to keep or want to buy if a library book)
- GENRE (this is new for 2011 previously I used the NOTE column for this)
The TBR sheet now has the additional columns of:
- NUMBER OF PAGES IF LESS THAN 300 (though I rarely fill this out before I've read the book)
The TO FIND sheet has the additional column of:
- GENRE (because I'm wanting to make sure I'm reading broadly)
I know there are many ways to keep on top of your reading. I'm curious, what works for you?