How to Keep Track – My 2014 Yearbook & Other Useful Spreadsheets

Posted January 10, 2014 by Debby in How To's / 61 Comments

how to 2
If you follow me on Twitter, you might have noticed the past few months that making spreadsheets has become somewhat of a hobby for me. I dunno what it is. I get some downtime at work, and I get an idea of something that I want to keep track of, and there I go – a spreadsheet making machine. I’m only a little bit OCD. Just a little. Okay, maybe a lot.

*cough* But these compulsive spreadsheet making tweets were apparently well liked! And I thought, “Why not share the method to my madness?” Since inspiration is coming lately not in the form of discussion posts but spreadsheets, sure. Especially since my latest inspiration is great for the new year: a yearbook. Put your OCD hats on and follow me, lovelies!

My 2014 Yearbook

Last year, I was already more OCD than most, and I had a Word document where I made a ranking of all the books I read. It helped me to keep track of my favorite books of the year, measure how books fared compared to each other, and ensure that my ratings were rather consistent (i.e. is this book 3 or 3.5 stars? Well _____ was 3 stars, and _____ was 3.5 stars, and I think it’s closer to the latter). I also found it really important because I knew that at the end of the year, I would forget about the books I loved in January/February otherwise – that’s just a cognitive bias. For each book, I had a rank, the title, author, the date I read it, and the rating.

While I was working on the 2013 End of Year Book Survey last week, I stumbled on the question of which genre I had read the most of. Instantly, I wished I had statistics on it. I went back to my ranking Word document, but the information was limited. I did go through and classify them into genres and count anyway, but why on earth did I do that in Word? With a spreadsheet, with filtering options, it’s much easier to create statistics, charts, and to find exactly what I’m looking for.

To put it simply, my desire for information is expanding. When this time next year I’m looking back on 2014, I want to be able to give a broader and more interesting overview of my reading year. Off to Google Docs I went. I prefer Google Docs because it lets me fiddle with these spreadsheets at work, edit them anywhere, and potentially share them with others. Here is currently what I’m keeping track of for books in 2014:

2014-01-09 10_12_41-2014 Scrapbook
(Click to enlarge.)

Some things are obviously carried over from my Word overview from last year: a rank, the book title and author, the date read, and the rating. However some things are new.

  • I want to keep track of genres – because it was honestly surprising to me that last year my most popular genre was contemporary. I mean, whoa.
  • I also want to keep track of whether it’s the first, middle, or last in a series or a standalone. That will let me keep track of how many series I start/finish and how many standalones I read.
  • I want to keep track of debuts – because when making the 2013 Year End Book Survey, I actually originally forgot to include All Our Yesterdays in response to the question about the best debuts. I just forgot that was a debut. NO MORE.
  • I want to give book covers a grade. I’ve been toying with the idea of starting a feature around covers, but I’m not so sure about that, but it’ll be nice to, at the end of the year, quickly remember which covers I absolutely loved. (Should I include cover grades in my reviews? Hmm.)
  • I want to keep track of the release year. How many new releases am I reading? How many backlist books am I giving a chance? This would also allow me to filter it, to see my favorites in both categories, like what I did for my Top 10 Books I Read in 2013.
  • I’m also keeping track of the classification: young adult, adult, or middle grade. This is not in the screenshot because I just thought of it, ha. BUT. It is an important thing I want to measure.
Christina came up with some other useful statistics that would be nice to keep track of as well (THANK YOUβ™₯):

  • I want to keep track of the imprints and publishers. I think it will be really nice to at the end of the year have a view of which imprints and publishers worked out best for me – could also be encouraging for next year: which imprints/publishers should I pay particular attention to because of success in the past?
  • I want to keep track of the source and format easily – mostly to see how many books I read for review, and how many I choose myself.
  • I want to keep track of the number of pages, to not only calculate the total number of pages read, but also the average number of pages per book.
So. That’s a view of what it’s like to live in my head. I’m crazy, I know. But I just keep imagining the beautiful charts and graphs I could produce in my 2014 Year in Review and… *swoons* there’s something really sexy about a well-organized spreadsheet.


But the spreadsheet doesn’t end with just books. In my Monthly Wrap Ups I like to quickly mention some of my other favorite things of the month. Each time, however, I sit there, scratching my head, because my memory is absolutely horrid. So, why not keep track of this in the spreadsheet as well? Then I could even make a yearly favorites post!

