Book Log Excel Template: Your Reading Year

Hey folks, it's Ren here. I am writing this on a train, fields sliding past the window, with a battered paperback face-down on the tray table.

I just finished it somewhere around the last station, and before the feeling fades I open a spreadsheet and type one line: the date, the title, four stars, three words about how it landed.

That single row is the whole idea. A book log Excel template is not a dashboard you maintain; it is a dated diary of your reading, one line at a time.

"I cannot remember the books I have read any more than the meals I have eaten; even so, they have made me." — Ralph Waldo Emerson

📖 Why a tracker and a log are not the same thing

A tracker is a live dashboard of your whole library, statuses and shelves and totals all moving at once. Useful, but it is a lot to keep current.

A log asks for one thing: a line when you finish a book. That is it.

Please do not be hard on yourself if full trackers have defeated you before. A log survives the busy months precisely because there is almost nothing to maintain.

• One row per finish, so it never feels like admin.
• Nothing to update mid-book, so a slow week costs you nothing.
• It reads back like a diary, which a status dashboard never does.

📝 What a dated Excel log gives you

A book log in Excel is a short table: date finished, title, author, rating and a one-line note.

The dated note column is the part people skip, and it is the part you will treasure.

A rating tells you a book scored four stars. A one-line note tells you it was the one you read on the train through the mountains, the one that made you miss your stop. A year of those notes is something you actually want to re-read.

Here is the quiet bonus that makes Excel the right home for it. Because every finish is already a dated row, a single PivotTable turns the same log into a year-in-review: books per month, average rating, your top genre, with no extra work at all.

You keep the diary you enjoy writing, and the statistics fall out of it for free.

✅ Build it in ten minutes

1. Make five columns. Date finished, title, author, rating and a note; that note column is the heart of it.
2. Add a row each time you finish. One line, thirty seconds, while the book is still fresh in your mind.
3. Sort and filter freely. Sort by date for a timeline, filter by rating to find your five-star reads in a second.
4. Insert a PivotTable. Point it at the log for an instant year-in-review you can refresh whenever you like.

And because it is a real Excel file, you can print it. A reading year on a single page is a lovely thing to tuck inside a journal or pin to a shelf.

If you would rather your log live in the cloud and sync to your phone, the book log spreadsheet guide covers the same diary idea in the format twin to this one.

🎯 Your reading week, sorted

• Set up the five columns, with the note column front and centre.
• Log the last book you finished, even if it was weeks ago.
• Insert a PivotTable so the year-in-review builds itself.
• Print the page at year's end and keep it somewhere you will see it.
• To turn those finishes into a daily habit, pair the log with a reading log Excel template that records each session as you go.

💬 Common situations

If you have tried trackers and never kept one going

Start with a log, not a dashboard. A book log Excel template asks for one line when you finish a book: date, title, rating, one sentence. There is nothing to maintain and no streak to break, so it survives busy months. Open it, type a row, close it. By December that handful of lines has quietly become a year of reading you can actually sit and re-read, which is what makes you want to keep going.

If you want a record you can look back on, not just stats

A dated log is the answer a dashboard cannot give you. Numbers tell you how many; a one-line note tells you what a book felt like. Add a short note column and a year from now you will remember why a five-star read mattered, not just that it scored five. The log reads like a travel diary of your reading: a list of places your year took you, in order, in your own words.

If you also want totals without extra work

Let one PivotTable do it. Because every finish is already a dated row, a single PivotTable turns the log into books-per-month, average rating and your top genre with no extra typing. You keep the diary you enjoy writing, and the stats fall out of it for free. That is the quiet advantage of Excel: the record and the numbers come from the same handful of columns.

Happy reading,
Ren

The train is slowing, the paperback goes back in my bag, and there is one more dated line in the file. Come December, that quiet list of rows will read like a map of where the year took me.