Click here for the 2019 spreadsheet!
For the past few months I have been happily using my Scheduling Spreadsheet to prioritize and keep track of my review obligations (which has been life changing!). After adding a stats tab and sharing it on Twitter, I received a lot of positive feedback and thought that I would share this resource with the community!
What else are Sundays for if not building a bookish spreadsheet and categorizing each of the 76 books I have read so far in 2018? pic.twitter.com/G1Xw2VK15i
โ Kaleena ๐ Reader Voracious (@kalventure) July 9, 2018
Like any person with a Type A personality, I really like order. A lot. I make lists for my lists and plan pretty much everything. I know some people are crippled by rigidity and schedules, but for me I find them positively freeing!
I get a lot of random ideas for new content, and setting up the schedule not only helps me to prioritize my ARC reading (which is a lifesaver!) but also maintain a consistent schedule. When inspiration strikes I just create a draft post with a basic title and word vomit my idea in the body to jog my memory when I have time to flesh out the post. I literally have 47 post idea drafts right now, and I know that if I hit a reading slump I can easily tap into those ideas so I don’t stress out. Since I am a mood writer, this also ensures that I don’t post like 5 posts in 3 days and then nothing for two weeks. Which certainly didn’t happen when I was over on Blogspot, no siree!
This may not work for everyone, but I decided to create a template of my personal Google Sheet that anyone can copy for their own personal use since not everyone is well versed in using spreadsheets. You can access the spreadsheet template here!
โก๏ธย 2018 Bookish Stats: this is the newest addition to my spreadsheet and probably my favorite… because DATA! I made this based on what I personally want to track – types of book (arc, new, backlist, re-read) and genre. The categories for both tables can be changed and the pie charts will automatically update! Easy pie charts for your blog!
โก๏ธ Reading Order: This was the start of my blogging spreadsheet back in April 2018 and it came to be because I was freaking out about all my pending review requests and needed a place to keep them all straight. You can change the columns if you want to keep track of other data, but the way I use this tab is I decide when I want to schedule the post and sort the entire sheet by “due date” so I can prioritize my reading order accordingly. You can sort by selecting the whole table, clicking on Data at the top, sort range, and then select “column E.”
โก๏ธ Monthly Posting Schedules: Shortly after creating the Reading Order section, I created the monthly calendar to visually plan out my posts. I personally have a rigid posting schedule of Tuesday/Thursday/Saturday/Sunday (this is a bonus post, yay!) so I black out Mon/Wed/Fri and fill in my posts based on the posting dates I determined for reviews and then fill in the rest of my content accordingly. This has allowed me to easily see how far ahead I have planned, and when the posts are actually written + scheduled I updated the cell to green. I created the monthly calendars through December 2018. If this template is useful, I will create an annual template for the community’s use!
This FREE book blogger scheduling and stats spreadsheet is available for anyone in the community to use, and I hope you find it useful! Even if you do not schedule your posts, you are welcome to save a copy of the spreadsheet and hide or delete the tabs you will not use; there’s nothing wrong with just using the review obligations and/or stats!
To save a copy of the spreadsheet in your own Drive, all you need to do is click File -> Make a Copy and use for your own blog to keep organized and have some easy, pre-prepared and auto-updating pie charts that you can use in wrap-up posts! If you prefer to download it as an Excel file, you can do so by selecting “Download as.”
You can access the spreadsheet template here!
What do you think about this spreadsheet? Do you think you will use it? Are there other kinds of stats that I should code for the template? I would love to hear your feedback!
๐ If you like the work that I do here at Reader Voracious, consider fueling my pumpkin spice latte and black tie addiction by buying me a ko-fi! โ
This is such a wonderful resource and itโs lovely of you to share it…
Scheduling is not for me and I donโt have even a single post written in advance, so I donโt know if Iโll use this but itโs great to know I have the option ๐๐๐
LikeLiked by 1 person
Thank you, Sahi!
And I definitely know scheduling isn’t for everyone – whereas it makes me feel less stressed, I know it causes stress for others! If you find that first tab with stats useful you can always just use that and delete everything else that doesn’t work for you.
LikeLiked by 1 person
That sounds perfect for me ๐๐๐
LikeLiked by 1 person
This is amazing Kaleena! Thank you for sharing!
LikeLiked by 1 person
I am looking it over and seeing how I can use it. I just started using a calendar that is literally next to my keyboard right now, but this seems like it would be just as simple. I am finding a schedule to be really helpful. Thanks for sharing this, I appreciate it!
LikeLiked by 1 person
I thought about using like a day planner or something for scheduling posts (and I may if I start scheduling lots of buddy reads!), but I really enjoy using my GoogleDoc because I can access it anywhere, on my laptop, on my phone, on the moon (don’t quote me on that!). Everyone has their own system, and this won’t work for everyone. Thanks for stopping by!
LikeLiked by 1 person
Ooh, I love this spreadsheet so much! Thanks for sharing this, doll! โค
Also, somehow I unfollowed your blog!?!?!? I must've accidentally clicked the button at the bottom of the webpage at some point! *cries* Thankfully, I've realized this and followed once more! Haha ๐
LikeLiked by 1 person
I am glad you like it as I am quite proud of it!!! And welcome back sweets, I am glad you found your way back to me!
ALSO have you started Mirage yet?! Because I am really salty that I have to work instead of dive into today’s reading for our buddy read! *sobs*
LikeLiked by 1 person
Your organization is amazing. You would not love my system…Iโm a mess! This is so helpful ๐
LikeLiked by 1 person
*cackles* As long as your system works for you, that is all that matters! Thank you so much for stopping by, and I hope this helps you a bit. ๐
LikeLiked by 1 person
This is an amazing resource!! Thank you so much for sharing it with us fellow bloggers!!
LikeLike
This is BRILLIANT! I will share it across all my platforms. Thank you so much! Kelly xx
LikeLiked by 1 person
Thank you so much for boosting it, I am sure a lot of your tour bloggers will find it useful!
LikeLike
Ah, this is awesome! I love spreadsheets… but admittedly i’m kinda inefficient with them ๐ i spend hours colouring them and then i forget about them and what info i have on them is kinda random too. ๐
I will take a close look at yours – they look really good.
LikeLiked by 1 person
Spreadsheets are LOVE! I used to also have trouble actually remembering to use the ones I painstakingly created but I have gotten better about it since I use it almost every day because of how I built mine. Thank you!
LikeLiked by 1 person
Such a fantastic resource, thank you! I will give it a go!
LikeLiked by 1 person
You are most welcome, and I hope that you find it useful!!!
LikeLiked by 1 person
I will give it a go – first I have to be organised enough to actually fill it in! lol
LikeLiked by 1 person
Hahaha I know what you mean… but what comes first? The organization or the organization? … er, you know what I mean? That sounded better in my head. BUT this may help you cultivate organization?
LikeLiked by 1 person
I will definitely give it a go! Thanks (I knew exactly what you meant!)
LikeLiked by 1 person
This is so cool! Thank you for sharing it! I’d have no idea where to even start making one of these.
LikeLiked by 1 person
You are welcome, and I hope you find them useful! Thanks for stopping by!
LikeLike
This is amazing thank you so much for sharing this! My blogging has been totally haphazard since I started and I’m starting to crave structure and planning for the posts. This is going to be super helpful in organising posts, thank you so much!
LikeLiked by 1 person
This spreadsheet SAVED MY BLOGGING LIFE! I thrive on organization and things have been so much smoother and less stressful on the blog since I put this together! I hope this works for you and if you think of something I should add let me know. Thanks for stopping by!
LikeLiked by 1 person
Pingback: Links I Loved: July 14, 2018 – The Traveling Inkwell
Pingback: Sunday Post: Pre-order Deals and Giveaways Galore – 7/15/18 – Feed Your Fiction Addiction
Pingback: The Sunday Snuggle W28/2018 #TheSundaySnuggle | Naty's Bookshelf
This is a WONDERFUL resource; thank you so much for putting all of it together! I love keeping track of stats, so I will totally be taking advantage of that template. Also, the reading order one is gonna be a lifesaver for me to keep track of all of my review books!
LikeLiked by 1 person
Thank you so much for stopping by, and I hope that the spreadsheet makes your blogging life a lot easier! I freak out a lot less now that I have the list for all my review obligations handy, haha.
LikeLike
This is fantastic and very similar to the spreadsheet and calendar setup I use for my ARCs and reviews. On my I use my Google calendar so that I can set reminders to go off on my phone when I need to ๐ because well brain fog and neuro conditions are no joke and sometimes I need to be physically yelled at!
LikeLiked by 1 person
Oooh I love your calendar integration! I could probably benefit from alerts. Thanks so much for the comment, love!!!
LikeLiked by 1 person
โค
LikeLike
This is lovely, Kaleena! Thanks for sharing. โค I’ll give this one a go.
LikeLiked by 1 person
Thank you so much for stopping by, Justine, and I hope that you find it useful in your blogging life!
LikeLike
Wow this is such an amazing resource, I admire your spreadsheet skills SO very much right now and you are so organized, that’s so great! ๐ I am certain this will be useful to so many bloggers ๐ Thank you so much for sharing it!
LikeLiked by 1 person
Thank you so much for your compliments, Marie!!! I hope that it is useful to the blogging community.
LikeLiked by 1 person
I donโt know how any book blogger keeps track and stays on top of things without a good editorial calendar!! This is such an awesome resource youโve created, well done ๐๐
LikeLiked by 1 person
Thank you so much for stopping by!!!
LikeLiked by 1 person
Pingback: July Wrap-Up | Never Before Have I Read So Much! – Another Book in the Wall
This is sooo useful๐๐ Do you mind if I link back here on a list of helpful posts for bloggers?
LikeLiked by 1 person
Thanks so much for stopping by and I hope it makes your blogging lie easier! I’d love it if you were to link back and help other bloggers, thank you!
LikeLiked by 1 person
Thank you!!
LikeLiked by 1 person
Pingback: Wrapping up July 2018: a month of lists, and um, overnight fame? (Oh and read for a surprise!) – That Bookshelf Bitch
This is beautiful! Thank you! While scheduling just makes me anxious, I do like all the stat pies ๐
LikeLiked by 1 person
Thanks so much for commenting, and those stat pies give me such life! I hope you find them useful!
LikeLiked by 1 person
Pingback: Monthly Wrap || July – The Words Gremlin
Pingback: July in Review – Reader Voracious Blog
Wow – this is so cool! I have a spreadsheet where I try to track my ARCs and it isn’t nearly as nice as yours. LOL!
LikeLiked by 1 person
Thanks so much for the compliment, Becky! It definitely could be better but it definitely works for me!
LikeLiked by 1 person
I am someone who has a very busy dayjob and never quite know how a week will turn out. Which is pretty much the reason why I donโt stick to a blogging schedule, as I know that I probably would not be able to keep up with it.
That said, this is totally amazing and very helpful to a lot of people that I know. I love the way it looks, and your clear outline in how it works is incredibly helpful. Thanks for submitting such a wonderful post for Jonโs Creator Showcase. Itโs getting tougher and tougher to decide who will be in the final post ๐
LikeLiked by 1 person
Thank you so much for stopping by and checking out this template! I know scheduling doesn’t work for everyone but this is the main way I am able to juggle my fulltime job and all the “responsibilities” of blogging without succumbing to panic. I hope some parts of the sheet will be useful for you, even if it is just the piecharts!
LikeLiked by 1 person
Pingback: Monthly Novel Rewind: July 2018 - Novel Ink
Pingback: July Wrap Up, Part I – What I Read and Bought, Am Reading, Books I’m Excited For and Other Blog Stuff – Librae Paints Pages
Pingback: 10 spreadsheet hacks to step up your blogging game (ft. free spreadsheet templates!) – That Bookshelf Bitch
Pingback: Jonโs Creator Showcase, August Edition, the final post! | Raistlin0903
Pingback: Supporter Award & 6 Month Blogging Introspective – Reader Voracious Blog
Pingback: Weekly Wrap Up #53: Blogoween So Far… – Book Dragons
Wow, you are so organised! Love these spreadsheets and pie charts, I think I’m going to make a few for my blog too ๐ Thanks for this post โค๏ธ
LikeLiked by 1 person
Thanks so much and I hope you find them useful!
LikeLike
This is amazing! Thank you so much for making it available to people like me who are still scrabbling around trying to find their way. It is much appreciated!
LikeLiked by 1 person
You are SO WELCOME and I hope you find these useful! I will be releasing the 2019 version, which is bigger & better, late November so stay tuned!
LikeLiked by 1 person
Pingback: Blogger Recognition Award – Reader Voracious Blog
I am SO excited about this, but a little overwhelmed with it at the moment. BUT TOTALLY BOOKMARKING THIS. I LOVE this I have SUCH a problem with organizing my ARCs and have tried numerous different things to stay organized. I recently tried a planner and put a sticky note on when a book came out and then grabbed it when I was reading it and put it like.. as a flag. That was helpful, but I kinda stopped using it. I want to try this though.
LikeLiked by 1 person
Oh man, the reason this spreadsheet was created was I was starting to panic about all the books I had for review and was afraid of losing track… and then it kind of grew hahaha. I’ve tried a physical planner but for some reason it never sticks for me. My 2019 spreadsheet is bigger, better, and more automated, so if you want you can wait for that one — I’ll be posting it before the end of the month!
LikeLiked by 1 person
I wound up looking into it. I have a lot of 2019 ARCs though! I definitely love the whole thing. Can’t wait to see your new layout!
LikeLiked by 1 person
Planning to post it next Tuesday, so stay tuned!
LikeLike
That’s great! I can’t wait!
LikeLike
Pingback: 2019 Book Blogger Spreadsheet Template – Reader Voracious Blog