Reading Log: Printable Page Plus a Live Spreadsheet

Hey folks, it's Ren here.

Somewhere in my house there is a receipt from a petrol station, folded in half and wedged at page 212 of a novel I put down in August. It has a title scrawled on the back and a date, and that is my entire reading log for the year.

It works right up until I want to know how many books I finished. Then I am sorting bookmarks across three rooms.

A proper reading log fixes that, and the printable versions are where most people start. This guide covers what to put in one, how many sheets a year of reading really needs, whether to log each book or each sitting, and what the 453 book trackers we sold this year suggest about how people read.

"The more that you read, the more things you will know." — Dr. Seuss

📖 What is a reading log, and what goes in it?

A reading log is a record of your reading, kept one line at a time. It answers the questions memory gets wrong: what did I read, when did I finish it, and was it any good?

It is not the same as a reading list. A list is what you plan to read, while a log is what you did read. The reading list spreadsheet guide covers the first, and this page covers the second.

A log that survives past February usually has these columns and not many more.

• Title and author: the minimum, and enough to find the book again.
• Date started and date finished: the finish date drives every total you will want later.
• Pages or minutes: pages for print, minutes for audio.
• Format: print, ebook or audiobook, which helps if you listen as well as read.
• Rating: one to five, decided the day you finish.
• One line of notes: the sentence you will actually enjoy re-reading.

If you want a journal-style log with a reflection on every sitting, the reading log Excel template is built that way. This page leans towards the leaner book log you can print.

🖨️ Should you use a printable reading log or a spreadsheet?

Use both: log in a spreadsheet, and print the page you want to see. A printable alone goes out of date the moment you finish another book, while a spreadsheet alone has no page to pin up.

Here is how the three options compare on what readers actually care about.

What you want	Static printable (PDF)	Spreadsheet only	Spreadsheet you print
Totals that stay right	No, frozen when printed	Yes	Yes, on every print
A page for the wall or journal	Yes	No	Yes
Room for more books	Runs out of rows	Endless rows	Endless rows, print the latest
Log from your phone	No	Yes	Yes
Backup if you lose the page	None	Saved automatically	Saved automatically

If you like the feel of ink on paper, nothing here asks you to give that up. You log in the sheet for a few seconds, and the paper is a view of the file, not the file itself. The book tracker spreadsheet guide shows the wider system a log sits inside.

📄 How many sheets does a printable reading log need?

For a typical reader, a book log needs 1 sheet a year and a session log needs 15. That is the number most printable guides skip, and it decides which kind of log you should print.

Here is the worked example. Take a reader who reads 30 minutes a day, every day, at about 40 pages an hour. That is 182.5 hours and 7,300 pages a year, which is 24 books of 300 pages. These are illustrative figures, so swap in your own pace.

A printed page holds about 25 rows. Logging each sitting means 365 rows, which is 15 sheets. Logging each book means 24 rows, and the whole year fits on 1 sheet with room to spare. Even a book a week, 52 rows, takes only 3 sheets.

The writing time moves the same way. At 15 seconds a sitting, a session log costs about 91 minutes of writing across the year. At 60 seconds a book, a book log costs about 24 minutes. Those timings are my assumption, but the ratio is the point: the session log is fifteen times the paper for the same books.

⚖️ Should you log each book or each reading session?

Log each book if you want a record of what you finished, and log each session if you want to see how you read. Most readers want the first, and most printable logs quietly push the second.

A book log answers what I finished, when, and what I thought. A session log answers when I read, for how long, and whether I kept a habit going. Both are useful, and they need different sheets.

• Book log: one row at the finish line, about a minute of effort per book, a page that stays readable for years. It is what the book log spreadsheet guide builds out.
• Session log: one row every sitting, a daily habit, a page that fills fast. The reading tracker spreadsheet is designed for that daily count.

If you want a daily habit but a tidy wall, do the two in the file and print only the book log. The sessions stay in the spreadsheet where they belong, and nothing prints that you do not want to look at.