Here are the other tabs in my yearbook.

Manga: With our Manga Project, I’ve finally gotten into reading more manga. I don’t count these as books I read throughout the year, but I’d still like to keep track of them. I’m also probably going to be doing manga series reviews. So one tab on that! Thanks to Christina again for the suggestion of FEELS ratings and plot ratings, because particularly for manga, that is absolutely essential (i.e. plot-wise WTF WHAT HAPPENING but OMG I SHIP IT SO HARD).

2014-01-09 10_44_34-2014 Scrapbook

TV Series Following: These are the currently airing TV series that I am watching. I want to keep track of that throughout the year, but am not giving them ratings because, well, TV is so complicated that I don’t think I could. I am ranking them, but also giving them each a short verdict, which I will repeat in June and in December, to keep track of how my opinion changes throughout the year. (NOTE: This may make me look like a TV addict, but recognize the fact that more than half of these have shorter, irregular seasons. *cough* I have a healthy relationship with TV.)

2014-01-09 10_51_54-2014 Scrapbook

TV Series Binging: Particularly for my Asian dramas, this is the best way to keep track. But also for US/UK shows: I discover something, love it, binge watch it, and then that’s one of my monthly obsessions. But I can go through them quickly and then forget it ever happened. Sad day.

2014-01-09 11_04_36-2014 Scrapbook

Movies: Honestly, I couldn’t tell you what movies I watched last year. Seriously. Possibly that’s because there were so few of them. But possibly I watched things and immediately wiped it from my memory. I dunno. I’m weird. So I’d like to keep track. Also, I should watch a freaking movie this year. o_o

2014-01-09 11_01_12-2014 Scrapbook

Music: I go through phases with my music, and that’s also a nice thing to keep track of. What were my favorite artists/bands? What were my favorite songs? In 2014, we shall know.

2014-01-09 11_06_18-2014 Scrapbook

Ships: I just thought of this and added it immediately. I need to keep track of my ships. It was actually extremely difficult to answer the question in the Year End Book Survey about favorite romances, and I knew I forgot some amazing ones even though I listed 8. (At first I forgot about Em and Finn from All Our Yesterdays HOW DARE I.) So. A ship tab. Precise format and rating scale TBD.

2014-01-09 12_15_59-2014 Scrapbook

Favorite Quotes: I used to like all the quotes that stood out to me via Goodreads, but man, that doesn’t exactly make it easier to look back through them. From now on, I will note quotes that I really love and stand out to me here. Other people have quote books for this, but I am lazy and my handwriting is horrendous, so I’ll be using this. Haha. Yeah, I had trouble answering the question in the survey about favorite quotes. I ended up using a lovely one from This Song Will Save Your Life, but I know that there were other quotes I loved in 2013, but I simply forgot about them or can’t find them anywhere.

2014-01-09 13_09_53-2014 Scrapbook

Notable Events: Finally, I want to track events and social outings. As a part of my effort to focus more on positive energy and cherish the good times, I need something like this. I know there were definitely GOOD THINGS in 2013 that I just completely forgot about, because it got buried in a pile of bad things.

“The good things don’t always soften the bad things, but vice-versa, the bad things don’t necessarily spoil the good things or make them unimportant.”
Right? Yeah? If you get that reference, internet cookies to you.

2014-01-09 11_09_25-2014 Scrapbook

TL;DR: All of this…

Keeping Track of Book Shopping

Another spreadsheet I made a while back was to keep track of book shopping. I know. It’s risky business, because cue the guilt spirals. But I like prioritizing – keeping in mind which books I must have and want to buy with my next paycheck. I’m not a very spontaneous person, and most of the time, spontaneity ends badly for me anyhow – with books that lie in my TBR pile for years. I keep an overview of upcoming releases this way too, and manage to kind of plan out my budget. I made this spreadsheet back in September, I believe, so with my more advanced spreadsheet-making mind I might give it a makeover sometime, but this is what it looks like right now.

New releases: This is getting more complicated as I am getting more ARCs, but okay. Basically, I put books into the spreadsheet when I hear about them – keeping them in mind. I can give them a priority. Lines that are gray are books I’ve purchased. Lines that are yellow are books I have ARCs or eARCs of – showing my opinion is “pending”. I make them red if I read them and don’t like them (and will delete it from the spreadsheet at some point) or green if I loved them and want to buy them at some point.

