#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 (16)
 

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.

Don't forget to subscribe to comment replies! <3 (it's the little bell symbol)

avatar
  Subscribe  
newest oldest most voted
Notify of
Chloe @ Book Dragons
Guest

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.

Elise @ Roaming Reader
Guest

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

Susy
Guest

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!

Aletha
Guest

I love spreadsheets and all things with lists!! Thank you for sharing!!

Kristina
Guest

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?

Fanna
Guest

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.

Mai
Guest

I used to organize my TBR and blog posts with the help of a spreadsheet, but then I moved to Trello. Never turned back! Whatever works best for y’all though. c:

Carrie @ Cat on the Bookshelf
Guest

I love spreadsheets, but I don’t like using them to say that I must read specific books. I do like using them for my reading challenges, though. I your workbook is very useful.

Stacy Krout
Guest

What a great idea! Thanks!

Kate
Guest

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

Annemieke
Guest

I don’t use a master spreadsheet. No need. 🙂 I know what I have. I do use a spreadsheet for beat the backlist so I know what I still have to submit and what still to submit on review sites for points. But that is physical. I don’t do well with computer spreadsheet/lists haha.

Becca
Guest
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… Read more »
Cait @ Paper Fury
Guest

This is AMAZING AND SO COOL. I admit my spreadsheet is just for books I’ve read and it’s horribly and tackily set out.But functional. Although I’d like to learn how to use a proper one haha. I think it’s amazing that you’ve shared this eeep!!

Ruby
Guest

This was really helpful! I took your outline and adapted it a bit to include stuff I need it to, and now it’s perfect – what a great, little method of organisation! You’ve got to love a list!

Ivyclad Ideas
Guest

Thank you for this! I don’t read and review all that many books a month, but maybe I’ll review more if I track them like this? Even if I don’t, it’s a useful tool and it’s really kind of you to share it with the rest of us! 🙂

lauren
Guest

lovely post as always, about to go and browse your spreadsheet to see what you hve!

lauren
Guest

ohhhh it was just a blank template for us all
Waaa i wanted to see ur books :’)

Laura Thomas
Guest

I’m going to try this. Thanks! I do love lists and mine are just written in a log book right now.

Lucy
Guest

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

trackback

[…] [NewBloggers] What Tools Can Help Me Be An Organized Blogger? TBR Spreadsheets […]

trackback

[…] @ Avalinahs Books shares her handy dandy spreadsheet for tracking your TBR! If your TBR is attempting to plot your demise, check this post out…or just check the post out […]

Brian Joseph
Guest

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.

Astrid @ Vanilla & Spice Books
Guest

I use a spreadsheets too – I wouldn’t be able to work without one! Fantastic post, Evelina!

Sophie Eloy
Guest

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.

Cahleen Hudson
Guest

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!

Kei @ The Lovely Pages Reviews
Guest

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!

Danielle
Guest

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

Amanda @Cover2CoverMom
Guest

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!

Jenn @ Bound to Writing
Guest

Spreadsheets are seriously the best! Thanks for sharing yours! 🙂

Laila
Guest

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. 🙂

Jackie B
Guest

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?!

trackback

[…] Engaged in the Community This simply has to be Evelina @Avalinah’s Books she is super kind and interactive and basically the reason why I know so many people from the […]

Daniela Ark
Guest

I think it is so generous of you to share your tools! sending you love xoxo

Lexxie @ (un)Conventional Bookviews
Guest

Thank you so much, Evelina! I have an excel sheet I use (that I haven’t updated at all in 2018 🙁 ) But this one is much nicer.
I downloaded it as an excel sheet and hope that will work – I’m sure the colors will help me 😀

JJ @ This Dark Material
Guest

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 🙂 ♥

Caro @ bookcheshirecat
Guest

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!

Becky @ A Fool's Ingenuity
Guest

This is genius! Why did I not discover this before my ‘what have I reviewed?’ breakdown post? I’ve got myself a copy and will try and utilise this, especially for my review copies if nothing else. Everyone loves a good list and I love the conditional formatting on it. I may have found this after I needed it but I love it all the same. Thank you for providing the little things that are so useful.

Lover Of Romance
Guest

This SPREADSHEET is awesome and is full adaptable and I love using lists because it helps you keep so organized.

Jovita
Guest

This is wonderful Evelina, thank you. I’ve never had a spreadsheet for tbr’s, I can understand how it will be very helpful with picking what to read next.

trackback

[…] » Evelina @Avalinah’s Books shares a helpful TBR spreadsheet to help us book bloggers → [NewBloggers] What Tools Can Help Me Be An Organized Blogger? TBR Spreadsheets […]

Cee Arr
Guest

Productivity robot from the future. 😉

Also, it’s probably a good thing that you can’t see me blog – I think my lack of organisation and any planning whatsoever would probably freak you the hell out! 😉

Nicole @ Feed Your Fiction Addiction
Guest

As always, I’m amazed at your organizational skills. I track my TBR via Goodreads and my calendar—but it’s mostly because those are the only ways I’m consistent about checking it. 🙂

Wendy @ Falconer's Library
Guest

This is lovely! I really only record books read, and when summer starts I do often draw up a possible list of books to get to, but again, I’m such a mood reader. However, I am also fond of lists and spreadsheets, so I’m still going to check this out!

trackback

[…] posts I’m most proud of in May are the TBR spreadsheets downloadable tutorial, also three things you might not know about Marilyn Monroe and, of course, the first issue of […]

suckerforcoffe
Guest

This is such a helpful tool to tackle my tbr. Thank you Avalinah!

Karla Strand
Guest

Thanks so much for this! One question: what is an overdue ARC?