Book Blogger / Reader Spreadsheet Template (2020)

We all know that I live by my lists as a very Type A personality. I made the first version of my Book Blogger 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 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.

You can access the spreadsheet template here!

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 2019 is coming to a close and we all begin looking towards a new year (& decade), I’m excited to share the 2020 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 about a week and a half ago.

Major Updates for 2020

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

More Charts & Hiding Underlying Chart Data

Bookish Stats got a bit of a facelift this year! Not only did I add charts for Reading by Source, Reading by Format, Reading by Age Range, and Owned Books vs. TBR but you will notice that the formula tables with the chart data are on a separate sheet now. Once you create your copy, I recommend hiding the RAW DATA sheet completely since it is automatic.

A screenshot of the charts coded into the template

⚠️ All of these tables and charts automatically update based on the information you input on the 2020 Reads and Owned Books tabs – and it is important that you do not change the tab names or delete any columns! The only table you should edit on this sheet is your Favorite Book by month.

UPDATE: The Books by Release chart was incorrectly coded to include the total number read as a slice of the pie. This has been corrected on the template and I explain how to fix it here.

Additional Genres Added to Dropdowns

You will notice that the genre dropdowns on the 2020 Reads and Owned Books sheets got a lot longer! That’s because every genre included in the 2019 Bookish Reader’s Choice Awards (plus other) are now represented.

The ARC List sheet also got a bit of a facelift with genre and audience dropdowns, as well as a new publisher column.

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… which might come in handy for the #StartOnYourShelfathon that The Quiet Pond is running in 2020!

2020 Owned Books

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.

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

2020 Reads

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

2020 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 2018 template. You will notice that I’ve included December 2018 in case you want to use this spreadsheet starting now.

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

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 spreadsheet you can view it here. I hope you find this spreadsheet useful and please let me know if you have any questions in the comments!

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

spacer_wLet’s go on another adventure together!

