Free Excel Reading Log Template — Track Books, Reviews & Annual Goals
Log every book you read with ratings, notes, and genre tags. Automatically tracks your annual reading goal, reading speed, and genre breakdown.
Setting a reading goal is easy. Remembering how many books you actually finished by December is the hard part. This reading log automatically tracks your progress, calculates your reading pace, and shows genre-by-genre statistics — all from a simple book entry.
Key Features
📚 Book Information Tracking
- Title, author, publisher, and publication year
- Genre classification: fiction, self-help, business, history, science, philosophy, and more
- Start date and finish date with reading duration auto-calculated
- Star rating (1–5) and one-line review
- Key takeaway notes for future reference
🎯 Annual Goal Tracker
- Set your yearly reading target (default: 52 books — one per week)
- Current count and completion percentage updated automatically
- Remaining books and required weekly pace to hit your goal
- Visual progress bar
📊 Reading Statistics
- Monthly reading volume bar chart
- Genre distribution pie chart
- Average reading speed (days per book)
- Rating distribution and top-rated book list
🔖 To-Read List
- Queue up books you want to read next
- Record who recommended it and why
- Set priority levels to plan your reading order
How to Use
Step 1: Set Your Goal
In the “Setup” sheet, enter the number of books you want to read this year.
Step 2: Log Finished Books
When you finish a book, add it to the “Reading Log” sheet. Include a star rating and a brief note — these are invaluable when recommending books to others later.
Step 3: Check Your Dashboard
Visit the “Dashboard” sheet to see your goal progress, reading patterns, and genre breakdown at a glance.
Tips
Make Your Notes Searchable
Write down the most memorable quote or insight in the notes column. Later, use Ctrl+F to instantly find that idea when you need it for a conversation or project.
Archive by Year
Start a new file each January and keep previous years saved. Over time, you’ll build a personal reading history that reveals how your interests have evolved.
FAQ
Can I track e-books and audiobooks?
Yes. Use the format column to select “e-book” or “audiobook.” The statistics dashboard breaks down your reading by format as well.
What about books I started but didn’t finish?
Mark them as “abandoned” in the status column. Adding a note about why you stopped helps you decide later whether to give it another try.