Tutorials
·

A reading challenge is a great motivator until it turns into a number you feel guilty about in November. Tracking your goal in Google Sheets gives you more than a progress bar. You can see your pace, your best months and whether you're actually on track, then adjust before it's too late.
Quick answer: To track a reading goal in Google Sheets, log each book with a status and a finish date, count finished books for the year with COUNTIFS, and compare that number with where you should be today. A simple pace formula tells you if you’re ahead or behind. The Book Tracker includes a yearly goal ring and 12 live reading stats that update as you finish books.
How to set a reading goal you’ll actually hit
The best goal is based on last year, not on what other readers post. Count how many books you finished last year, then add 10 to 20 percent. If you don’t know your number, track three months first and multiply by four.
A few other things help:
Count what you want to count. Audiobooks, novellas and rereads all count if you say they do.
Consider a pages goal. If you read long books, pages can be a fairer measure than book count.
Plan for slow months. Holidays and busy seasons happen. Build them into the target.
How to build a reading goal tracker in Google Sheets
Start with a Tracker tab that has one row per book, with Status in column E, Finish date in column G and Pages in column H. Then set up a Goal tab:
Set your goal. Type your yearly target in B1 and the year in B2, for example 30 and 2026.
Count books finished this year. In B3:
=COUNTIFS(Tracker!E:E,"Finished",Tracker!G:G,">="&DATE(B2,1,1),Tracker!G:G,"<="&DATE(B2,12,31))Work out where you should be. In B4:
=B1*(TODAY()-DATE(B2,1,1)+1)/(DATE(B2,12,31)-DATE(B2,1,1)+1)is the number of books you’d have read by today at an even pace.Ahead or behind? In B5:
=B3-B4shows the difference. Positive means ahead.Show progress. In B6:
=MIN(1,B3/B1)gives a percentage of your goal. Format it as a percent.Books needed per month.
=(B1-B3)/MAX(1,12-MONTH(TODAY())+1)tells you what the rest of the year needs.Pages read this year.
=SUMIFS(Tracker!H:H,Tracker!E:E,"Finished",Tracker!G:G,">="&DATE(B2,1,1))
For a visual, add a progress bar next to B6 with =SPARKLINE(B6,{"charttype","bar";"max",1}).

Stats that make a reading goal more fun
Books per month, to spot your best and slowest months.
Average rating, to see if you’re reading books you actually enjoy.
Pages per day, using
=H2/(G2-F2+1)for each finished book, where F is the start date.Top genre and author, with COUNTIF on your Genre and Author columns.
Did not finish count, because quitting a book you don’t like is a good thing.
A ready-made goal tracker: the Book Tracker
The Book Tracker puts all of this on its main dashboard. Set your yearly goal and the goal ring fills as you finish books, next to 12 live stats, a rating chart and a reading status donut. Start and finish dates count your reading days automatically, and your current page becomes a percentage on the Currently Reading tab.
The Year at a Glance tab shows a cover for every month, books finished per month, your top genre and author and the best book in each genre. It also supports multi-year tracking, so next year’s goal sits in the same file.
Book Tracker vs. Goodreads reading challenge
Goodreads challenge: Free and social, but it mainly counts books. Detailed stats and custom fields are limited.
Google Sheets tracker: Private and fully custom. You choose what counts and see pace, pages, genres and ratings together.
Both: Plenty of readers keep their public challenge on an app and their detailed log in a sheet.
Tips for hitting your reading goal
Keep the next book ready. A short TBR list removes the gap between books.
Mix lengths. A novella after a long fantasy series keeps momentum going.
Read in small windows. Ten pages in a queue adds up over a year.
Review monthly. A quick look at the ahead or behind number is enough to adjust.
If you want the full reading log behind these stats, our guide to the Google Sheets book tracker shows how to set one up.
Frequently asked questions
How do I count books read this year in Google Sheets?
Use COUNTIFS with your status and finish date columns, for example =COUNTIFS(E:E,"Finished",G:G,">="&DATE(2026,1,1)).
How do I know if I’m on track for my reading goal?
Multiply your goal by the share of the year that has passed, then compare that with the books you’ve finished. The difference shows whether you’re ahead or behind.
Is a Google Sheets reading tracker a good Goodreads alternative?
Yes, if you want private, detailed tracking. It doesn’t replace community features, so many readers use both.
Can I track a pages goal instead of a book goal?
Yes. Use SUMIFS on your Pages column instead of COUNTIFS on books.
Can I track more than one year?
Yes. The Book Tracker supports multi-year tracking in one file.
The bottom line
A reading goal works best when you can see your pace, not just a total. Build the formulas above into your own sheet, or use the Book Tracker for a goal ring, live stats and monthly breakdowns that update themselves. New here? Enter code WELCOME20 at checkout for 20% off your first order.
