2019 Book Blogger Spreadsheet Template

We all know that I live by my lists as a very Type A personality. My book blogging experience drastically changed for the better in July when I put together a spreadsheet to keep track of all of my ARCs, and I made the FREE 2018 Book Blogger Spreadsheet Template available for anyone to use. And I am here with the exciting news that the NEW & IMPROVED spreadsheet template for 2019 is now available!

I don’t know about you, but as 2018 draws to a close I have started to look towards 2019. Setting goals. Planning content. Scheduling buddy reads. For those of you that like to schedules and data, the promise of a new year is exciting. But who wants to create a new spreadsheet to keep track of everything? Ya gal here spent the past several weeks improving the spreadsheet. There are a lot more tabs and the spreadsheet does a lot more than it did before, so this post will break it down for you with lots of screenshots. Let’s get into it!

You can access the spreadsheet template here!

Bookish Stats

Think of this page as the wrap-up goldmine! I have coded automatically updating charts for the total number of books read each month, breakdown by book release (ARC, backlist, etc), books by genre, and a ratings breakdown.

Bookish Stats

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

Please note that the Release and Genre pie charts will show up when there is at least one book recorded on the 2019 Reads tab!

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.

ARC Statistics & Tracking

Ah, the reason that I created the first spreadsheet! This essentially is just a prettier and more functional version, but I also added a request success tracking in case you are interested in keeping track.

ARC Tracking.png

2019 Reads

This is by far my favorite tab, I think! This sheet provides the data that feeds into the main Bookish Stats tab. Honestly I have been using this method for a month now and it makes wrap-ups so much easier!

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.

2019 Hauls

In case you want to keep track of your spending on books, I’ve created a tab called 2019 Hauls! I actually went back through my email receipts and created one for 2018 a couple of weeks ago 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.

Daily Stats.png

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.

calendar.png

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 want to see my spreadsheet you can view it here, but know that information will not be populated until 2019 begins.

I hope you find this spreadsheet useful and please let me know if you have any questions in the comments!

Changelog & Updates

As best as I tried to break the sheet before launching, I likely missed some things that will cause the sheet to act up (and sometimes Excel likes to Test Me by not auto populating even though arrays are correct…). I added a Changelog to the main spreadsheet template where I will put fixes and updates. See below for the running list of corrections.

Changelog 2019


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


spacer_w

Let’s Connect!

Twitter Bloglovin’ Goodreads Pinterest

