2022 Reading Tracker Spreadsheet

Hi friends! Can you believe 2021 is almost over? I am super excited for 2022 and all of the reading I’m going to do. In 2020 I started using a reading spreadsheet to track my reading and it really worked well for me. My handwriting is terrible, so I don’t enjoy journaling and I always look for electronic alternatives. The first version of this spreadsheet came out in 2021 and it was immensely popular. So I made an updated version (with your help of course)! I’m happy to report that the 2022 spreadsheet is now available! 

2o22 Reading Tracker Spreadsheet – How do I get it?

The 2022 Reading Tracker Spreadsheet is now available. You can access the spreadsheet below!

2022 Reading Tracker Spreadsheet

As always, PLEASE do not use my spreadsheet as a base to create your own downloadable. 

I’ve also introduced some brand new options this year to my Coffee page this year. You can now request me to make changes to the spreadsheet, or to make an entirely customisable spreadsheet for you!

Customise the reading tracker spreadsheet!

Commission your own reading spreadsheet!

How does it work?

The spreadsheet contains 8 different sheets, each with a different function. I will talk you through all of these sheets, and show you some screenshots from the 2022 Reading Tracker Spreadsheet, and discuss what’s new.

UPDATED – The “Books Read” Sheet

The first sheet you’ll find is the Books Read sheet. This is where you can enter all of the books you’ve read during the year. There are multiple dropdown menus you can use, as well as a “review” column for book bloggers! If you’re not a book blogger, you can simply delete the column.

Some updated features include:

• date started and date finished columns,
• author identity column,
• more publishers added to the list,
• more options for source,
• year hauled dropdown,
• series status dropdown,
• reread tickbox.

NEW – Page Tracker

This was one of the most requested features to be added, so I added it. The page tracker tracks your daily pages read, and then totals your monthly pages read. I did struggle a bit to make this work, but I hope you like it!

UPDATED – The “Series Tracker” Sheet

I made some edits to this page. It gets a bit clunky when you fill in a lot of series. Hopefully, this sheet works better now. Books can be colour coded by the year they’ve been read in. I added two new “statuses”, one being owned/haven’t started – for books you own but haven’t started yet, and the other “upcoming/watchlist” – for book series you still want to read.

The “ARC Tracker” Sheet

This sheet is also mainly for book bloggers, so it can be deleted if it is not needed. The ARC tracker basically allows you to track all of your ARCs, including eARCs.

The “Readathon Tracker” Sheet

We all love a good readathon, so I’ve made a sheet for you to track your readathons! It’s pretty straightforward and can be removed if you don’t want to use it.

UPDATED – The “Hauls and Unhauls” Sheet

Pretty straightforward again, this is a sheet for you to track all the books you buy, and the books you get rid of. I find that I need to track the books I buy so that I don’t buy too many. It’s always good to track these kinds of things to keep addictions under control.

This page has been updated to include a spending tracker!

NEW – Book Requests

This is a new sheet that I found myself using a lot during 2021. As a book blogger, I often request a lot of books and lose track of what I get and what I don’t get. So this is just a basic sheet for you to track which books you’ve requested from publishers.

This sheet can also double as a TBR sheet, if you don’t feel the need to track books you request.

The “Stats” Sheet

This is by far my favourite sheet! This sheet tracks all of your stats (well most of them). The sheet tracks author gender, author status, genre, publication year, age range, format, source, rating, series, and month read.

Note: These stats update automatically. If you tamper with one of the corresponding columns on the “Books Read” sheet, the stats might stop working. I’ll explain how to add your own options next.

The “Categories” Sheet

The Categories sheet is where all of the options for the dropdown menus are stored. I made it so that you can add some of your own options without fuss. For example, if you would like to add a publisher, you can simply type it into the next open space, and the sheet will update it automatically. The stats will also update automatically.

If you run out of space, simply drag the rows down further.

If you need any more help, or if you want to suggest something, you can join our Discord and head to the Reading Tracker Chat, or DM me on Twitter on Instagram.

Enjoy!

Pin This!

+4

0