A Spreadsheet to Organize Your Inventory & TBR
On My Shelves
(Click to enlarge.)
This spreadsheet contains the following information:
- Book author and title – for obvious reasons.
- Series name and number – to keep track of which series I own and whether I have all of them or not.
- Whether I’ve read it or not – to use as a filtering option. I can filter to blanks, to see which books I have and need to read (my TBR, if you will), or to the books I’ve read, to see which books I may want to get rid of if I’m in need of cleaning up my shelves.
- Rating – If I’ve read the book, I put the rating here, so if I indeed want to clean up my shelves, I can instantly get a reminder of whether or not I liked that book. Obviously it’s different for everyone, as everyone has different amounts of shelf space, but I can say at least for the time being that anything lower than a 3 rating should be removed from my shelves.
- Classification and genre – I can use this to search through my TBR. For example, if I’m looking for my next read and am looking for something light, I can filter Read? to blanks, and I can select these options to search for young adult contemporaries.
- Format – I separate my hardcovers from paperbacks on the shelves, so this could help me find the book I’m looking for. Also, if I need to buy the sequel and can’t remember whether I had the previous in paperback or hardcover, I could easily look it up here if I’m away from home, in the bookstore, or something.
- Signed? – Obviously, if I’m trying to find some books it would be okay to get rid of, I’m less likely to pick the signed ones. So I have that recorded here, with a few different options: no, yes, yes – personalized, yes – book plate.
- Source – I like keeping track of this (a) to help when I’m filling in the book info on a review (my memory can be awful) and (b) because I like to prioritize the books I’ve received as gifts.
- Imprint and publisher – I’m still interested in looking into this more statistically, to see which publishers work best for me, but having this info noted can also help when purchasing a sequel, to make sure you get the right edition, etc.
- Whether a book is rereadable.
- Whether a book is an all-time favorite.
- Whether it’s a book you can see yourself reading to your future children.
- Cover grade – like in my spreadsheet on books I’m reading this year, you could keep a grade on the covers here, to quickly remember which are your favorites.
- Cover color – If you like to organize your bookshelves by color, you could keep track of the colors here in case it becomes difficult to track down your books later. Now that I’ve thought of that, my bookshelves actually do stand a chance at becoming rainbow shelves!
- Release date – If you decide not to have a separate tab for review copies, haha.
- Number of pages – So you can easily search for a short or long book.
- ISBN number – If you’re one of those people. o_o
- Which shelf is it on? – in case you have a personal library or whatever, I’m glaring at you out of jealousy, but I can also imagine it might be hard to find your books. So. You could number your shelves and put that here or something.
I keep my e-books separate because (a) I don’t feel as pressured to read them, (b) some of the info for physical copies isn’t as relevant, and (c) there are a couple other things I like to keep track of. For these books, I don’t keep track of the format or whether it’s signed because, well, duh. I also don’t keep track of the imprint or publisher because purchasing the right edition is less of an issue.
I will generally only buy e-copies if they’re at a good price, or I’m not sure that I’ll like the book enough to have it on my shelves. This can save me money, but it can also result in me buying the books twice – because if I love a book, I will inevitably want to have a physical copy. That’s why here, the column that to me is key, is the status column. Some books I will just keep on my e-reader. Some I really dislike and will delete. Some I will immediately purchase a hard copy of. And some I will put on a list to buy later – when I have room for it in my budget or it’s on deal somewhere.
Now this is probably the tab I’m most proud of and most likely to use on a regular basis. Review copies. Pesky things, amirite? Well here we go. Your solution so you never forget about one of them again. Here’s what I dubbed as useful information for this tab:
- Book title and author, still obviously.
- Series, also obviously. But for those with a lot of review copies, you could easily make an accompanying column about whether or not you have read its prequels!
- Release date – per default I keep the spreadsheet sorted by release date descending.
- Read? and Rating – Obviously I want that column to be entirely green at some point. (Which is done, by the way, by conditional formatting.)
- Classification and genre – if I’m picking and choosing which I want to read.
- Imprint and publisher – for the book info in the book review, but also so I can measure my own success in contacting publishers and remember who to email the review to.
- Format and signed? – I can easily remember whether they’re e-copies or physical copies. And if it’s signed. (I don’t have any signed ARCs yet, but I can imagine after BEA that will change. And it will be useful to know this for culling books.)
- Source – where did I get it?
- Method – if I run out of time on review copies, I can use this to prioritize. Did I request the book? Was I invited to review it? Was it unsolicited? etc. etc.
- Status – as with e-copies, if I love a book I want a finished hardcover. Here I can keep track of if I’ve deleted the eARC, gave the ARC away, bought a finished copy, or put it on a to-buy list.
How do you keep track of your TBR/inventory/review copies? I’m having quite a bit of fun with these spreadsheets, obviously. I hope you guys find them useful too! Need an organizational system for anything else?