239 thoughts on “2019 Book Blogger Spreadsheet Template

  1. Pingback: December Wrap-Up + January Reading Month (2018-19) – Unputdownable Books

  2. Pingback: Dancing Out of December 2018 – A Dance With Books

  3. Hello. I really like the layout of your spreadsheet. I’m hoping to use it for 2019 and am attempting to backlog my 2018 reads. However, I’m having trouble with the #Books vs. Month chart and table not auto populating. I used the same format as the example on the 2019 Reads Page (I did rename it 2018 reads, does that make a difference?), so I’m not sure what I’m doing wrong. I would greatly appreciate help. I’m not well versed in Excel or Google Sheets.

    Liked by 2 people

  4. Pingback: december rewind \ swimming in winter

  5. Pingback: 2019 Reading and Blog Goals – Reading With Moose

  6. Pingback: 2019 Bookish Goals – Fi's Bibliofiles

  7. Pingback: Happy 2019 🎉 – Bookwyrm Bites

  8. Pingback: Wrapping Up 2018 – Bluestocking Bookworm

  9. Pingback: I Check In On My 2018 goals and make highly-likely-to-fail 2019 goals (feat. lots of GIF reactions) – Librae Paints Pages

  10. Pingback: December Wrap-Up; blogging resolutions, reading resolutions, friends made, bloggers whom I admire… – Bookish Wisps

  11. Pingback: I've Already Found My Favorite Book Of The Year! And Some Other 2019 Things | AvalinahsBooks

  12. Pingback: Retrospectively Reading (60) – The Reading Shelf

  13. Pingback: Everlasting 2018// GOALS for the New Year because who doesn’t love goals?? (especially the part where you fail and stuff yourself with cake) – The Everlasting Library

  14. Pingback: Top Ten Tuesday: Most Anticipated YA Releases for the First Half of 2019 - Becca Leighanne

  15. Pingback: Top 10 Tuesday | 2019 Most Anticipated Releases – Red Rocket Panda

  16. Pingback: TOP FIVE WEDNESDAY #6 | 2019 Reading Resolutions – Kaitlyn's Cozy Reading Corner

  17. Pingback: Studious Saturday: My reading and blogging goals for 2019 – Facing the Story

  18. Pingback: 2019: let’s get this show on the road

  19. I was poking around, setting up my copy and I’m running into trouble with the stats. I filled in my daily stats, but not sure how to tell it what post type it is for the charts to work correctly.

    Liked by 2 people

  20. Pingback: State of the ARC: Jan 2019 – Bookwyrm Bites

  21. Pingback: January 2019 Wrap-Up + State of the ARC – a thousand worlds

  22. Pingback: january wrap-up – what the log had to say

  23. Pingback: January Reflection – Bookwyrm Bites

  24. Pingback: FREE Bookish Blogger Templates for Scheduling and Statistics – Reader Voracious Blog

  25. Pingback: Wrapping It Up: JANUARY 2019 – Mind of Luxe

  26. Pingback: How I Stay on Top of New Releases // Edelweiss Guide 2.0 – Reader Voracious Blog

  27. Pingback: February Wrap-Up – The Caffeinated Reader

  28. Pingback: Behind the Blogger Tag — All about ME! – Reader Voracious Blog

  29. Pingback: February Wrap-Up and March TBR – Happy Reading Co.

  30. Just found this, and though I’m late, I thought I might use it anyway! I was wondering, what kinds of books does the Literary genre in the 2019 Reads refer to?

    Liked by 2 people

    • Hey there, never too late to get started! And I put Literary as Literary Fiction, the kinds of books that get Pulitzer’s and whatnot. You can change the genres if you want to on your sheet — if you need help with that dm me on twitter @kalventure!

      Liked by 1 person

  31. Pingback: Stats Transparency Post & Lessons Learned from One Year of Blogging – Reader Voracious Blog

  32. Pingback: Top Ten Tuesday | Things That Make Me Pick Up a Book – Happy Reading Co.

  33. Pingback: Prescheduling, Blog Organization & Mood Blogging #BESpring2019 – Bookwyrm Bites

  34. Pingback: BOOKENDING SPRING 2019: I Give A Sheet – Fictionally Sam

  35. Pingback: I give a Sheet - Spreadsheets for Bookbloggers - Walking Through The Pages

  36. Pingback: Planning With Jei: Setting up my Monthly Book Blog Spread – Read – Write – Live

  37. Pingback: Ways To Organise Yourself & Blog (BEspring19) – Book Dragons

    • Yes you can! Highlight the genre column and in the menu select “Data” and “Data Validation.” Change the terms in the box and press okay. Then on the rollup page for stats, you will need to update the fields for the genre (L5-T5) for your new genre =COUNTIF(‘2019 Reads’!J2:J,”Classics”). Just change “Classics” to whatever the new genre is and hit enter.

      Good luck and let me know if you have any trouble!

      Like

  38. Pingback: Month in Review // Greyson Unplugged – April | Part 2 – Use Your Words

  39. Pingback: How I Track My Reading – The Reading Shelf

  40. Pingback: May in Review // A Month of Reading ALL the Things – Reader Voracious Blog

  41. Pingback: Top Ten Tuesday | Books from my Favorite Genre – Fiction No Chaser

  42. Pingback: Halfway There: A 2019 Reading Check-in! – Realms of My Mind

  43. Pingback: 2019 Mid-Year Reading Check In – Fictionally Sam

Comments are closed.