FREE Bookish Blogger Templates for Scheduling and Statistics

/ Kal @ Reader Voracious

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

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

    • 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

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

    • 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

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

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

    • 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

  12. Pingback: Links I Loved: July 14, 2018 – The Traveling Inkwell

  13. Pingback: Sunday Post: Pre-order Deals and Giveaways Galore – 7/15/18 – Feed Your Fiction Addiction

  14. Pingback: The Sunday Snuggle W28/2018 #TheSundaySnuggle | Naty's Bookshelf

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

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

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

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

  20. Pingback: July Wrap-Up | Never Before Have I Read So Much! – Another Book in the Wall

  22. Pingback: Wrapping up July 2018: a month of lists, and um, overnight fame? (Oh and read for a surprise!) – That Bookshelf Bitch

  24. Pingback: Monthly Wrap || July – The Words Gremlin

  25. Pingback: July in Review – Reader Voracious Blog

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

    • 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

  28. Pingback: Monthly Novel Rewind: July 2018 - Novel Ink

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

  30. Pingback: 10 spreadsheet hacks to step up your blogging game (ft. free spreadsheet templates!) – That Bookshelf Bitch

  31. Pingback: Jon’s Creator Showcase, August Edition, the final post! | Raistlin0903

  32. Pingback: Supporter Award & 6 Month Blogging Introspective – Reader Voracious Blog

  33. Pingback: Weekly Wrap Up #53: Blogoween So Far… – Book Dragons

  36. Pingback: Blogger Recognition Award – Reader Voracious Blog

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

  38. Pingback: 2019 Book Blogger Spreadsheet Template – Reader Voracious Blog

Comments are closed.