#NewBloggers 101, Book blogging, Discussion

[NewBloggers] What Tools Can Help Me Be An Organized Blogger? TBR Spreadsheets #NewBloggers 101 post number.. I've lost track!

So hi everyone! This is an unexpected post, but I think it will be useful to you. Let’s say, this is a surprise continuation of the Efficient Blogger series! A little while ago, I posted this tweet, and as it turns out? Everyone adores lists! And now you all want my TBR spreadsheet:

So, I’ve decided I’ll whip up a quick post and just let you all grab a copy of this file. It’s fairly simple – there are loads of other, much cooler spreadsheets out there that other book bloggers have created! But sometimes simplicity is key. So you can all access the TBR spreadsheet here. It will open as ‘view only’, so what you should do is go to the menu and select ‘Make a copy…’, and then you will have your own file on your own Google drive:

save a copy

Now let me explain a little bit how the TBR spreadsheet can be used

You might have already gathered that I’ve already set up the colors for you. So if a book is read or reviewed, it will turn green, etc. You don’t have to change anything about that, it will just work. What you might need to do is simply make copies of the sheet for when you need to create a new TBR list for a new month, or a new readathon, or for whatever you might want to have it. This is how you do that – right click on the sheet name at the bottom and select ‘Duplicate’:

duplicate

This will give you a whole fresh sheet that you can use separately for whatever you want (in the same file.) I suggest maybe leaving the template as a separate sheet so you don’t have to do a lot of deleting when you make a new one! And the only reason there are any filled lines in the sheet is so you could see all the options 🙂

Now for those of you who are more google sheets savvy, you can also make up your own definitions for the dropdowns – that’s what the ‘Definitions’ sheet is all for. If you have more statuses, say, ‘DNF’ or something else, just put that extra word in the Status column and it will appear as an option in the dropdown of the column you wrote it to. Useful! The only thing is that it will not change color if you add it. You’d have to open up Conditional formatting for that and add that extra color. If you want to do that you can message me and I can help you figure it out.

So that’s all! I use a lot of other spreadsheets for my reading, not just this one – but the others are complicated and messy, and I don’t really have a final version to share with you all! However, that’s how I track the books I read and the books I hauled, and even when my review copies are due. Otherwise I’d get lost! Another big plus of tracking it this way is that it’s accessible on the phone, so you can just mark things down as you finish the book, you don’t even have to wait till you come back on your computer.

As I said, I know that other master sheets exist like this one – and others that I can’t remember and link for you right now, so my option is definitely not the only one! Feel free to explore my TBR spreadsheet though, and based on it, create your own solution and figure out what works best for you. Either way, I hope you like the final sheet you get and all the sudden productivity that results, heh!

So happy tracking! And here are all the other #NewBloggers posts if you want some more bookworm hacks:

Expand List

2018 (14)
 

And… bear with me.. I gotta do this… MAY THE FOURTH BE WITH YOU!!!!

What kind of master sheets do you use for your reading? Or do you track everything in a paper journal? Maybe you have other resources? Don’t hesitate to share!

I’m Evelina and I try to blog about books that matter, with a bit of fun there too! Disability and equality will be topics you see a lot, but there’s also a lot of scifi, fantasy and… GIFs. I’m also the proud founder of #ARCsAnonymous.

