A short while ago, I mentioned having an Owned TBR spreadsheet that I use to track what books I own and haven’t read. In this post, I’ll be going into more detail about it!
First off, I am really, really sad that I didn’t record where I got this specific idea and spreadsheet example from. I guess I assumed I would remember, and then I didn’t. I do know that I made many changes from the example spreadsheet, but that still doesn’t excuse the fact that I can’t give credit to the person who inspired me to create an Owned TBR spreadsheet of my own.
But since I can’t share with you the link that gave me a start on tracking my Owned TBR, I can share a link to my spreadsheet so that you can see if you like any of the ideas I’m using.
(And because pictures speak louder than words, here’s an image of what my spreadsheet looks like… Apologies that it probably all looks very small. You should be able to click the pic to make it bigger.)
The basic concept is that I made a list of all the books I owned but hadn’t read and entered them all into this spreadsheet. (This sample is nowhere near the real total. At the time I’m writing this, my real total is 190 books on the Owned TBR.) I like tracking random data, so I also added formulas to track how many unique authors were on my list, how many different series, what formats the books were in… well. Anything that I thought was interesting for books that I hadn’t read yet.
The only thing that I can think of which I didn’t add but am potentially interested in is where I got the book — for example, was it a gift, did I buy it, win it in a giveaway, was it free to download… etc. I might go back and add that later, but it’s not in this version.
And using it is simple. Once you’ve added all the books you own, you don’t have to do anything until you read one of them, get a new book, or get rid of a book. At that point, you update the spreadsheet with the new data, and presto! Your spreadsheet is accurate again. The initial entry might take some time, depending on how many books you have on your own personal Owned TBR, but upkeep is simple.
I will take just about any excuse to make a spreadsheet for something. This particular xkcd comic?
Also, look! A new post category! My new Sunday Sundry posts will be my catch-all for the miscellaneous posts without any real theme to them. Probably also a few smaller themed things that I am too lazy to make a blog header for.