Your New (Free) Favorite Reading Log

1 month ago 34

If you’ve been looking for a way to track your reading life, we made something just for you. This free Google Sheets reading log template is a warm hug for your inner book nerd. It’s organized, adorable, and honestly? A little addictive.

Whether you’re tracking your progress, collecting quotes, or just want to see how many fantasy books you read, this template is ready for it.

✨ Drop your email below and we’ll send it straight to your inbox.

So, What Is This Reading Log, Exactly?

Imagine your favorite reading journal…
Now give it a glow-up with a smart dashboard, automatic charts, and cozy vibes.

This digital book tracker lets you log every book, rate each one, track your habits, and reflect on your reads all in one place. Designed for book lovers who crave cozy structure, thoughtful reflection, and fewer late-night Goodreads scrolls trying to remember a favorite quote.

Use it on your phone, tablet, or computer. Customize it to your heart’s content. And enjoy the calm of knowing your entire reading life lives in one beautiful, editable spreadshee

What’s Inside the Free Reading Log Template?

The Book Tracker Tab

Screenshot of Reading Log Tracker

This is your personal reading command center. You’ll be able to:

Log the title, author, genre, and format
Set the status: To Be Read, In Progress, Finished, DNF, Wishlist
Watch your progress bar fill as you read
Add start and finish dates (with auto-calculated days to finish)
Rate each book with stars and (optional!) spice scale 🌶️
Save your favorite quote and personal review

Your Dashboard

Screenshot of Reading Log Dashboard

This part? It’s a bookworm’s dream. The dashboard auto-updates with every book you log, so you can easily see:

Select any book from your tracker and instantly view its author, genre, page count or runtime, format, favorite quote, and your review all in one beautiful display
Total pages read and hours listened
Number of books finished
Average reading time per book
Pie chart breakdown of ebook, audiobook, and physical formats
Star rating trends and favorite genres
A monthly reading graph to track when you’re in your reading groove

No additional formulas needed. No spreadsheet skills required. Just plug in your data and watch your reading life come to life.

Why This Tracker Stands Out

There are a lot of reading logs out there, but here’s why this one actually sticks:

Designed with book lovers in mind. No spreadsheet expertise required!

You don’t need to know how to use pivot tables or complicated formulas. This tracker comes with pre-built dropdowns, charts, and formulas. You just log your books, and the dashboards update for you.

Aesthetic & Functional

We added visual charm—cozy gnomes, soft palettes, calming layouts—because keeping track of your books should feel good. This aesthetic book tracker feels like a reading retreat in spreadsheet form.

Fully Customizable

Want to track reading mood? Add a column. Need a place for series names or tropes? Easy. This Google Sheets reading journal lets you edit freely so it fits your style and goals.

Always Up to Date

Unlike a printable reading journal, this one works across devices, updates in real time, and grows with your reading goals. It’s perfect for tracking challenges, book clubs, or even your favorite spicy fantasy trilogies.

Built-In Features Readers Love

Here’s what our early readers are obsessed with:

📚 Track by genre, format, and status
🌟 Auto-calculated star rating averages
📅 See how long each book took you to read
🔖 Favorite quote column for saving the best lines
🎧 Separate minutes tracking for audiobooks
📊 Monthly stats to keep your motivation high
💬 Review space to reflect on what each story meant to you

Who Is This For?

This free reading tracker spreadsheet is made for readers who:

Want a book tracker that’s simple, smart, and beautifully designed
Are constantly setting new reading goals (and actually want to meet them)
Love using Google Sheets, but don’t want to build their first spreadsheet from scratch
Are tired of losing track of their favorite titles, quotes, and ratings
Need a better way to stay on top of reading challenges, buddy reads, or book clubs
Want to reflect on their reading habits and see their growth over time
Are looking for a cozy reading journal

Whether you’re reading a little or a lot, this template turns tracking all your books into something joyful. Just open it, log your titles, and start building a more intentional reading experience right in your own drive.