Audio changes the column, not the idea. Swap pages for minutes and the same log works, as the audiobook tracker spreadsheet shows.

📊 What do readers actually buy a reading log for?

In our own shop, readers overwhelmingly come in through the phrase reading log. I counted the book tracker spreadsheets sold on Etsy between 18 March 2026 and 7 June 2026, and sorted them by what the listing was named.

Count	Book tracker units	Share
Sold since 18 March 2026	453	100%
Listing name includes "reading log"	418	92%
Shipped to the United States	284	63%

Treat that as a pattern and not proof. I chose the listing names, so the 92% tells you what we put in the title, not what each buyer typed. It does fit the search data: in a September 2026 Keyword Planner pull for the US, reading log shows about 8,100 searches a month, against 3,600 for reading log printable and 1,600 for book logs.

It also fits what readers tell me. They rarely ask for a tracker with charts. They ask for somewhere to put the books so they stop losing track.

🖥️ What does a reading log spreadsheet look like?

A reading log spreadsheet is a table with one row per book and a few columns, and the good ones add totals above it. This is the Book Log tab of the Book Tracker 2.0 in blue, using its sample data.

Notice how little each row asks for: title, author, dates, pages, rating and format. That is a short row to fill in once a book is finished, and the other tabs read from it, so you do not type anything twice.

🛠️ How do you print a reading log from Google Sheets or Excel?

You print a reading log from a spreadsheet by choosing a print area, fitting it to one page wide and printing only the columns you want on paper. It takes about two minutes the first time and none after that.

1. Choose one line per book or per session. Pick the question you care about, because that decides the layout.
2. Set up five columns. Title, author, date finished, pages and a rating, plus a notes column if you like.
3. Log each book when you finish it. Add the row the same day, while you remember what you thought.
4. Set the print area. Select the columns, set the area and fit to one page wide, so nothing spills onto a second sheet.
5. Print a fresh page when you want one. Reprint after a few books, so the page on the wall matches the file.

In Google Sheets the print screen has a fit-to-width option, and in Excel it sits under page layout. If you want an Excel-first walkthrough, the reading log Excel guide and the reading log Google Sheets guide both cover the phone side.

🚫 Mistakes that stop a reading log working

• Logging every sitting on paper. Fix it: keep sittings in the file and print only the book log.
• Starting with fifteen columns. Fix it: begin with five and add one only when you miss it.
• Waiting until the end of the month. Fix it: log the book the day you finish it.
• Printing a PDF with frozen totals. Fix it: print from the spreadsheet so the numbers are current.
• Skipping the rating. Fix it: decide the stars while the book is still in your hands.

🎯 Your reading week, sorted

• Decide whether you want a book log or a session log, and write the choice on the sheet.
• Set up the five columns and log the last three books you finished.
• Set the print area and print one page for the wall.
• Log the next book the day you finish it.
• If you also want a yearly challenge number to chase, the reading challenge spreadsheet adds a target without changing the log.

💬 Quick questions

What is a reading log?

A reading log is a record of what you read and when. At its simplest it lists the title, author, the dates you started and finished, and a rating or a sentence of notes. It can be one line per book or one line per sitting, on paper or in a spreadsheet.

What should a reading log include?

At minimum, the title, author and finish date. Add pages, format (print, ebook or audio), a rating out of five and one line about what stayed with you. Everything else is optional, and a log with five columns you fill in beats one with fifteen you abandon.

Can I print a reading log from Google Sheets or Excel?

Yes. Set a print area, fit the columns to one page wide and print. Because you log in the sheet first, the totals are right before a page comes out, and you can reprint whenever the numbers change.

Is a reading log better on paper or in a spreadsheet?

Neither wins outright. Paper is calm and tactile, while a spreadsheet adds totals, filters, backup and logging from your phone. Most readers do best logging in the spreadsheet and printing one page for the wall.

A reading log does not need to be clever. Five columns, one line per book and a sheet on the wall is enough to turn a pile of folded receipts into a record you can read back.

Happy reading,
Ren