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