113 Comments

  1. DB

    December 11, 2019 at 1:17 AM

    Can’t wait to enter all the details in! I loved using the 2019 version – who knew I’m a sucker for charts? It looks great and I’m excited that you were excited to do it all again!

    1. Kal

      December 22, 2019 at 10:31 AM

      When I taught myself basic Excel stuff for work years ago, it was like I discovered a new part of myself. And that part LOVES statistics and charts! I hope you are having a great time with the 2020 sheet!

  2. Rameela

    December 11, 2019 at 1:24 AM

    wow omg this is so detailed I love it!

    1. Lisa @ waytoofantasy

      December 11, 2019 at 2:39 AM

      Fantastic. I might actually try this this year. I usually have my own reading tracker spreadsheet I update but since this has premade formulas it might work better for me in some instances. 🙂 You’re the best, Kal! <3

      1. Kal

        December 22, 2019 at 10:37 AM

        !!! I hope the formulas & their charts treat you well!

    2. Kal

      December 22, 2019 at 10:32 AM

      Thank you so much, Rameela! 💖

  3. Haley

    December 11, 2019 at 2:04 AM

    Your spreadsheet for last year was a godsend, honestly Ka, I’m not sure I would have been able to keep up with my own blog without it, I definitely was cheering like a really excited child seeing the new template lol

    1. Kal

      December 22, 2019 at 10:35 AM

      💖💖💖 I am truly honored that my sheet helped you so much, and I hope the 2020 version is even more awesome for you because YOU ARE AWESOME

  4. Ritu

    December 11, 2019 at 3:29 AM

    Just what I was looking for, Kal. Thank you so much for sharing it.

    1. Kal

      December 22, 2019 at 10:37 AM

      You’re welcome Ritu, and I hope the spreadsheet works well for you!

  5. Evelyn

    December 11, 2019 at 3:46 AM

    Wow, so cool that you made this! I might try and use it 🙂

    (www.evelynreads.com)

    1. Kal

      December 22, 2019 at 10:38 AM

      Thank you Evelyn!

  6. Janis Robinson Daly

    December 11, 2019 at 5:16 AM

    This is great – thank you from one Type A to another!

    1. Kal

      December 22, 2019 at 10:39 AM

      Type A high five! You’re welcome, and happy plotting eVERYTHING

  7. Lorryn

    December 11, 2019 at 5:18 AM

    Thank you so much for making this! I loved the 2019 version and can’t wait to start using the 2020 one.

    1. Kal

      December 22, 2019 at 10:41 AM

      You’re welcome Lorryn, and I hope the 2020 sheet treats you well!

  8. Kayla @ Books and Blends

    December 11, 2019 at 6:16 AM

    You are such an angel in the book community and I love you for taking the time to make this!

    1. Kal

      December 22, 2019 at 10:45 AM

      Awww thanks so much but I am honestly so happy to do it! I’m making the sheet for myself anyways, so I may as well share it! 💖💖💖

  9. Tammy @ Books, Bones & Buffy

    December 11, 2019 at 6:23 AM

    This is an amazing resource that you provide each year! I may try to use it, although I find going old school works best for me. But I do love all the details and how you tailor this to individual needs😁

    1. Kal

      December 22, 2019 at 10:47 AM

      Thank you & I know what you mean about old school! Feel free to use as much or as little of the sheet as works for you & your needs 💖

  10. Jamsu

    December 11, 2019 at 10:57 AM

    Yay new spreadsheet! It can be pain adding things after forgetting for few days or weeks but I loved doing your 2019 spreadsheet and this one looks even more awesome. I already started adding the few release dates I know. I think I’ll just ignore blogging things again like likes, comments, content views because I’m lazy like that.

    1. Kal

      December 22, 2019 at 11:12 AM

      Oh man, I forget to add my hauls as I buy the books and need to update that sheet like once a month and it is a pain in the behind! I hope this sheet brings you organizational joy… and I also ignore the blogging things like stats lmao

  11. Ruby @ Ruby's Books

    December 11, 2019 at 12:42 PM

    THE QUEEN IS AT IT AGAIN AND I AM MOST GRATEFUL! *hands over soul* I can’t WAIT to start filling it in! Especially to help me with my overrequesting of ARCs :))) Thank you Kal, for making this!!!

    1. Kal

      December 22, 2019 at 11:16 AM

      😭😭😭 I am no queen, but thank you all the same! I hope this new version helps you with keeping track and reining in that request monster!

  12. hannawsreads

    December 11, 2019 at 1:55 PM

    You saved me with your spreadsheet this year! No more million different papers everywhere to keep track of everything. Thank you! Can’t wait to start filling this one uo

    1. Kal

      December 22, 2019 at 11:18 AM

      Oh my gosh, I am so honored and happy to hear the spreadsheet helped you! I hope the 2020 sheet is just as helpful for you!

  13. Macey @ Brine & Books

    December 11, 2019 at 2:05 PM

    This is so unbelievably organised!!! It just reminded me about using an electronic calendar. Last semester, I used Google Calendar, and this semester I went back to using a physical planner. I’m actually thinking of trying both this coming semester!

    1. Kal

      December 22, 2019 at 11:19 AM

      I thank my Capricorn nature for being overly organized, because the product of my Type A compulsions is this sheet! I miss using a physical planner in conjunction, maybe I should try again!

  14. merline

    December 11, 2019 at 4:38 PM

    You’re an angel, Kal! Thanks so much for making this wonderful spreadsheet and sharing it with us.

    1. Kal

      December 22, 2019 at 11:20 AM

      You are so welcome, Merline! I make the sheet anyways and love sharing it with everyone!

  15. Whitney

    December 11, 2019 at 5:18 PM

    I was literally just thinking about how I wanted to create a spreadsheet to track my reading stats and here you are with this perfection!! I love it and I can’t wait to use this. Thank you so much for sharing!

    1. Kal

      December 22, 2019 at 11:21 AM

      Ahhh what wonderful timing then! I hope this template serves you well in 2020, Whitney!

  16. Vanessa

    December 11, 2019 at 5:30 PM

    Niiiiice!!! I will for sure be donating ko-fis when I pay off my credit card bills from Christmas shopping. This is so useful and well-designed.

    1. Kal

      December 22, 2019 at 11:23 AM

      Aww thanks for even thinking of donating to my ko-fi, Vanessa! AND I SUPPORT YOU BEING RESPONSIBLE FIRST (/instead)! I hope the sheet serves you well in 2020!

  17. Luna

    December 11, 2019 at 5:43 PM

    This is awesome, thank so much for sharing this! Do you have a link I can buy something through so you get something?

    1. Kal

      December 22, 2019 at 11:25 AM

      You’re welcome, Luna, I hope the sheet works well for you! And thanks so much for the offer — I am an Amazon and Book Depository affiliate if you need to do shopping on either of those sites. My reviews have affiliate links in them that you can click through.

  18. Meaghan

    December 11, 2019 at 6:36 PM

    Kal, I want you to know that you’re my HERO. I loved using the 2019 sheet, and you bet I hauled myself out of bed even though I’m dead tired to come get this one. Worth it, 100%.

    Now, question is, how long is it gonna take me to fill out the owned books sheet? And how painful is that owned vs TBR stat gonna be? 😬

    1. Kal

      December 22, 2019 at 11:27 AM

      😭😭😭 *awkward whale noises* 😭😭😭

      I have been taking AGES to work on the Owned TBR sheet… I got the physical books I own but haven’t read yet on there, but kind of froze when I thought to look at my Kindle lmao

  19. Hannah Renea "HR" Bumgarner

    December 12, 2019 at 7:14 AM

    So excited this is out! I’ve been waiting for the new book blogging template and I can’t wait to use it when I launch my site on Jan 1st, 2020!

    1. Kal

      December 22, 2019 at 11:30 AM

      Ahh, I can’t wait to see your blog when you launch, Hannah!

  20. Caro @ bookcheshirecat

    December 13, 2019 at 10:14 AM

    Thank you so much for this amazing spreadsheet! I loved the 2019 one and I cannot wait to start using this one 🥰

    1. Kal

      December 22, 2019 at 11:33 AM

      You’re welcome Caro, and I hope the 2020 sheet serves you well!

  21. Jenna @ Falling letters

    December 14, 2019 at 10:18 PM

    Wow, very cool! I only tried tracking my reading stats by spreadsheet once a couple years ago but I was thinking of doing it again for 2020. I will have to try this out. Thanks for creating and sharing!!

    1. Kal

      December 22, 2019 at 11:41 AM

      I stopped tracking my stats by spreadsheet about a year ago, but it was really fun to look at a little deeper while I did! I hope the sheet serves you well in 2020, and thanks for stopping by!

  22. Sarah

    December 15, 2019 at 1:04 AM

    You are a spreadsheet goddess! Thank you for sharing!

    1. Kal

      December 22, 2019 at 11:41 AM

      Oh gosh, thank you so much and happy tracking!

  23. Brooklynne Michelle

    December 15, 2019 at 10:34 AM

    OMG!!! This looks so incredibly amazing I instantly downloaded it and am slowly filling in the stats and information there. Question is it possible to add more genres? I like to keep some subgenres separate like magical realism from fantasy, as I tend to read a lot of Magical Realism.

    Thanks!

    1. Kal

      December 22, 2019 at 11:45 AM

      Ahh, thank you so much!!! And yea you can add more genres if you want to — you’ll need to update formulae and whatnot so the chart pulls all the information needed by also adding the genres on the raw data sheet with the appropriate table.

      For the dropdowns, select all of the cells in the column with the genre dropdown, and then go to Data > Data Validation at the top. You’ll see all of the genres there, just add what you want and submit!

  24. Sam

    December 15, 2019 at 11:51 AM

    I am so excited there is an updated version! This was a lifesaver for me this year, and I can’t wait to use it again next year!

    1. Kal

      December 22, 2019 at 11:46 AM

      Ahhh, I am so happy to hear the 2019 sheet was so useful for you & I hope 2020 serves you well!

  25. Lauren

    December 15, 2019 at 1:04 PM

    i think youre truly wonderful and im excited to continue using this for 2020!! thank you, i hope you know how much i respect and look up to you!!!

    1. Kal

      December 22, 2019 at 11:48 AM

      *awkward whale noises* I love and respect YOU so much, so you saying that to me is just like… mind blowing to me. Thank you so much and I hope the sheet serves you well in 2020!

  26. Brooke Carrington

    December 15, 2019 at 3:05 PM

    Wow! This is awesome! I can’t wait to start entering my books!

    1. Kal

      December 22, 2019 at 11:49 AM

      Ahhh thank you Brooke, and happy recording! (I still need to finish inputting mine!)

  27. Leelynn @ Sometimes Leelynn Reads

    December 15, 2019 at 4:47 PM

    omg Kal this is freaking amazing! I have been wanting to keep track better of everything I’m doing reading and blogging wise, and I’m so glad that I saw your post today! I can’t wait to see how I do for 2020 and thank you so much for making this available to the spreadsheet-newbies like me!

    1. Kal

      December 22, 2019 at 11:51 AM

      Ahhh Leelyn, I am so glad you saw the post and I hope the spreadsheet serves you well!

  28. Some Bookish Posts That You Should Definitely Check Out! | Blogmas Day 15 – Bookish Wanderess

    December 15, 2019 at 8:09 PM

    […] as always is amazing and so helpful, recently she shared the Book Blogger / Reader Spreadsheet Template (2020) and if you have a type A personality like Kal or if you just like to be organized, you should check […]

  29. Elley

    December 17, 2019 at 8:52 AM

    I LOVE it, and love the changes!
    One note – on your raw data page, I think your Reading By Source Chart formula for Backlist is wrong – should be <2020, not =02/01/2020″ for the last part of the formula – otherwise books finished on Feb 1st are recorded in both Jan and Feb.

    This is a MAJOR undertaking, thank you SO SO SO much for doing this and for all the super amazing updates to it this year!! 🙂 🙂 🙂

    1. Kal

      December 22, 2019 at 11:58 AM

      Thank you so much Elley, and good catch! Will fix the template

  30. Elley

    December 17, 2019 at 9:24 AM

    This spreadsheet is my everything.

  31. Ariel K

    December 18, 2019 at 7:22 AM

    You are so glorious! Thank you for all the hard work you put into this!

  32. Nicole @ Feed Your Fiction Addiction

    December 18, 2019 at 7:43 AM

    Wow! This is really robust! I’ve been using another spreadsheet (that has a lot of info as well), but I might want to switch to yours (or add yours) to try it. You track a lot here! (I linked you up in my last Sunday Post to help spread the word!)

    1. Kal

      December 22, 2019 at 12:01 PM

      Aww thank you so much Nicole! I don’t personally use all of these sheets anymore, but I know a lot of people do so I erred on the side of “overwhelm with everything & people can delete what they don’t need” haha! Thanks so much for sharing too, I haven’t been hopping lately and pingbacks are ugh on self-hosted. 💖

  33. Lindsay

    December 18, 2019 at 10:02 PM

    By any Chance this has anything with Audio-book? I really enjoy the 2019 version and it as help really well with me my wrapup posts. I really would like to have an audiobook section as well. I will be using this again in 2020.

    1. Kal

      December 22, 2019 at 12:03 PM

      I do have audiobook as a format in the dropdown on the Reads & Owned Books sheets, which correlates with the Reading by Format chart on the Bookish Stats sheet! Is that what you are looking for?

  34. Kelly | Another Book in the Wall

    December 21, 2019 at 10:51 AM

    KALEENA, YOU QUEEN! <3 I've missed you so much since I've been on hiatus, and look at you! Coming out with a newly vamped spreadsheet for 2020! You're incredible! Thank you so much for sharing this, love, and I hope you're having a wonderful holiday season so far!

    1. Kal

      December 22, 2019 at 12:08 PM

      AHHH thank you so much Kelly! 💖💖💖 I am no queen but I accept the compliment all the same! Happy holidays to you too, miss you!

  35. Stacey

    December 23, 2019 at 12:31 PM

    This is AMAZING! I was just looking up ideas on how to create my own but you have done it all. Thank you SO much for sharing this with your readers. I can’t wait to start using it next week!!

    1. Kal

      December 31, 2019 at 7:50 PM

      Ahhh thanks so much Stacey, and I hope the spreadsheet serves you well in 2020!

  36. Greyson

    December 25, 2019 at 10:39 PM

    Totally coming back to this once I start getting ready for the new year. Thank you Kal! 🙏🏻

    1. Kal

      December 31, 2019 at 8:06 PM

      Hope it serves you well, Greyson!!!

  37. Start on Your Shelf a Thon TBR – Reading Parental

    December 28, 2019 at 7:41 AM

    […] The readathon takes place from December 2019 – December 2020. I am also using the amazing spreedsheet by Reader Voracious to help keep track of all my readings for next […]

  38. Jordan @ The Heart of a Book Blogger

    December 28, 2019 at 9:57 AM

    This is amazing! Thanks for sharing—I definitely want to use it to keep track of my ARCs.

    1. Kal

      December 31, 2019 at 8:15 PM

      You’re welcome Jordan, and I hope the sheet serves you well in tracking ARCs (that’s why I started it originally! lifesaver!)!

  39. Avery Delany

    December 29, 2019 at 7:00 AM

    Thank you Kal <3 <3 I've been keeping this bookmarked for the past few weeks so that I can sit down and do it before the New Year, and today is the day! I LOVE filling out your spreadsheet and it has massively changed the way that I read & blog!

    1. Kal

      December 31, 2019 at 8:19 PM

      You’re welcome, Avery, and I am so thrilled to hear how the spreadsheet has helped you! I hope it continues to treat you well in 2020!

  40. End of the Year Survey: 2019 Edition 💗 – The Bookcheshire Cat

    December 30, 2019 at 7:31 AM

    […] to read more about my thoughts!) I’ve also used the 2019 Book Blogger Template by Kal @ ReaderVoracious this year and it was INCREDIBLE! I love how expansive the tracking system was and I used it for […]

  41. Dedra @ A Book Wanderer

    December 30, 2019 at 12:00 PM

    This is so amazing! I’m new to the blogging world and terrible with spreadsheets and numbers, so this makes things so much easier for me. I will definitely be sharing on my blog! Thank you so much!

    1. Kal

      December 31, 2019 at 8:34 PM

      Firstly, WELCOME DEDRA! I hope your book blogging journey has been a fun one so far and will continue to be awesome! I am also so glad to hear that this will be useful to you, happy planning in 2020!

  42. Monthly Wrap || December 2019 – the words gremlin

    December 31, 2019 at 9:00 AM

    […] Kal @ Reader Voracious brings us the Holy Grail of spreadsheets: the 2020 Book Blogger/Reader Spread… […]

  43. Gayathri

    January 1, 2020 at 4:29 AM

    Just as I was thinking about making a comeback to the book blogger world after a hiatus, yours was the first blog Kal. I knew I had to take a look at your new year sheet before making one for myself. Love all the work you do, fellow spreadsheet addict. Happy new year.

    1. Kal

      January 3, 2020 at 9:02 AM

      😭😭😭 OMG Gayathri, I am so honored! I hope this sheet serves you well, and I am excited to hear you are thinking about coming back! Happy New Year, love! xoxo

  44. Darina

    January 1, 2020 at 8:32 AM

    Thanks so much for this, Kal! The 2019 spreadsheet was my lifesaver when it came to organising my reading and blogging over last year so I’m really happy to see one for 2020 as well!

    1. Kal

      January 3, 2020 at 9:05 AM

      You’re welcome Darina, and I’m so honored to hear my 2019 template helped you last year! 😭😭😭 I hope the new and improved sheet continues to make your reading & blogging more organized!

  45. 2019 Wrap Up – Books In Her Eyes

    January 1, 2020 at 2:06 PM

    […] and look forward to using my 2020 log. My 2020 log is a mix of Book Riot’s Reading Log & Reader Voracious‘ log — CHECK OUT MINE HERE […]

  46. 2019 Wrap-Up! – Here There Be Dragons… also magic

    January 1, 2020 at 5:34 PM

    […] they do for you! For 2020 I’ll be using the blogging spreadsheet done up by the lovely Kal, the planner in me is really excited to start using it. But for now, this is what my reading year […]

  47. Rae

    January 2, 2020 at 7:33 PM

    Wow, I love this! Thank you so much for making these, I love charts 😀

    1. Kal

      January 3, 2020 at 9:27 AM

      You are more than welcome Rae, and I hope the sheet serves you well in 2020!

  48. What I’ve been up to in December 🎄 Bachelor Thesis Prep & Christmas – The Bookcheshire Cat

    January 4, 2020 at 7:32 AM

    […] Book Blogger / Reader Spreadsheet Template (2020) (Kal 🎄 readervoracious) […]

  49. Amy

    January 4, 2020 at 8:39 PM

    This is absolutely incredible and such a gift that you’re giving to the community. Thanks so much for sharing!!

    1. Kal

      January 10, 2020 at 10:23 AM

      Awww, thank you so much for your kind comment and I am happy to provide it! I hope it serves you well.

  50. Sepia

    January 6, 2020 at 7:38 AM

    I love how much thought and detail you’ve put into this.I will definitely be using it,thank you!

    1. Kal

      January 10, 2020 at 10:31 AM

      Thank you so much, Sepia! I hope it serves you well this year.

  51. Everlasting 2019// Recap of last year’s resolutions and goals for the new year! – The Everlasting Library

    January 6, 2020 at 10:51 AM

    […] my reading ~ I’m doing this with Kal’s spreadsheet again and I am so excited for all the beautiful pie charts and […]

  52. Harker DeFilippis

    January 6, 2020 at 6:18 PM

    Hi, I do have a question. Under the Reads of 2020 when you can pick how you’ve read the book (arc, author, borrowed, etc.), selecting borrowed doesn’t translate to Library when you look at the Reading by Source chart under 2020 Reading Stats. Is there a way to do that that I’m missing?

    1. Kal

      January 10, 2020 at 10:36 AM

      Hi Harker! That was a minor error on my part (I changed Library to Borrowed to be more inclusive and forgot to update the formaula) that was fixed a few days after the post was made when Petrik brought it to my attention. It sounds like you nabbed it before that fix, so here’s how to fix it:

      On the RAW data sheet, go to cell O13 and change the world Library to Borrowed (keep the quotation marks).

  53. Dini @ dinipandareads

    January 6, 2020 at 9:47 PM

    This is insanely amazing! 😍 I’m hoping that I can be good this year and keep proper track of my progress on all of these throughout the year and not just… give up randomly halfway through. I’m embarrassed to admit that I’m quite prone to doing that 😅 Thank you so much for sharing this amazing spreadsheet, Kal!

    1. Kal

      January 10, 2020 at 10:40 AM

      OMG Dini, thank you so much for the compliment! I hope the spreadsheet serves you well but if you forget or lose track of it that is also okay! I often leave mine for a couple of weeks and then play catch-up, but I also don’t use a few of the parts of the sheet (like stats tracking)

  54. Jas @ XIV blog

    January 7, 2020 at 2:15 AM

    YES! I’ve been trying to figure out how to better organize my reading and blogging life. I’ve tried several things, but this spreadsheet looks so perfect. You thought of everything! Thank you so much for sharing!! <3

    1. Kal

      January 10, 2020 at 10:41 AM

      Ahh Jas, thank you so much for stopping by and I hope this spreadsheet is what you needed to get organized!

  55. Elley Otter

    January 7, 2020 at 10:41 AM

    For the Blog Stats tables, particularly the one with Content # Comments # Likes # Views how do people export this data? Do you manually go back and check various posts and what engagements they got on them? How often do you do this? Is there a way to export this info or something? How do people track this? Would love to hear how others do it. I’m using WordPress, if that helps, so if there’s some secret technique in WordPress to make this easier I’d love to hear it!

    1. Kal

      January 10, 2020 at 10:54 AM

      Hi Elley! 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”

      To answer your questions about frequency, I recommend you do it as often as you want to! I actually no longer use that particular part of the template (stopped tracking my stats like that almost a year ago), but I filled in the #s weekly because I didn’t want to lose a ton of time inputting the data all at once.

  56. Maude

    January 8, 2020 at 9:32 AM

    I’m using WordPress, and I’m having some trouble figuring out how to find the data for blog stats sheet – specifically, for the “Engagement by post type” chart. I can track follower growth and monthly views just fine, and when I post something new, I can add 1 to the corresponding category on the “Posts by category” chart, but how should I gather the data for this one ? Should I wait until the end of the year to compile it, or can I update it monthly ? And if so, how ?
    (I hope I don’t bother you too much, it’s just that your template is absolutely amazing and I don’t want to not use it properly !)

    1. Kal

      January 10, 2020 at 11:09 AM

      For the stats sheet, I totally recommend downloading the CSV file from wordpress! When I used this sheet, I added a “category” tab for what the post type was, and then just input the numbers accordingly. But the frequency is really up 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”

  57. Kim Deister

    January 10, 2020 at 12:41 PM

    This is fabulous and just what I wanted! Thank you so much for all your hard work!
    One note though, on the hauls page, the total read column isn’t picking up anything as read unless it is marked as “Bought” in the 2020 Reads tab, no borrowed or arcs, etc.

    1. Kal

      January 10, 2020 at 1:05 PM

      Thanks so much for letting me know, I will try to work a fix and update the template.

  58. My 2020 Reading Plan – Az You Read

    January 12, 2020 at 5:07 AM

    […] order to achieve this foolhardy endeavor I’ve just started using this BRILLIANT spreadsheet created by Reader Voracious. Guys… Go check it out. When I first opened it, my Ravenclaw heart […]

  59. Liz @ Bent Bookworm

    January 13, 2020 at 4:57 AM

    Thank you so so so much!!! I absolutely loved last year’s and can’t wait to use this year’s!

  60. Emma @ Words And Peace

    January 13, 2020 at 7:36 AM

    Thanks so much for sharing!

  61. Davida Chazan

    January 13, 2020 at 11:39 PM

    This is EXTREMELY impressive. Lots of hard work must have gone into this and you are SO generous to share it with us all. You just… Blew me away! Thank you!

  62. Davida Chazan

    January 14, 2020 at 3:12 AM

    Well, that is worth the price of a cup of coffee, for sure. But… I don’t understand the bit about the series? Also, any chance you could figure out how to do sub-genres, or show me how to add more genres?

    1. Davida Chazan

      January 14, 2020 at 4:31 AM

      Also… what does “retail” mean?

  63. Top Ten Tuesday: Bookish Discoveries in 2019 – GazerofBooks

    January 14, 2020 at 11:12 AM

    […] Book Blogger Spreadsheet by Reader Voracious […]

Leave a Reply

%d bloggers like this: