Skip to content
The title slide and first slides of the Reading Log template

Reading Log

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
3
Difficulty
Beginner
Updated
November 6, 2026

Every slide (3)

Overview

The Reading Log is a simple record of the books you read. The Books tab holds the title, author, genre, start and finish dates, page count and a rating from 1 to 5. Days to read works itself out once both dates are entered.

The Dashboard shows the books finished, pages read and average rating, plus a breakdown by genre with a chart. It comes with sample data for ten books. Make a copy, replace the sample rows and add your own. Totals, averages and the dropdowns update on their own.

Useful for

  • Keeping a personal reading record for the year
  • Setting a yearly target for books or pages
  • Comparing how long different genres take to finish

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

Is this Reading Log template free?

Yes. Download the template and use it at no cost. No sign-up is needed.

Does it work in Excel?

Yes. Download the .xlsx file and open it in Microsoft Excel. The formulas, dropdowns and chart work there too.

Do books I am still reading count in the totals?

No. A book only counts once it has a finish date. Leave the date empty while you are still reading it.

  • #reading-log
  • #reading-log
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More tracker templates

See all 10

Also in Business operations

All business operations templates
Get this template

Preparing your template…