Book Tracker - Excel

Here is the thing nobody tells you about being a reader: remembering what you thought about a book is harder than finishing it. You close the last page of The Housemaid by Freida McFadden, know you loved it, and three months later cannot recall a single detail. This Book Tracker Excel spreadsheet fixes that. Seven tabs, one workbook, zero subscriptions.

The Books tab holds up to 500 titles. Each entry captures the book cover, author, language, genre, sub-genre, year, page count, reading status, and ownership status. You also rate every book across five categories — Overall, Story, Characters, Originality, and Style — so your opinions are locked in while they are fresh. That matters when you are deciding what to recommend or what to pick up next.

The Quotes tab saves passages you want to keep. Each quote links back to its book and gets its own rating, so the lines that stuck with you do not disappear into a dog-eared page. The Critic Ratings tab records scores from Goodreads, Barnes & Noble, and Google alongside a direct URL to the review. You see how your rating compares to the crowd without switching between browser tabs.

The Journal tab logs daily reading sessions by date, book, and minutes read, with space for notes. A weekly progress chart shows your pace over the past seven days. Weekly and monthly goal trackers display exactly where you stand against your targets. The Dashboard pulls it all together: total books tracked, total books read, total pages read, total items in collection, collection value, books currently reading, plus bar charts of your top-rated and critic top-rated books and a pie chart of critic rating coverage.

This is a local Excel file. No account, no monthly fee, no internet required. It is fully editable, so you can adjust columns, colors, and categories to match how you actually read. Free updates and free support are included.