FREE Bookish Blogger Templates for Scheduling and Statistics

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!

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!

Screenshot of the 2018 Book Blogger Stats Template

โžก๏ธย  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.”

Screenshot of the reading order template

โžก๏ธ 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!

Monthly Posting template example for July 2018

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!

How to save the template to your Google Drive


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! โ˜•


spacer_w

Let’s Connect!

Twitter Bloglovin’ Goodreads Pinterest

68 thoughts on “FREE Bookish Blogger Templates for Scheduling and Statistics

  1. Sahi says:

    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 ๐Ÿ˜Š๐Ÿ˜Š๐Ÿ˜Š

    Liked by 1 person

  2. Grey Winters says:

    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!

    Liked by 1 person

    • Kaleena @ Reader Voracious says:

      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!

      Liked by 1 person

  3. Kelly Brigid says:

    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 ๐Ÿ˜€

    Liked by 1 person

    • Kaleena @ Reader Voracious says:

      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*

      Liked by 1 person

  4. Norrie says:

    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.

    Liked by 1 person

  5. the bookaholic dreamer says:

    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!

    Liked by 1 person

    • Kaleena @ Reader Voracious says:

      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!

      Liked by 1 person

  6. Madalyn @ Novel Ink says:

    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!

    Liked by 1 person

  7. (Danielle) Books, Vertigo and Tea says:

    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!

    Liked by 1 person

  8. Marie says:

    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!

    Liked by 1 person

  9. Sheree @ Keeping Up With The Penguins says:

    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 ๐Ÿ˜๐Ÿ˜

    Liked by 1 person

  10. raistlin0903 says:

    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 ๐Ÿ˜Š

    Liked by 1 person

    • Kaleena @ Reader Voracious says:

      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!

      Liked by 1 person

  11. devouringbooks2017 says:

    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.

    Liked by 1 person

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.