Skip to content
Reading Challenge Tracker cover: a sample sheet with books finished, pages read and average pages per book and a bar chart, beside the Dashboard and Books tabs

Reading Challenge Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

Readers who aim for a set number of books or pages by December will like this tracker. The Books tab holds one row for each title, with author, genre, a status of Finished, Reading or Up next, the page count, the start and finish dates and a Days to finish column that fills in once you enter a finish date. The Dashboard shows books finished, pages read, average pages per book and books in progress, plus a bar chart of pages finished by genre.

Use the page count printed in the edition on your shelf, and enter the start date when you open the book rather than when you buy it, so the days-to-finish figure is accurate. Keep the Up next list short, since a long list tends to stall. If a title stops working for you, move it back to Up next, or leave it on Reading and change it later.

Useful for

  • Tracking a yearly goal of twenty books
  • Seeing which genres filled the shelf each season
  • Sharing a reading list with a book club

What's included

  • 3 tabs: Dashboard, Books, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Books: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Books tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I count pages for an e-book?

E-readers show a location or a percentage instead of a page count. Use the page count from the book's product or publisher page, or from the printed edition, and enter that figure once. Use the same source for every title so the totals are comparable.

Can I count audiobooks?

Yes, but the pages column needs a number, so use the print page count when you can find it. Add a note such as (audio) to the title, so you can tell the formats apart in the list.

What happens to a book I never finish?

It stays out of the Books finished and Pages read totals, which only count rows marked Finished. A book left on Reading does count toward the Reading now figure, so change its status when you stop, and it drops out of that figure too.

  • #habit-tracker
  • #reading-challenge-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More habit tracker templates

See all 15

Also in Business operations

All business operations templates
Get this template

Preparing your template…