2014-01-09 11_21_25-Book Shopping

Backlist books: I keep these separate because backlist books are, obviously, the books that I could always buy and not have to wait on a pre-order for. I sort these by priority and importantly for myself keep track of which edition I want – since I can be torn between UK and US editions. When I buy these books, they obviously are removed from the spreadsheet and moved to the next tab.

2014-01-09 11_30_28-Book Shopping

Purchased books: Now this is for everyone probably the most horrendous tab, because here I keep track of the books I’ve bought. But hear me out: for me it’s necessary because I live in the Bermuda Triangle, The Realm of Lost Orders. This is why the cells of the purchase date are gray – that marks that I’ve received them. By referencing the purchase date I can also kind of keep in mind if an order is likely lost. But other than that, I also like my READ column, to keep an overview of how I’m faring in reading the books I buy. I’m also going to be adding the egalleys I download to this as well – and then it will be an easy way to keep track of which books I need to put into my next book haul (I always forget about those pesky egalleys!).

2014-01-09 11_33_11-Book Shopping

A Well-Organized Book Club

One last example I want to share with you is our book club spreadsheet. When I started setting up and organizing things to make book club happen, I instantly thought that a spreadsheet would be the easiest way. By using Google Docs, the document can be shared with everyone, and then all the information is in one place instead of scattered throughout different emails, where people are individually responsible to note things down and put meetings in their agendas. (We also have a shared Google calendar, so now meetings are automatically synchronized to everyone’s phones.)

Our book club works like this: each person is assigned a month that they play “host”. All the title really means is that they are in charge of listing 3-5 suggestions on books to read. When they do, they let the others know via email, and then they can all each access the spreadsheet and place their name next to the book they want to read. Majority rules, and the book with the most votes is the next pick.

2014-01-09 11_50_21-Book Club Book Picks & Meetings!

Let’s Talk!

That’s it for me for today. How do you like my spreadsheets? Have they scared you off yet? What? You think I’m crazy?

Haha, but in all honesty, let me know what you think. Are you inspired by any of this? How do you keep track? Do you have any suggestions for statistics/info that I may have missed in the book part of my yearbook?

Let me know in the comments!

Tags: , , , , ,


