Ultimate Book Tracker - Book Tracker Spreadsheet for Excel & Google Sheets
Your own file • Excel & Google Sheets • Pay once

Remember Every Book You've Read. Track It Your Way.

Reading apps never quite track it the way you read: they're clunky, they miss your rereads, DNFs and audiobooks, and you still can't remember what you thought of a book two years later. The Ultimate Book Tracker is one file you own. Enter a book once and your notes, TBR, series, library and stats fill themselves in. Excel and Google Sheets, both included.

  • Every book you've read, with your rating and notes
  • Every format your way: audiobooks, rereads, DNF
  • Your TBR in one list you can filter
  • Every book you own and where it is, so you stop re-buying

$297$9Instant download • Excel & Google Sheets • Private, your own file • Pay once

The Ultimate Book Tracker on a laptop: the reading dashboard for 2026 and a book card with a rating, notes and a favourite quote

Your own file, on any device

Microsoft Excel
Google Sheets
Mac & PC
iPhone & Android

Why a Sheet Works When Reading Apps Didn't

It tracks what you want, the way you read. When nothing in an app works how you want, your own file does: every field is yours.

Track It Your Way

Paperback, hardback, ebook or audiobook, start and finish dates, half-star ratings, series, and your own genres, shelves and tags. Five statuses: TBR, Reading, Read, DNF and Rereading.

Remember What You Read

Every book gets a card with your rating, review, notes and favourite quotes. Search a title years later and read back what you thought of it, written for future you.

My Library

My Library shows every book you own, which shelf it's on and who borrowed it. Search a title before you buy and check if you already own a copy.

Your Reading in Numbers

A dashboard for any year: books read, pages, hours listened, genres, authors, formats and books per month, plus a monthly wrap-up ready to screenshot.

Your Own File, Private

It lives in your Google Drive or on your computer. Nothing to sync, no update can wipe your library, and nobody sees your ratings or reviews.

Pay Once, Room for 5,000 Books

Room for 5,000 books, no 20-book cap. No ads, no account, no subscription. Switch the year filter and use it again next year.

What's Included

Everything Included

Start & Log (3 Tabs)

Start Here (set up in 3 steps, how covers work, a short FAQ), Settings (your own formats, sources, statuses, genres, shelves and tags, plus your yearly goal in books and pages) and the Reading List, where you enter each book once.

See Your Reading (5 Tabs)

Dashboard, Monthly Wrap-Up, Book Card + Book Filter, Reading Calendar, and a 12-month Reading Tracker with daily Read and Listened boxes.

Your Books (4 Tabs)

My Library (what you own, where it is, who borrowed it), TBR & Wishlist, Purchased (what you spent on books) and the Series Tracker.

Shelves & Covers (2 Tabs)

Reading Shelves (spines by location, genre, rating or year finished) and the Cover Gallery (covers fill in from the ISBN in Google Sheets).

Also Included

Room for 5,000 Books
5 Statuses: TBR, Reading, Read, DNF, Rereading
Half-Star Ratings & Reread Count
Notes, Reviews & Favourite Quotes
Your Own Dropdowns in Settings
Yearly Goal in Books & Pages
Printable Reading Journal (US Letter & A4)
Reusable Every Year
The Ultimate Book Tracker - What Will You Get, 4 sections and 14 tabs plus a printable PDF bonus
Inside Your Tracker

Everything in the Ultimate Book Tracker

Every tab works in Excel and Google Sheets. Enter a book once in your Reading List and the rest fills in by itself.

Ultimate Book Tracker - Enter a Book Once, the Rest Updates
1

Enter a Book Once, the Rest Updates

Your Reading List is the one place you type. Add the title, author and ISBN, pick a format and a status, and every other tab updates: dashboard, library, TBR, series, calendar, shelves and covers. Track every book your way, in every format.

