2021 Ultimate Book Blogger / Reader Spreadsheet Template

(Last Updated On: April 8, 2021)

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!)

You can access the spreadsheet template here!

As a note: this template began as a book blogging-centric tool but over the last three years I have made it available it has evolved. This spreadsheet can be used by anyone who reads – you don’t need to be a blogger! If you aren’t a book 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 2020 is (finally) coming to a close and we all begin looking towards a new year, I’m excited to share the 2021 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.

Major Updates for 2021

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 2020 version, you will find the spreadsheet functions the same but has some additional features!

Welcome Page & Stats Facelift!

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!

2021 Bookish Stat Charts

⚠️ 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!

Other Features

The rest of the spreadsheet remains unchanged from 2019’s version, but I wanted to include the breakdown in case you haven’t used the template before.

Blog Stats

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.

Blog Stats

⚠️ 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!

2020 ARC List

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!

2021 Owned Books You can easily copy and paste books between the Owned and Reads sheets for easier updating!

2021 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!

2021 Reads

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.

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

Hauls

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.

Buddy Reads.png

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.

Upcoming Releases.png

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 2019 template. You will notice that I’ve included December 2020 in case you want to use this spreadsheet starting now (even though the year is almost over, oops).

You can access the spreadsheet template here!

Make a Copy.pngTo 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.”

Download the Free Template

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. Patrons will get a video tutorial of me setting up my spreadsheet sometime in January if you want a more detailed look at how I use my spreadsheet.

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.

Spreadshhet Customiatio Requests

💖 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!

spacer_wLet’s go on another adventure together!

