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

Posted by

Hi! Iโ€™m Kaleena: book lover, runner, wanderer, and philanthropist. Life is an adventurous gift: through the outdoors and books. I run Reader Voracious Blog, where I post spoiler-free book reviews of science fiction, fantasy, speculative fiction, and mystery & thriller.

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

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

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

      Liked by 1 person

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

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

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

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

    1. 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. 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 โค๏ธ

    Liked by 1 person

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

    1. 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!

      Liked by 1 person

Comments are closed.