61 responses to “How to Keep Track – My 2014 Yearbook & Other Useful Spreadsheets

  1. You are insanely organised. This is a god like level of organisation… One which I really wish I could do. And have tried to do. But my laziness/forgetfulness always foils any organisational plans I have. I either can’t be bothered to update the spreadsheets or completely forget they exist. Also, I’d spend more time colour coding and being nit picky about how they’re set out that I’d never get time to fill them in (Excel doesn’t always like to cooperate with me when it comes to formatting, and I’m extremely OCD when it comes to setting things out) Maybe one day I will be able to properly utilise the amazingness of spreadsheets….
    Bec @ Ransom Reads recently posted NY Challenge: New Things in 2014My Profile

  2. My eyes were giant hearts the entire time I was reading this post. I love spreadsheets so much. (That is such on odd thing to say, haha.) I actually keep a spreadsheet of all the books I own, what format they’re in, what publisher/imprint they’re from, and how many pages. I’m not sure why I have it. I guess in the unlikely scenario that I get robbed, and the robber decides he wants to try out YA? Who knows.

    I had been using Microsoft Excel, but I think I might switch over to Google Docs. It looks much prettier!

    I was also just thinking about how I wanted to do a more organized year end wrap-up this year, so this is a HUGE help! Especially so early in the year – I don’t want to deal with having to go all the way back, haha. I have no patience for that!
    Amanda @ Hell-Bent to Read recently posted Review | Forgive Me, Leonard Peacock by Matthew QuickMy Profile

    • Haha, I actually made a spreadsheet of books I own this weekend! I thinnk it’s not just useful if you get robbed, lol, but also if you’re moving – to take inventory. I also keep track of whether I’ve read the books or not and what rating I gave them – which would be helpful to keep an overview of the TBR and if I decide I need to cull some books. So I may write a post about that spreadsheet as well – sounds like the blogging community might find it useful πŸ™‚

  3. WOOWWWW! This is amazing. Don’t worry you haven’t scared me off. πŸ˜‰ But seriously, this is epic. Like Bec said, I’ve tried and failed to stay organised. I don’t really have any particular way of organising all of my stuff but I have a few apps on my phone that I like to use. Other than that I just have Goodreads when it comes to books. I try to use my non-existent memory. Yeah, I like to live life on the edge. Haha, just kidding. Okay, this comment is getting weird. I’ll just stop. πŸ˜›
    Laura Plus Books recently posted Book Review: Knightley and Son by Rohan GavinMy Profile

  4. I love your spreadsheets! I keep track of my reading, bookish spending, and tbr-piles in one heavily modified GoodReads export document in Excel. I love being able to filter by date read, exclusive shelf, etc. Data is fun isn’t it!

    Your post has actually given me a great idea: the shopping list! I have a long list of books I’d like to buy ebook versions of, but it’s all in my head. I SHOULD MAKE A LIST DEBBY! *high fives you, runs off to Excel*
    Terri @ Starlight Book Reviews recently posted Review: “Waterfell” by Amalie HowardMy Profile

  5. Wow. That is impressive. I think I’m in love with your spreadsheets(I love spreadsheets too!). I keep track of a few of things in spreadsheets(like review copies, etc.) but I definitely need to expand. I love using Google Docs too, because it’s nice to be able to access it anywhere, and like you, I sometimes update whenever I have a few minutes of downtime at work. I should really make a list of books I want to buy! I mean I have a list on Goodreads, but a spreadsheet would be able to help me keep track much better. Basically: I have a project today, inspired by this post for sure!
    Stormy recently posted Book Review: Being Sloane Jacobs by Lauren MorrillMy Profile

  6. Dang. What the heck, woman? I’M supposed to be the organized one of the group but you just blew me out of the water. Like, so far out of the water that I’m currently sitting in the Sahara and looking around in confusion. As far as your first spreadsheet goes, we have almost the exact same categories, which I think is kinda cool. But all those other ones? Crazytown.
    Shae/Shelver @ Shae Has Left The Room recently posted The Magic of the First ChapterMy Profile

  7. I love the spreadsheets! It’s sorta like making lists and I love making lists πŸ™‚ Also: I have a color-coded TBR spreadsheet, which used to be up to date, but I’ve been seriously neglecting it. And another spreadsheet that has the books I have review copies of but haven’t read the previous book in the series from yet listed by publication date.
    I’m sorta feeling the urge to at least also make a spreadsheet for the books I’ll be reading this year…
    Daisy recently posted Review of Diamonds and Deceit by Leila RasheedMy Profile

    • Haha, I have a TBR spreadsheet as well, but it’s more just a list of book titles, so I didn’t think it would be that interesting to share. And I don’t like sticking to a strict TBR anyway – that only demotivates me xD Do you really plan out the whole year? If so, whoa o_o

      • I used to plan ahead for about 4-5 books, but then I gave up on it cause I was actually dreading reading that next book and not enjoying it so much. So now I just go by what I want to read and what has to be read for review and such.
        My TBR spreadsheet is basically everything that’s on my Goodreads to-read shelf, with color codes as to where I can find them (own/borrow from someone/edelweiss/netgalley/pre-order/that sorta thing), sorted by author’s last name πŸ™‚ It feels good to cross things off the list, but mostly I’m adding to it, so yeah..
        Daisy recently posted Review of The Scandal In Kissing an Heir by Sophie BarnesMy Profile

        • Ooooh in that sense! I get it. Yeah, I have my “to read soon” shelf on Goodreads, where I try to prioritize the next 7-10 books to read, so that’s kind of my TBR, but I just pick and choose from there and keep review copies a priority. But I also do a horrible job of keeping up with that. Case in point: this morning I took 8 books off that list because they had been there since July and just no. ^^; I—– fail at life.

  8. Very impressive Debby! I love making lists, so I have a notebook where I have a wish list, which books I read (with rating, ARC/owned/eARC, part of series/stand-alone), all the reading challenges and I have a list with TV shows/movies I’ve seen this year πŸ™‚ I use to help me to keep track with all the shows. I have a file in Excel with all my eARC/ARC’s, publication dates, where I got them, publisher etc.

    You are a pro πŸ˜€ *bows down to master*
    Mel@thedailyprophecy recently posted Epic Recs. January.My Profile

  9. Do not get used to this. My schedule is as important to me as you spreadsheets are to you, so I’ll continue to gallivant in a month late generally. BUT I do respect the spreadsheets.

    And, for the record, I look FREAKING FANTASTIC in my OCD hat.

    Oh man, my favorite book lists are always unfair to early in the year books. It’s super sad.

    Oooh, I forgot to put genre on my spreadsheet, but genres also confuse me, so I may just avoid that? Or only do contemporary, fantasy, sci-fi? Meh.

    I’m really enjoying your Cover Grade thing. I don’t think I’ll do anything with it, but it does amuse me, so good enough. (I super do not want any more cover features)

    Release year was a good plan, though I’m not sure if I should go with original publication or release in the US or release for my edition. X_X SO MANY CHOICES

    Hmmm, I am now understanding the value of your series-first thing, which confused me. That actually makes sense. *changes spreadsheet*

    OOOH, I am in here. Our nerdery is mutually beneficial.

    Bahaha: “Each time, however, I sit there, scratching my head, because my memory is absolutely horrid.” <- Your brain sounds a lot like my brain. I just can't decide if I want to have an overall spreadsheet that I dump them all into at the end of the year as well as a separate one for things consumed each year. Hmmmmmm.

    LOVE the separate sheets for Binging series versus following. That's brilliant.

    DUUUUUUDE, I was thinking of making a ship one like two years ago, but didn't.

    Um, so, yeah, I think I might add all of these except for maybe TV following, since I think I'm only following like four now. And music, because I'm too lazy and ehhh.
    Christina (A Reader of Fictions) recently posted Review: BlissMy Profile

    • Yayyyyyyyyyy. It means a lot, really :’)

      OCD hats are pretty fabulous things, it is known.

      I KNOW RIGHT? At the end of year survey, I remembered loving Pivot Point, but my enthusiasm and flailiness for it had waned. But I still knew I REALLY loved it. It’s so hard to keep track of that though. So the spreadsheet should help.

      I’m broadly classifying genres into contemporary, sci-fi, fantasy, and paranormal. Oh and historical fiction, when I finally go read some of those. I’ll have to take some liberties, but ehhh. It’s just for those broad genre statistics. I desperately want to have those. So. Yeah.

      Haha, I can imagine that with Cover Snark you’ve got your hands full. I was thinking of periodically having a post where I post all the covers of the books I read since the last post, and quickly write my thoughts about them, also particularly noting if I think the cover’s a good representation of the book, and the kind of audience it attracts. But I dunno. Effort. And I dunno if people would be interested xD

      Release year I go with original publication, always. That’s when the story first spawned into being. I dunno.

      HAHA, yeah, I was thinking that my series thing would need some explaining. But I’ll be very interested in what that generates at the end of the year.

      Your nerdery is amazing β™₯

      I’m going to keep it separate by year, because otherwise it just becomes SO HUGE, and comparing between years seems extra interesting to me. How did my interests change? That kinda thing. I could always copy paste them later to have them all. But since I’m only starting this now, that’s an issue for future!Debby.

      Basically I love you. *cough*

  10. Ohhhhh, these are all so gorgeous and I’m not an organized person but I am going to do this for my books OMG yes.

    Coffee Prince is a 5 for plot, what are you talking about, crazy girl. At least I see a 5 for feeeeels!

    OMG. Quotes. That’s brilliant. I NEVER remember quotes. MUST START WRITING DOWN QUOTES.


    brb off to organize my entire life bye
    Gillian recently posted Second Book Syndrome (and What That Is and Why)My Profile

    • Heeeeee yayyyyyyyyyy πŸ˜€

      Coffee Prince’s plot was good but it didn’t AMAZE me. *sigh* sorry, I’m picky with my 5 ratings πŸ˜›

      I know right? Ugh, the quotes question on the end of year survey was one of the worst xD now I just need a system for marking quotes in my physical copies. Highlighting is so easy on my e-reader, but real books…. asdfjkl; I cannot harm them.



  11. Morgan

    I love how organized you are, it’s really awesome!!! For books, I tend to write a lot of lists, tracking what I need to buy next or organizing how to group my pre-orders for lowest shipping, but I like your purchasing spreadsheet! And I love your Cover Grades ideas, you should start adding that to reviews πŸ™‚

    I actually JUST wrote a sticky note yesterday on the tv series I’m behind on and how many eps I need to catch up. Definitely need a spreadsheet for all of that haha.

    And I’m actually a big movie person. I have two small journals filled with every movie ticket I’ve purchased/gone to since 2001. I have my own rating system and write mini reviews; it’s just for myself but it’s really fun! Then I always like to figure out how many movies I average a month. My high for awhile was 3-4 movies in theaters a month haha. BUT I’ve always wanted to figure out a way to track how often I watch certain movies in a year. Example: I’ll watch Clueless/LOTR/etc every time it’s on tv (and a lot of times on DVD). I want to track each movie I start, but I’m not sure if I should count watching half a movie, part of a movie, etc. I tend to watch my favorites a LOT and I’m curious how much “a lot” really is.

    So yeah, I get your spreadsheets hahah. Awesome post, awesome system!

  12. This is amazing! You’re so organized! I might have to take a leaf from your book and start having a similar system for all my things too. At this point, the only thing I keep track of are the books I read but I don’t do them on the computer. After my laptop crashed a few years ago and deleted (some of) my files, I don’t really trust it to safeguard important information and I’m actually really obsessed about my book log so I feel better when it’s on paper. Since I watch a lot of shows as well, I should keep track of them too! I really want to get into Downton and ditch some old shows like New Girl. I totally agree with you, it’s going downhill. The first season was so good and now I just feel they’re running out of ideas and pulling out all their last stops.

    Great post, love your spreadsheets and I’ll definitely be thinking of starting a scrapbook of my own!
    Annie recently posted Bookish Radar (3)My Profile

    • If you use Google Docs to make your spreadsheet, you won’t lose it even if your computer crashes. It’ll be available anywhere, stored in the cloud, and you can access it with any computer as long as you log into your Google account and you can also access it on your phone/tablet with the app. Just a tip! On paper is nice too but it can get jumbled, and if you later decide there’s some additional info you want to keep track of for each book, it’s hard to go back and edit and keep it looking pretty.

      New Girl’s humor is getting stupider and stupider. The quirk is getting exhausting. Sad. I really did like it at first πŸ™

      • You make good points! I think I’m going to start using spreadsheets too. The main thing for me is that they’re easier to edit and customize. I’m really anal about how my logs look on paper so if I make one mistake, I just have to start all over again on a new sheet of paper. So it might be better for me to do it on the computer….
        Annie recently posted The Deal With Courtesy CommentsMy Profile

  13. Christina, and then you? *claps excitedly, not unlike a retarded seal*
    Everything is spreadsheets and nothing hurts!
    I have (well, I thought I had) spreadsheets for everything too, from classes to gifts to money.
    BUT I’d never thought of arranging all my media this way. I only have a GDrive spreadsheet for review copies (With a script that sends shouty capslock-y emails if I’m falling behind. Among other things) but this is such a great idea!
    I’m always looking for apps to track my TV/movie progress, but none of them would give me stats. Also, a Ships spreadsheet is basically doing geeky things to better express aforementioned geekery. To which I say, YES. πŸ˜€
    *goes back to admiring spreadsheet screencaps*
    Antara recently posted Top Ten Tuesday #2: Resolutions For 2014My Profile

  14. Lia

    Your spreadsheets are so droolworthy, Debby! I am barely resisting the temptation to open up my spreadsheets and edit them, including all of your excellent new ideas.

    I had started one last year, and reached till 25 and stopped there. Maybe that was because I was originally planning to read only 50 books and then I somehow read 100 books by the end of the year and it was alll TOO MUCH. But you have got me interested in adding a whole variety of new columns! And a spreadsheet for shipping, yes YES.

    • Why resist the temptation? πŸ˜‰ Go forth and spreadsheet! Hahaha. (Yes, I’m making that a verb. Hush.)

      Yeah, I think it may get a bit daunting with the upkeep, but if I think about the results it could deliver: clear statistics and charts, more interesting and thorough monthly wrap-ups – I’m quite motivated. πŸ™‚ We’ll see how long that lasts though.

  15. This is the best! I’ve been keeping track of the books I’ve read in a Word document, but this is so so so much better. And you definitely inspired me to keep track of other things now too, like the movies and series I’ve watched because I always forget those, especially movies. And of course I don’t think you’re crazy, I think you’re the best. I’m going to get rid of that stupid document and do it your way. Thank you for sharing! *runs off to make spreadsheets*
    Kim @ The Nomadic Book Hoarder recently posted Review: DefyMy Profile

  16. Wow….I can’t even imagine coming close to this level of organization. You’re on a whole other level!

    I like the idea of a spreadsheet to keep track of books I want to buy/have bought, and how much I’m spending on books. I think I need to budget better this year, and something like that would definitely help! I know we’re only 11 days in, but so far I’ve only bought books with gift money (Christmas), and until I clear out my physical TBR shelf, I’m hoping to stay that way!

    (Except for when Into the Still Blue comes out…that’s going to be an exception! Haha)

    • Hahahaha thanks Kelly πŸ™‚

      Yeah, a spreadsheet for bugeting surely is useful for us book buying addicts. You can easily add the prices to the kind of set up I made – I only haven’t done that because I really don’t want to think about how much it adds up to xD But I can imagine if your budget’s kind of tight, that would be a big help.

      WOW no books until you clear the TBR shelf? Eek. I couldn’t do that. *coughs at 108 unread books* How big is it? ^^;

    • Right? I tried to keep track of all this info on Goodreads, but the number of shelves I had EXPLODED. And it became hard to filter through it. You know, I could go to my shelf for a specific publisher, but with a spreadsheet I can easily hop to that publisher, then search on a specific genre, find a debut author, etc etc. Much simpler πŸ™‚ And now I’m not that dependent on Goodreads, so should the site ever die or anger us all enough to truly leave, I won’t lose all this info.

      Glad you enjoyed the post πŸ™‚

  17. Wow! I love your organizing techniques! I have to make this!
    I was doing a 2014 Reading Log, which I was inspiring for through BookRiot but it was on paper. Which isnt much fun when I have lots of books lying around. This seems easier and I’m glad to have stumbled upon this!
    I’ll be doing the movie/TV series ones as well. I watch so many and would love to keep a track!
    Thanks for this Debby! πŸ˜€ Genius idea!

    • Haha, yeah, writing it down on paper is so risky. It gets jumbled, it gets lost, I’m surprised it actually took me THIS long to come up with the idea to use a spreadsheet.

      You’re welcome! πŸ™‚

  18. Debby I think this is great! I love being organized like this. I have used different spreadsheets over the year for reading/blogging but nothing to this extent. It would be great to have these statistics at hand and you really might have inspired me to do something similar. Thank you for sharing your process and best of luck with 2014! πŸ™‚
    Nicole recently posted Stacking the Shelves (54) – Jan 11thMy Profile

  19. Wow, I could never do this! Good luck!! πŸ˜€ If you can’t keep up, at least keep in mind that the UBB plugin keeps track of statistics for you automatically. πŸ˜‰ They look a bit like this: It may not do everything you want to do with these spreadsheets, but at least you have something to fall back on if you can’t keep up with the manual stats! πŸ˜€
    Ashley recently posted My Old Website Designs (feel free to laughҀ”I did!)My Profile

  20. This is so useful. I happen to love excel. Another thing I would like to keep track of this year is which city the book takes place in. Most of the books I have read this year have been in fictional world in a land far far away. I think it would be interesting at the end of the year to look back. I also love spreadsheets so I’m going to be taking your advice and creating mine for 2014.
    Rachael @ Rachael Turns Pages recently posted Series 2014My Profile

  21. There are so many great ideas in this post! A couple weekends ago I went to a Half Price Books Warehouse Sale, and I could not remember which books I had in a certain series, so it was difficult to know which ones to buy. Keeping a spreadsheet of which books I’ve bought would really help me in that aspect. I also really love how you keep track of your book club; is this a club you do online or with people who live around you? I’ve been wanting to find an organized, online book club, but haven’t had much luck yet.

    Great post!

    Beneath the Jacket Reviews
    Tiffany recently posted Top Ten Books I’ve Read So Far This YearMy Profile

  22. […] Or this one, which allows you to track how much money you spent on books.Β  Or you could read this post, which includes an amazing number of spreadsheets that will allow you to track any bookish thing […]

  23. I love these! I have been working on formatting my own spreadsheets for books among other things. Yours are great and I might steal a few ideas from you. I would not have thought to keep track of whether a book was a debut or not. But it is a great idea!
    Thanks so much for sharing! Now I’m off to the land of digital organization to enter all my books… πŸ™‚
    Amanda Marie recently posted Review: SplinteredMy Profile

Leave a Reply

CommentLuv badge