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 2023 Spreadsheet Template was made available for Reader Voracious patrons early! Patreon supporters are also able to make template suggestions and have exclusive access to a more detailed template version. This 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!
My book blogging and reading experience drastically changed for the better since I put together a spreadsheet to keep track of all of my ARCs! Now that 2022 is coming to a close and we all begin looking towards a new year, I’m excited to share the 2023 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 2023
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 2022 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 2023 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 2022’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!
2023 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.
2023 Hauls
In case you want to keep track of your spending on books, I’ve created a tab called 2023 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 reads 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 2022 template. You will notice that I’ve included December 2022 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.
Elite Spreadsheet & Customization Requests
Thanks to the requests from Reader Voracious patrons, there’s now an even BEEFIER VERSION of the Ultimate Reader Spreadsheet Template!
What’s different in the Elite Version? There are a few more columns on the 2023 Reads & Owned Books sheets that drill information down a bit more specifically:
– Genres got an overhaul because…
– Subgenres are also recorded
– Story Form (Novella, Anthology, etc) are their own section
If you’re interested in reading more diversely and would like to keep track, the last two new additions will be for you:
– Author Identity (BIPOC, LGBT+, Both, none)
– Author Gender (Female, Male, Nonbinary, Multi Authors, Unknown)
Customization Requests
I’m pleased to announce that by popular demand I’m 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 every year!
Of course, I love to share my spreadsheet skills with the community!
Great spreadsheet you have here. If I didn’t have my own that I have created I would definitely use this one! Love that you offer this to readers and content creators! Spreadsheets are the BEST way to track your reading in my opinion. This past year was the first year I was truly consistent and it helped my blogging so much!
Hope you are enjoying the joyful season!
Thanks for commenting and I agree that spreadsheets are the best way to keep track! It’s helped me with consistency since 2018 and can’t imagine another way at this point. Happy holidays!
I didn’t know I needed this in my life, but I’m excited to try it out for 2023!
I hope it serves you well, Veronica!!!
I cannot believe it’s time for another spreadsheet, 2022 went by so fast 😱 Very excited to use your Spreadsheet Template once again, thank you so much for creating it! 🥰
I KNOW, this year flew by so quickly and the time for new year plotting was here before I knew it! I hope the spreadsheet continues to serve you well, Caro!
This spreadsheet is my reading lifeline every single year!
Oh my goodness Cat, I AM SO HONORED!? Thank you so much and I’m happy to help you in your reading journey each year!
This is my favorite time of blogging every year and this year does NOT disappoint. You’re amazing! 🥰
No YOU’RE AMAZING! I’m happy to be able to make your blogging life a little easier every year. 🥰
I LOVE THIS! I too am a Type A, organization freak and definitely want to try this out! Thank you so much for sharing!
Type A, unite! You’re welcome and I hope this spreadsheet helps you stay organized in 2023!
YEE I finally caught up on adding my 2022 reads (and whatever else I’ll be reading before the entire year is done). So NOW I can finally start on the new one! I’ll definitely try adding more anticipated releases to the sheet.
Good job! I may or may not have abandoned recording my 2022 reads back in August and have a lot of updating to do myself. Oops.
THANK YOU SO MUCH!!! This is amazing!!! 😀
YOU’RE WELCOME, I hope you like it!! <3
This is quite a wonderful tool you’ve shared with us! I have something similar and find it so useful and reassuring just to know that all that data is somewhere and I can eventually do something fun with it. Thank you for your kindness and hard work. Keep it up! 😀
Yes, having the data there if I want it is very reassuring for me as well. Thanks for stopping by and for your lovely comment. <3
You are amazing and this makes me want to get super organized in 2023. Thank you for putting this together!
Aww, thanks for you kind words Alicia! I hope this spreadsheet helps you get organized if you decide to give it a go!
Ah this is once again such an excellent spreadsheet, thank you for all the work you put into this and for sharing it!! <3
Thanks so much, Marie! Definitely a labor of love and the culmination of years in the making — but I am pretty proud of it. 😀
I’m actually getting an early start this year! 😉 Kal, thanks again for the amazing spreadsheet that makes keeping track of all things bookish and blogging so much easier. <3