It’s the most wonderful time of the year for those of us who love all things data! We all know that I live by my lists as a very Type A personality. I made the first version of my Book Blogger and Reader Spreadsheet Template in July of 2018. Since then, I have updated and improved the template each year and made it available to anyone who wants it for free. (If you want to leave me a tip to support my work, please check out my ko-fi!)
As always, the 2022 Spreadsheet Template was made available for Reader Voracious patrons early! Patreon supporters are also able to make custom requests and template suggestions. The template will always be free, but if you’d like early access, the ability to make requests, and more perks you can help support the work I do for as little as $2 a month!
About the Spreadsheet Template
This template began as a book blogging-centric tool but over the last three years I have made it available it’s evolved. This spreadsheet can be used by anyone who reads – you don’t need to be a blogger! (If you aren’t a blogger, simply delete or hide the sheets that do not suit your needs.)
For more low-maintenance readers, check out Shealea’s Ultimate Reader Spreadsheet! This spreadsheet doesn’t dive as deep into stats and charts but allows you to track diversity and author identity details, among many other fantastic information that I chose to not include on my template.
My book blogging experience drastically changed for the better since I put together a spreadsheet to keep track of all of my ARCs! Now that 2021 is (finally) coming to a close and we all begin looking towards a new year, I’m excited to share the 2022 Spreadsheet Template with you all! This is my best one yet if I do say so myself – and my patrons got access to the spreadsheet to test & make requests earlier this month.
Updates for 2022
Over the last several weeks I have been working on this year’s iteration of the template and working with my Patrons to incorporate some of their wishlist items. If you used the 20201 version, you will find the spreadsheet functions the same but got a bit of a facelift!
Welcome Page & Stats Facelift!
You’ll notice that this year the spreadsheet’s design was refreshed to reflect my blog’s branding (and honestly it is a much better color scheme). Of course, once you download the template you are welcome to customize the colors how you like, but I wanted to give it a fresh bit of paint for those lazy folks out there.
Bookish Stats got another facelift this year by pulling the # books read table onto the RAW Data sheet. You’ll also notice a couple new charts for Publisher Type and How I Heard About My Reads that were suggested by patrons! There is also an ARCs Read By Month chart that’s been added.
⚠️ All of these tables and charts automatically update based on the information you input on the 2021 Reads, ARCs, and Owned Books sheets – and it is important that you do not change the tab names or delete any columns!
Template Features
The spreadsheet features remain unchanged from 2021’s version, but I wanted to include the breakdown in case this is your first time using my template (welcome!). (Please excuse the old screenshots, it wasn’t worth doing new ones for the new color scheme.)
Blog Stats Tracking
The next tab on the spreadsheet template is for blog statistics data in case you want to keep track. In addition to follower growth tracking, I also added tables for tracking monthly views over time, views and engagement by post type, and posts by category.
⚠️ The charts are all automatic based on the tables, but you will have to manually add the data from your WordPress or Blogger dashboard. This is how you can export your post data from WordPress:
Click on Pages & Posts from your Stats page –> switch view to All-Time –> Scroll to the bottom of the page and click “Download data as CSV”
ARC Tracking
Ah, the reason that I created the first spreadsheet all that time ago in 2018! The spreadsheet sure has grown over the years but keep tracking of all my ARCs in one place is still the primary function for me.
Note: The “retail” checkbox is something I started using so I don’t forget to cross post my reviews onto retail sites like Amazon and Barnes and Noble. You can hide this column if you don’t want to use it.
Owned Books
If you want to keep track of all the books you own, the Owned Books sheet is for you! But not only that, but there is also a chart that shows your ratio of owned books that you’ve read. The Owned vs. Read pie chart adequately shames me whenever I update this list!
You can easily copy and paste books between the Owned and Reads sheets for easier updating!
2022 Reads
This is by far my favorite tab, I think! This sheet provides the data that feeds into the main Bookish Stats tab. This makes my monthly wrap-up posts so much easier to compile!
There are two new columns on the reads sheet: Referral Type (AKA “How I heard about the book”) and Publisher Type (IE. Big 5, Indie, Self-pub). There are new charts to represent this data if you’re interested in looking at how books get on your radar and the breakdown of books read in different publishing sectors. Thank you to my patron Vicki for these suggestions!
⚠️ It is important to not delete columns or rename anything on this sheet, otherwise you will break the automatic formulas on the Bookish Stats sheet & Raw Data.
2022 Hauls
In case you want to keep track of your spending on books, I’ve created a tab called 2020 Hauls! I actually went back through my email receipts and created one for 2018 and it was kind of shocking, so I find it pretty useful to keep track and curb my spending.
💬 Related Post: How I earn extra cash online to buy books & budgeting tips
Buddy Reads
Do you like to buddy read? Me too! So much that I found myself scheduling a lot and losing track. It’s coded so you can filter out finished buddy read if you wish.
Upcoming Releases to Stalk
If you have a huge TBR and your anticipated shelf on Goodreads is a hot mess like mine, you can use the Releases to Stalk tab! I am using this to keep track of what I want to watch out for, request, pre-order, and highlight in Anticipated Reads.
💬 Related Post: How I stay on top of new releases using Edelweiss
Daily Stats
I doubt anyone but Sam wants this, but if you want to keep track of your daily stats here you go. I made this for myself because I am looking for statistical patterns and Sam liked it so she told me to include it. You can delete the sheet if this isn’t of interest to you.
On WordPress, this is how you can export your post data:
Click on Pages & Posts from your Stats page –> switch view to All-Time –> Scroll to the bottom of the page and click “Download data as CSV”
Scheduling Calendar
Last but certainly not least is the scheduling calendar that I use when planning my posts. This is unchanged from the 2021 template. You will notice that I’ve included December 2021 in case you want to use this spreadsheet starting now (even though the year is almost over, oops).
Download the Template
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.”
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!
If you use my sheet as a starting off point to tinker and customize to suit your own needs, that is wonderful! But do not share your own versions of my spreadsheet as downloadables.
✨ If you want to see my 2020 spreadsheet you can view it here.
NEW! Customization Requests
I’m pleased to announced that by popular demand I’m now accepting customization requests for users of my spreadsheet template! Perfect for small personal tweaks to data and guaranteed to not break the spreadsheet. Updates are for personal use only.
💖 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 or joining my Patreon! ☕
I hope you find this spreadsheet useful and please let me know if you have any questions in the comments!
Thank you so much for doing this template again! I have been using it for two years and love it to track my bookish life! ❤️
Absolutely, I love revising and improving the sheet each year! I hope it serves you well once again. <3
Thanks again. Just so you know, I’ve been tweaking this new template myself (I’m pretty good with Excel. For instance, for the drop down menus, I’m having the sheets use the titles in the Raw Data sheet, so if I change or add a genre, it will show up on the column as a choice. I still haven’t figured out how to do a multiple check box, so I can choose more than one genre, though. In any case, I made a separate list for era – like: contemporary, historical, future/fantasy, dual timelines, and multiple timelines. I also made a separate one for overall type – fiction, non-fiction. I’m also adding a form category where I can say if it is a novel, novella, short story, play, or collection). There are some good things on this new one. But… the one thing I don’t understand is how you figure out the number of likes/comments etc. for your posts. There don’t seem to be any calculations there and I’m not sure where I’d get that information from on my blog.
Look at you go with teaching yourself how to tweak! I AM SO PROUD!!!
Yea sadly the likes/comments for blog posts is all manual 😩 I just finished compiling my personal data for 2021 on my own sheet and it takes some time to do but I love seeing it! If you are on WordPress, go to Posts & Pages where you can see the views for each post. You’ll want to switch it to Year and then scroll all the way to the bottom of the page and click the Download File as CSV link. You’ll get an excel file with the post title, permalink, and total views and then you can tweak things from there.
I added a column for “Post Category” and then categorized each post, deleted the permalink column as I didn’t need it, and then selected the entire table of data. Insert a Pivot Table on a new sheet and it will add the views/comments/likes for each category for you!
I am working on a Patreon deep dive on my 2021 stats — I’ll see about including something on how I got my data as well. LEt me know if you have any questions!
I love your blogger spreadsheet, Kal. Thanks for taking the time to create it again and to offer it to everyone for free! You are a blogger hero!
Awww, thank you so much Flora and I’m happy you find it useful!
You’ve put so much work into this and it shows! Thanks for sharing another amazing spreadsheet Kal 😊
😭😭😭 Thanks so much for your comment, Sumedha! It’s been a labor of love but I am so proud of how it’s developed over the last 4 years!
Thank you so much for making this every year and for all the work you do!
OF COURSE Kayla, I am always happy to help others get the data they crave! ILY!
Ah you’ve done it again. Thank you SO much for the incredible work you’re putting into this spreadsheet every year, I admire it and you SO much! Thank you for sharing this <3
THANK YOU so much, Marie! It just brings me so much joy that the spreadsheet helps so many other people
thank you for sharing your template! i used it this year and have found it so helpful!!
You’re welcome and I’m so glad you found it useful! May it continue to help you organize your reading life in 2022!
Clicking on this post like IT’S THE MOST WONDERFUL TIME OF THE YEAR…
For real, though, Kal, your spreadsheet is pretty much the love of my life and I look forward to the updated version every single year! Thank you for making such an outstanding, thorough resource!
Hi Kal, Thank So so much for creating such an epic spreadsheet!! and for free too you’re truly amazing.
A friend of mine has started filling her copy in but we have noticed there might be an error on the raw data tab where the books are counted each month. She has filled in two for Jan so far and it shows 2 in Jan, 2 in Feb and 1 in March…I am not good with IF formulas but its picking up rows instead of the column, not sure if that’s the problem…
I thought I’d flag it with you, I was unable to play with the formula because the tab is locked (for good reason I know)
Thanks again!
Best,
Marteen
Hi Marteen, thanks so much for your comment and I will take a look at the template to make sure something wonky didn’t happen when updating the sheet’s formulae for 2022. If your friend’s sheet is still doing it, let me know and I’m happy to take a look at hers specifically to correct it!
Hey Kal! I’m working on my mid-year update and realized my spreadsheet is doing this, as well. It looks like all the months are set to February.
Thank you so much for providing your spreadsheet every year! It’s such a life saver for me! <3
Weird! If you have twitter or discord, please reach out so I can take a peek and correct the formulae for you. <3
Glad the sheet is useful to you and thank you for the ko-fi!