73 thoughts on “[NewBloggers] What Tools Can Help Me Be An Organized Blogger? TBR Spreadsheets #NewBloggers 101 post number.. I've lost track!

  1. Eeeek I’m off to snoop on your sheet in a moment cause I need help with my TBR. I use a mixture of my blogging journal and a sheet to track my blogging and reading. I have a sheet which needs updating now but it’s basically a link log of all posts on my blog, and then I have my editorial yearly calendar sheet which I’m loving it really helps me plan ahead and my journal helps me see what’s happening in the current month.
    Chloe @ Book Dragons recently posted…Dewey’s Readathon ~ Wrap UpMy Profile

    1. I don’t have a link sheet because I don’t know if I need that, but I have a read books and hauled books sheet 🙂 and of course a calendar, plus now a TBR sheet 😀 hope you like this one!

  2. I’ve never thought about making a spreadsheet for my TBR but I might try this out. Idk I think I’ll give it a shot for the summer and hopefully it works as well for me as it does for you lol I’m just such a mood reader that I’ll usually try to plan out reads but it doesn’t always work bc I end up reading something I never even previously thought about

    1. Yeah, it’s quite productive 🙂 I actually used to be a mood reader! But then I turned into a blogger :DDD but it’s a good thing if you’re a mood reader. I would still totally be one if I didn’t have ARC commitments 😀

  3. I prefer paper journal. I have a bullet journal just for my reading and I love using it (even if I am not so consistent with it in this period… shame on me), but your post is really interesting and I love your list! I may try it for some challenge, and I adore lists! So thank you very much for sharing!
    Susy recently posted…Series Maniac! #1My Profile

    1. I would love keeping a paper journal as well 🙂 but I can’t because that would mean I’d have to drag it around (I stay in two places a lot of times) so I’ve had to come up with an alternative 😀
      I hope you can use it for a challenge like you say! Thanks for reading, glad you liked it 🙂

  4. Oh yaay Thank you!

    I don’t have any google doc experience..but I did followed a course of the whole microsoft suite – including excel, which *looks* like it’s similar?

  5. I think I sound repetitive appreciating all the efforts you take to be the most supportive and helpful person out there. BUT again, THANK YOU! This spreadsheet is definitely super savvy for me because I suck so bad at Excel and you know all about the spreadsheet I was working on LOL 😀 Even though I added a lot of things to my spreadsheet, I really like this one of yours for the drop down things <3 <3 They're so technical, haha.

    1. Thank you! <3 so you'll be using it? That's so cool :) yeah, you can just copy paste parts of it into your own spreadsheet. Just as long as you can put it to good use :) or just see how the setup is done and do something similar in yours.

    1. I use Trello for my work tasks! It IS great, but for some reason, it doesn’t work for my blog xD possibly because I just don’t want to see it anymore when I’m done with work 😀

  6. This is great! I use Google Sheets to organize my TBR too and it made my life a heck of a whole lot easier!

    1. Whatever works! My memory is a sieve cause I juggle so many things at a time, that I would rather not bother with remembering, especially because most of the stuff I have is electronic, so I can’t make a stack of physical copies to know what I have to read 😀 that’s mostly why I use a list, eheheh. Oh yeah, totally – beat the backlist definitely requires a list though, because it’s way too easy to get lost. I still have to submit everything for this month, I think xD

  7. You are a gem to us all!

    Even if it’s simple, I love seeing how other readers, reviewers, and bloggers organize themselves. I have changed my organization so many times, mostly because I haven’t found the PERFECT FIT yet. I’ve used other spreadsheets in the past that just haven’t worked for me and I’m way too lazy to do my own atm.

    At the moment I am using a mix of my bujo (I track reviews that need to be done and the books I read each week and carry over whatever isn’t finished to the following week) and the listography website to track my ARCs. For some reason my ARC list always gets messy and lost, so I’ve had to separate it from my bujo.

    But maaaaybe retrying an excel sheet is the way to go.

    1. Awwww Becca thank you! ;_; <3

      It's part of the fun though, changing the way you organize your blogging, isn't it 🙂 getting ideas from others and changing them to suit your own needs.

      Listography website? Ooh! I haven't heard of that one 🙂 I feel like I need to check it out!

      YESSSSS my ARC list also always gets messed up or lost whenever I write one xD that's why I made that spreadsheet 😀 I am sort of glad to hear I'm not the only one 😀

    1. Thanks! Actually, my hauls and reads spreadsheet is also a loooot messier than this one, cause things are constantly going on in it, so it’s not as cool xD it makes my counting easier though. So it’s at least a little bit SMRT. LOL

      Well, you can just grab this one and sort of see under the hood 😀 conditional formatting (the colors) can be really cool, especially for to do lists and such 🙂 my dream is to figure out one which tells me which ARCs I have to read ASAP, but it’s just… too much work. And I don’t know conditional formatting THAT well xD

    1. Thank you! That’s so cool, what adaptations did you implement? It’s really good that you customized it, I love it when people take an idea and make it even better 🙂 and yes, lists are LOVE 😀

      1. LOL yes 😀 I can send you a screenshot of my books though 😀 doubt you will know a lot of them though cause quite a few are old obscure ARCs that I need to get off my chest lol xD

  8. This is such a cool idea! I don’t think it’s for me but it will definitely be great for some people, thank you for sharing!

    Lucy // lucyturnspages.co.uk

  9. It is so neat that you are this organized. Personally I tend to get very organized witch some things in life but so far not with my reading. I do not accept ARCs however, I would need to have things more together if I did.
    Brian Joseph recently posted…Nostromo by Joseph ConradMy Profile

    1. Thanks, Brian 🙂 actually, I think I’m the other way round 😀 I am a very messy person (in terms of items, rooms, cleaning), but very organized and even OCD when it comes to work and blogging 😀 it’s odd. But yeah, if you don’t accept ARCs then it’s different! Nobody dictates your reading choices but you 🙂

  10. Well this is really organized Evelina! I simply use my Google calendar. I plan the date for ARC’s reviews (when they are due) in one color and I enter the date where I should begin reading my ARC in another color. I look at it with a “monthly” view to check that I did not request too many ARCs and see where I have room for my “moody” reviews.
    Sophie Eloy recently posted…May TBR: a mix of adult and young adultMy Profile

    1. Haha, thanks 🙂 I hate using my Google calendar for my blog stuff because it’s got my real life stuff and work stuff already, so it’s just a huuuuge mess xD and I don’t feel like it’s very functional either. But I don’t really like using that calendar for my life stuff either, so maybe it’s just that I don’t really like their interface 🙂

  11. You and my husband would really get along! He loves spreadsheets. I’m lazy and just use Goodreads to track everything, and just recently I started putting my ARCs in my google calendar. I just put them in on their publication date and set a notification to go off one week before to remind me. I really think this is cool, though!
    Cahleen Hudson recently posted…The week of my Elizabethan England obsession.My Profile

    1. Well my blog just ate my comment 🙁 dang… Anyway, I used to read Goodreads for that same purpose too, but now I can’t because I only review books on there as I review them on the blog, so they spend way too long in the ‘currently reading’ folder. For example, there are books that I finished in January that I still haven’t had time to review, so they’re not marked as ‘read’ yet. So I’ve had to devise my own system xD

  12. I’m too lazy to use spreadsheets and I don’t accept that many ARCs anyway, I just went from 7 to 5 which is not bad at all for me. What I love using though is a bullet journal, I’ve been using it for three years now and it’s the most organized I’ve ever been!

    1. Yeah, if I had 7, I would probably also not use spreadsheets 😀 but when it’s so many you actually start needing a special meme to deal with them… Then you start needing spreadsheets, lol 😀 congrats on keeping a low number of ARCs! I sort of envy you and I hope I can clean up nicely like that too 🙂
      Bujos are also very cool. I’d love to keep one, but right now it’s not convenient. But one day! 🙂

  13. I love that you are sharing this! I live for excel and spreadsheets haha <3 I have learned all of the ins and outs while running all of the reports at our pharmacy, and now I utilize those for home. I have sheets for everything! I have a TBR/Review one right now and one for upcoming posts. As well as one for monthly bills and budget. Love them haha. I think this will be a huge help for many – xx
    Danielle recently posted…Sunday Sum~UpMy Profile

    1. Yes! Yess!! I am SUCH a spreadsheet nerd 🙂 I almost believe that anything could be solved with spreadsheets, ehehehe 😀 you should see the one I made for work, OMG. It takes in all the team’s time and puts out these nice charts on how we are doing on each client, working too much or too little, and balancing our expenses… It’s SO AWESOME xD it’s by far the spreadsheet I am most proud of 😀 my boss laughs that I’m proactive and do these things without being asked and that’s awesome, while in reality, I just really like making spreadsheets so of course I’ll gladly make one if I see it fit xD xD

      Anyway, tangent 😀 heh. Actually, I am still very, very rusty on the conditional formatting of the spreadsheets, but slowly getting there (considering I’m not really learning but rather looking up bits and pieces when I need it xD)

      I used to have the bills and budget one. Then I realized it’s making me depressed and anxious xD so I just stopped… LOL some things are better left under the rug 😀

      1. I had to chuckle because we are two peas in pod! I just made two statistics spreadsheets will call stats, hours worked, etc for two of the departments at our pharmacy last week. What are the odds? I like your style

  14. Oooo Thank you so much for sharing this template! I’ve been wanting to start a spreadsheet to track my Netgalley ARC’s for a while now, but I never could just sit down and make one ((LAZY)). Now I have one to get me started, and I can even tweak it to my needs!

  15. That is very cool and I can see how it would be most helpful. I don’t do ARCs because I have a huge TBR list anyway and don’t want the pressure. I do keep my TBR list on Goodreads. And a paper book journal for completed reads. I admire people as organized as you! Also, I just found your blog somehow although we’ve been Twitter followers for a while now. 🙂

    1. That’s very smart of you not to do ARCs 🙂 I can’t resist them 😀 or rather.. I couldn’t resist them in the past 😀
      And I’m only as organized out of necessity 😀 otherwise I would not remember a thing! LOL
      I’m so glad you found my blog then 🙂 that does happen with Twitter 😀

  16. I’m really surprised this is the first time you’ve talked about this spreadsheet on your blog! I guess that I’m so used to talking with you I cannot separate what we discuss privately versus what I read on your blog. A good thing, I guess? 😀

    This spreadsheet is awesome! I’m so glad everyone agrees on that point. I love the idea of tracking this content for each month or readathon. If I wasn’t such a mood reader, I’d use this for more than NetGalley, that’s for sure. How large is your version of this spreadsheet?!
    Jackie B recently posted…We’re Back, Baby! 5 Things I Learned During an Unplanned HiatusMy Profile

    1. Actually xD this is the first time I came up with this spreadsheet! 😀 well, a week or two before I posted this post, I mean. I did use a spreadsheet for my books, but not one nicely color coded and all. One a bit messier 😀 but yeah, we might have talked before – and I only posted now cause I had posts scheduled, and I don’t like moving them, it’s a hassle.

      So my version isn’t very large yet because it’s new, but I’m planning to just use it for every month to write down what I need for NetGalley, Edelweiss and author copies, things that come out, etc 🙂

    1. Oh wow, you actually liked my setup more than your own spreadsheet! I am absolutely honored 🙂 so happy to hear that. I hope you find it nice and comfortable to use. Yes, the colors are indeed half the fun 😀

  17. I’m a little late to the party, but this is amazing Evelina!! I’ve already bookmarked your post so I can come back and spend a proper few hours getting everything organized and ready to update in my own copy of the spreadsheet. Thank you so much for sharing such an amazing tool 🙂 ♥
    JJ @ This Dark Material recently posted…book review: stalking jack the ripperMy Profile

    1. I’m glad you found it useful 🙂 have you organized your own version of the spreadsheet yet? I hope it ends up being convenient for you to use in the end. It’s best to use on the go, when you’re on the phone 🙂

  18. I’m still very grateful that you shared your spreadsheet with us! I have been using it ever since and really love it 🙂 What can I say? Lists are the best and I love tracking my Reviews, because it helps me write them in time!

Leave a Reply

Your email address will not be published. Required fields are marked *

CommentLuv badge