Title, Author & ISBN
Format, Source, Edition & Translation
TBR, Reading, Read, DNF, Rereading
Start & Finish Dates
Pages & Hours Listened
Half-Star Ratings & Reread Count
Series Name & Number
Notes, Review & Favourite Quotes
Ultimate Book Tracker - Your Reading Year in Numbers
2

Your Reading Year in Numbers

Pick a year and the whole dashboard turns to it: books read, pages, hours listened, DNFs, rereads and your average rating, with your progress against the yearly goal you set. You'll see things like how much literary fiction you really read once you start tracking genres.

Year Filter
Books, Pages & Hours Listened
DNFs, Rereads & Average Rating
Progress to Your Yearly Goal
Genres, Authors & Formats
Books per Month
Best-Rated Spines
Fills In by Itself
Ultimate Book Tracker - Have I Read It? What Did I Think?
3

Have I Read It? What Did I Think?

Type a title and its book card opens: your rating, review, notes and favourite quotes, years later. The Book Filter narrows your whole list by up to 8 fields over a grid of covers, and shows whether you own a book and which shelf it's on before you buy it again.

Search Any Book
Rating, Review & Notes
Favourite Quotes
Filter by 8 Fields
Format, Source, Status, Genre
Sub-genre, Location, Year, Rating
Cover Grid of Every Match
Do I Own It? Check
Ultimate Book Tracker - Your Month in One Screen
4

Your Month in One Screen

Pick a month and your monthly wrap-up fills in: every book you finished with its cover, your pages, hours and average rating, your genres and your favourite of the month. Ready to screenshot.

Pick Any Month
Books Finished, With Covers
Pages & Hours Listened
Average Rating
Favourite of the Month
Genres of the Month
Ultimate Book Tracker - My Library
5

My Library

Every book you own, where it is and who has it. Note the shelf and room, who borrowed a book and when, and see owned, read and unread counts. Search a title or author to check if it's already yours.

Shelf & Room for Every Book
Loaned To & Loan Date
Owned, Read & Unread Counts
Search by Title or Author
Check Before You Buy
Linked to Your Reading List
Ultimate Book Tracker - Your TBR, in One List You Can Actually Choose From
6

Your TBR, in One List You Can Actually Choose From

Every book marked TBR in your Reading List shows up here by itself, so nothing is entered twice. Mark a priority, filter by genre, length or format, and pick what's next. Books you don't own yet go on the wishlist with an estimated cost.

Fills In From Your Reading List
Priority for Every Book
Filter and Pick Your Next Read
Wishlist of Books You Don't Own
Estimated Wishlist Cost
No Second Entry
Ultimate Book Tracker - Series Tracker
7

Series Tracker

Every series in order, with how many you own and have read, and the next book to read always in view. Add the series name and number in your Reading List and the tracker fills in.

Book Number & Series Total
Owned & Read per Series
Next Book to Read
Progress per Series
Fills In by Itself
Ultimate Book Tracker - Reading Calendar
8

Reading Calendar

See what you read each month as colour bars from start date to finish, with the books you started and finished. The 12-month Reading Tracker beside it has daily Read and Listened boxes and your days read per month.

Colour Bars, Start to Finish
Started & Finished per Month
Currently Reading
Reading Tracker (12 Months)
Daily Read & Listened Boxes
Days Read per Month
Ultimate Book Tracker - See Your Reading as Spines and Covers
9

See Your Reading as Spines and Covers

Reading Shelves lines up your books as spines, sorted by location, genre, rating or year finished. The Cover Gallery shows every cover from your Reading List: in Google Sheets the covers fill in from the ISBN, and in Excel you paste the cover once.

Spines by Location, Genre, Rating or Year
Finished Books Only, if You Like
Every Cover in One Gallery
Covers From the ISBN in Google Sheets
Paste Once in Excel
Ultimate Book Tracker - Purchased
10

Purchased

What you spent on books this year, by itself: the date, format and price of every book you bought, your yearly total, the month you spent most, and your spend by format.

Date, Format & Price
Spend per Year
Spend by Month
Spend by Format
Enter Once

Enter a Book Once, Everything Else Fills In

One entry in your Reading List feeds your dashboard, monthly wrap-up, library, TBR and wishlist, series, calendar, shelves and covers. No double entry.

Ultimate Book Tracker - Enter a Book Once, every tab fills itself in from your Reading List
Why Not an App

An App Can Wipe Your Library. Your Own File Can't.

Readers have lost years of logged books in one update, hit 20-book limits and couldn't get their data out. A file you own works differently.

Reading apps
The Ultimate Book Tracker
Where your books live
On their servers
In your own Google Drive or on your computer
An update or shutdown
Can wipe your library
Nothing to sync, nothing to wipe
How many books
Free tiers cap your books
Room for 5,000 books
Getting your data out
An export, if they offer one
It's already your file
Your own fields
Their fields only
Your own formats, genres, shelves and tags
What it costs
Subscriptions and paid tiers
Pay once, no ads, no account
Who sees your ratings
Often on a public profile
Private: only you
Start Here

Set It Up in Minutes

Add a book, watch the dashboard fill in. The Start Here tab walks you through it in 3 steps: add the books you're reading now, set your lists in Settings, and watch every tab update by itself. No formulas to write.

Ultimate Book Tracker - Set Up in Minutes with the Start Here tab, 3 steps
Ultimate Book Tracker - Printable Reading Journal bonus, 4 pages in US Letter and A4
Bonus Included

Printable Reading Journal, Included

4 printable pages for the reader who loves paper: a book review page, a monthly wrap-up page, a TBR list and a series checklist, as a PDF in US Letter and A4.

Book Review Page
Monthly Wrap-Up Page
TBR List
Series Checklist
US Letter & A4
Printable PDF
Why This Tracker

Your Way. Every Book Remembered. Pay Once.

Excel and Google Sheets, both included. Track your books on your laptop, phone or tablet, and the tracker does the rest.

YOUR WAY

Your own formats, genres, shelves and tags in Settings. Track rereads, DNFs and audiobooks the way you read them.

REMEMBER WHAT YOU READ

Your rating, review, notes and favourite quotes for every book, searchable years later. And every book you already own, a search away.

PAY ONCE, PRIVATE

No subscription, no ads, no account. Your own file that only you see, reusable every year.

How It Works

Get started in minutes with instant digital access

1

Purchase

Complete your secure checkout

2

Download

Excel file + Google Sheets link by email

3

Add Your Books

Start with the books you're reading now

4

Watch It Fill In

Dashboard, library and shelves update

Remember Every Book, Your Way, for $9

Reading apps cap your books or charge a subscription to see your own stats. This is one download with everything on this page: 14 tabs in Excel and Google Sheets, room for 5,000 books, plus the printable reading journal. Pay once.

$297
$9
One-time payment • Instant access
  • Reading List With Your Own Fields (Room for 5,000 Books)
  • Dashboard, Monthly Wrap-Up & Reading Calendar
  • Book Card + Book Filter, With Notes & Quotes
  • My Library, TBR & Wishlist, Series & Purchased
  • Excel and Google Sheets, Both Included
  • Printable Reading Journal (US Letter & A4)

Instant digital download • Works with Excel & Google Sheets • One-time payment

This is a digital product with immediate access after purchase. No refunds on the Ultimate Book Tracker or any order bump. The optional upgrade offered after checkout is the one exception, with a 90-day money-back guarantee.

Works Everywhere

Designed to Fit Your Reading

Instant download, Excel and Google Sheets, reusable every year. Track your books in your browser on Mac or PC, or open Google Sheets on your phone or tablet; setup is easiest on a computer.

Ultimate Book Tracker - Works in Google Sheets and Microsoft Excel

Frequently Asked Questions

Everything you need to know before you buy

Remember every book you read. Track it your way.

$297$9 only