47 Comments

  1. ityreads

    December 27, 2020 at 6:28 PM

    This is amazing!! Omg. The details that you’ve put into this. Thank you!!!

    1. Kal

      December 29, 2020 at 10:42 PM

      Ahhh, I’m so glad you like it!!! Happy reading!!!

  2. Charvi Koul

    December 27, 2020 at 10:05 PM

    omg, yaaay so glad to see the spreadsheet back! I’ve been re-hashing the 2020 one for 2021 but I guess now I’ll copy the 2021 changes. Thank you so much for this Kal, your spreadsheets literally give me life <3
    Hope you have an amazing 2021!

    1. Kal

      December 29, 2020 at 10:43 PM

      Yessss, more tracking in 2021! I’m sorry it came out a little later than usual… I hope you didn’t do too much work tweaking it yourself. <3 ILY

  3. Abi

    December 28, 2020 at 1:57 AM

    This is amazing! I’m so mad that I’ve not found it previously! (although I have had great spreadsheets from portal in the pages, gotta give Sophie some credit there haha). So excited to download this and have a play around! Thank you!

    1. Kal

      December 29, 2020 at 10:43 PM

      OMG you are too kind, Abi! I’m glad you found it now, and I hope it treats you well in 2021. Happy reading!

  4. Kelsey

    December 28, 2020 at 5:54 AM

    Thank you so much for continuing to put this out – I’m excited to explore the updates!

    1. Kal

      December 29, 2020 at 10:44 PM

      You’re welcome Kelsey, and happy reading in 2021! <3

  5. Caro @ bookcheshirecat

    December 28, 2020 at 10:29 AM

    Thank you so much for this amazing Spreadsheet! I loved using it in the past two years and I’m so excited to use it again in 2021 🥰

    1. Kal

      December 29, 2020 at 10:44 PM

      You’re welcome Caro, I’m so glad you’ve found it useful over the years!!! Happy reading!

  6. Lois @ My Midnight Musing

    December 28, 2020 at 12:27 PM

    This is such a brilliant way to get organised for the new year, and the attention to detail is incredible. Will definitely be using this to keep me in check. Thank you for taking the time to create and update the spreadsheet. It’s brilliant.

    1. Kal

      December 29, 2020 at 10:45 PM

      I am truly humbled, thank you so much for your kind comment Lois! I hope the spreadsheet serves you well and happy reading!

  7. Goals: The Ones We Met and the Ones We Set – Paper Procrastinators

    December 31, 2020 at 7:26 AM

    […] use Kal @ Reader Voracious’s template, but I modified the spreadsheet so that it will be easy to track my specific […]

  8. The Book View

    December 31, 2020 at 3:39 PM

    This spreadsheet saves me so much time! I use my 2020 one all the time and it’s so helpful! Thanks for taking the time to create and for sharing them with us all

    1. Kal

      January 2, 2021 at 9:24 PM

      Ahhh, I love hearing from people who use the spreadsheet! I’m so glad you find it useful and thanks so much for your comment. Happy new year!

  9. In Search of the Elusive Reading Tracker | Bit About Books

    January 1, 2021 at 12:14 AM

    […] updated version. Finally, On Monday night’s #MGBookChat @kalventure shared the 2021 Ultimate Book Blogger / Reader Spreadsheet Template. Once again, Twitter and my PLN to push my learning and allow me to track more efficiently next […]

  10. Mareli @ Elza Reads

    January 1, 2021 at 1:28 AM

    Oh my shattered nerves!! This will be any book blogger or librarian or list fanatic’s dream spreadsheet. Good grief, it must have taken hours doing this. Amazing job. I will have a look a bit and see how it works. I can hardly figure our a normal excel spreadsheet….

    Happy New Year and I do hope that you will be blessed this year. You help so many clueless souls like myself, you deserve a bit of spoils.
    Elza Reads

    1. Kal

      January 2, 2021 at 9:11 PM

      Ahhh a kindred lover of lists! It took ages to set up but I use the spreadsheet literally every day so it’s worth it. If you have any questions about the spreadsheet feel free to give me a poke.

      Happy new year to you and thanks for stopping by, Mareli!

  11. Bec @ bec&books

    January 1, 2021 at 4:17 AM

    Amazing as always! I’ve checked out your spreadsheets a couple of times but really want to commit this year! I really want to have some more reading stats to check out for my wrap up in 12 months. Thank you so much for making that a bit easier.

    1. Kal

      January 2, 2021 at 9:13 PM

      Thank you Bec, and I hope the spreadsheet will serve you well in 2021! Honestly it is a LIFESAVER for me when working on my annual wrap up post (and need to work on best and worst of the year lists)!

  12. December 2020 Wrap Up & January 2021 TBR – The BookNook UK

    January 1, 2021 at 7:50 AM

    […] year Kal at Reader Voracious designs and posts the next year’s uber spreadsheet of uberness. Honestly, check it out […]

  13. Ruth

    January 1, 2021 at 3:46 PM

    This is amazing!! Thanks for sharing.

    1. Kal

      January 2, 2021 at 9:13 PM

      You’re welcome and thanks for stopping by!

  14. Davida Chazan

    January 1, 2021 at 10:22 PM

    Well, I searched and searched your blog for this new one and couldn’t find it – but now here it is! Finally, I decided to take your previous one and copy it to make one for 2021 for myself. See, I tweaked it (a bit) to suit my own reading and statistics I wanted and thought it would just be easier to re-use the 2020 one. Mind you, I might add the Referral type bit, but I’m not sure about the type of publisher, since I’m never really sure about that! In any case, THANK YOU!

    1. Kal

      January 2, 2021 at 9:15 PM

      Yea sorry that I was a little late it getting it up this year! And I love that you tweaked it to suit your own needs as well – publisher type may not be for everyone as there are so many imprints and it’s a confusing mess lol. Thanks for stopping by and happy new year!

  15. Davida Chazan

    January 1, 2021 at 10:33 PM

    Oh, by the way, I’m thinking that the “genre” category isn’t really… flexible enough for me, and I’m not sure how to fix it. See, I see there are non-fiction books and fiction books. Non-fiction has its set of genres (biography, autobiography, history, self-help, philosophy, etc.). Fiction is either contemporary or historical. Then below that it is either literary or genre. Both of these two have their own sub-genres (with some overlaps, of course), and books can encompass one or several of those. How this type of pyramid would be set up in an excel spreadsheet, I’m not quite sure. Maybe… multiple check-boxes instead of drop-down menus? The problem then is… how does that show up on the charts. This might be asking too much from excel. But it is a thought you might want to consider (and you have a whole year to do it!).

    1. Kal

      January 2, 2021 at 9:17 PM

      I totally get what you mean about the genres – I based the list on what the categories are for the Goodreads Choice Awards,and made the decision to not break down into sub genres so as to not overwhelm people. I do think nonfiction should be split up a bit more so that’s good feedback… I’ll tinker and see if there’s a way to expand without giving people a heart attack lol

  16. Aditi

    January 2, 2021 at 2:36 PM

    This is an amazing idea, Kal! I have to admit though, I’m kind of super confused as to how to actually use it 😅 there are so many tabs that I’m kind of nervous I’ll mess everything up! But anyway, this is awesome- have a great 2021!

    1. Kal

      January 2, 2021 at 9:21 PM

      Hi Aditi, thanks for stopping by and I promise it isn’t as scary as it looks (I know it’s daunting!). Feel free to give me a list of the tabs you don’t want to use and I’ll tell you if it’s okay to delete them. That should be a good start at making it more managable

  17. December Wrap Up – Black Goddess Reviews

    January 6, 2021 at 4:49 AM

    […] from Reader Voracious has put together the 2021 Ultimate Book Blogger/Reader Spreadsheet to track all your bookish […]

  18. Favorite Reads of 2020 // ft. books that helped me get through the chaos of 2020 + pie charts – The Thoughtful Voice

    January 6, 2021 at 8:14 AM

    […] Before we get into my favorite books of 2020, though, I want to share some of my reading stats with you! To track my reading for 2020, I used and modified Kal @ Reader Voracious‘ 2020 reader spreadsheet template, which was an absolutely wonderful resource. Thank you so much, Kal! (Here is the link to Kal’s 2021 Book Blogger / Reader Spreadsheet Template.) […]

  19. Mel

    January 8, 2021 at 8:27 AM

    Yesssss the spreadsheet returns! I am very much looking forward to spending my weekend figuring out which spreadsheets I want to use for my reading and uploading everything on my TBR to them. Thank you for giving us this amazing gift!

    1. Kal

      February 2, 2021 at 10:25 AM

      *cackles* IT IS BACK! I hope you had a great time getting your 2021 spreadsheet sorted, and happy tracking!

  20. Dev

    January 8, 2021 at 10:19 AM

    My friend linked me this spreadsheet, knowing how excited it would make me and ahhh i’m already obsessed, thank you so much for making it! I’m definitely going to use it all year <3.

    I did notice one pretty minor error you might want to fix for people who are unaware of how to fix it themselves? on the "Raw Data" sheet, for the age range stats, the middle grade option is set to count books marked "MG" instead of "Middle Grade" making it so that any book logged in as "Middle Grade" doesn't show up on the age range graph. It's such a minor thing that it shouldn't be hard to fix, i was able to fix it in my copy in just a brief second. Sorry for bringing it up if you already knew about it.

    Once again, thank you so much for making this! it's really lovely!

    1. Kal

      February 2, 2021 at 10:30 AM

      Ahh, your friend is a wonderful human for sharing my template! Please tell them thank you for me!!!

      Thanks so much for pointing out the error, I’ve corrected the template – that will teach me to update name ranges lol. Happy reading & tracking, Dev!

  21. QUARTERLY WRAP-UP: Oct-Dec 2020 – quintessentially bookish

    January 8, 2021 at 2:00 PM

    […] Here are my end of the year stats and this year I have a couple of accompanying graphs! Thank you to Kal @ Reader Voracious whose spreadsheet template I used throughout the year to keep a track of my reading! If you want to check out the one they’ve made for 2021 I’ve linked it here! […]

  22. Molly

    January 13, 2021 at 8:35 AM

    Holy Moly! This is the best thing ever. I started the year off with a different spreadsheet and I’m geeking out so hard about this that I am going to transfer all the information over. This is awesome! Thank you so much for all the hard work you put into this.

    1. Kal

      February 2, 2021 at 10:52 AM

      Ahhh, thanks so much for your lovely comment and I’m so glad you found the spreadsheet! I hope it serves you well & happy reading!

      Also, I’m not sure if you’re aware but the link in your WordPress Reader profile is incorrect – it has two : and only one / after https. Just thought I’d let you know!

  23. Dezzy @ The Thoughtful Voice

    January 17, 2021 at 8:28 PM

    just wanted to stop by and thank you so much for sharing your reader spreadsheet as a resource for us!! i used it to track my reading in 2020 and i’m so excited to be using it again this year! thank you again, and i hope 2021 brings you a lot of wonderful reads Kal 😊

    1. Kal

      February 2, 2021 at 10:57 AM

      OMG Dezzy, thank you so much for your comment! I’m really glad to hear it worked well for you last year and hope it serves you well in 2021.

  24. booker talk

    January 27, 2021 at 10:40 AM

    This is a phenomenal piece of work. I can’t begin to imagine how long it took you to create this – especially getting the data to feed through into those graphs. Very impressive!

    1. Kal

      February 2, 2021 at 10:58 AM

      Thank you so much for your lovely comment!

  25. Reading Trackers // How I use StoryGraph, Goodreads, and Spreadsheets – Just A Little Lit Nerd

    March 25, 2021 at 10:16 AM

    […] my own spreadsheet for this year based on Fadwa @ Word Wonders, Shealea @ Shut Up, Shealea, and Kal @ Reader Voracious. I highly recommend checking them out because they wrote in depth posts and created amazing […]

  26. Alyssa @ intotheheartwyld

    March 25, 2021 at 11:59 PM

    Thank you so much for making this, it has helped me a ton in realizing I really need to read the books I own haha.
    I am having an issue though with the 2021 Hauls sheet. The counter for Total Read is not counting the books I mark off, I have tried figuring out what could possibly be wrong but I am at a complete loss, do you by chance know what the issue with that is or how to fix it?

    1. Kal

      March 30, 2021 at 12:36 PM

      Hi Alyssa, I am so glad the sheet helped out — mine properly shames me and my owned TBR lol.
      I’d be happy to take a look at your sheet as I am sure it is an easy tweak, can you DM me on twitter @kalventure?

  27. Alienor

    April 7, 2021 at 1:06 AM

    This is AMAZING, thank you so much!!! I love that ♥

  28. Pedro

    April 11, 2021 at 4:26 PM

    Very interesting, detailed spreadsheet – and the charts!. I also used a spreadsheet to keep track of my home library, but I always struggled with how to properly structure it. I then tried to rely solely on Goodreads for the statistics, but I have realized it is a bit clunky for that. Do you still use Goodreads to log your books? Regards!

Leave a Reply

%d bloggers like this: