1 / 22

Covers by ISBN, bookshelves, Light + Dark mode

Ultimate Book Tracker Spreadsheet

Type an ISBN and the book's cover pops in. Log a book once and your Dashboard, bookshelves, stats, calendar and series fill in by themselves, in Light mode and Dark mode.

SpreadsheetExcel + Google Sheets12 linked tabsLight + Dark

$8.99 one time, buy direct

Buy direct · $8.99

Instant download: the Light and Dark spreadsheets (.xlsx) and the free 12-page Quick Start guide (PDF), right after you pay.

Buy on Etsy · $10.99

35% off on Etsy: code SAVE35

Try the free demo

Pay once, no subscription
No macros, no account
Works for any year
Free 12-page Quick Start guide (PDF) included

What's in the Ultimate Book Tracker

Covers by ISBN

Type an ISBN and the book's cover pops in. The Cover Gallery shows your books by their covers.

Bookshelves

Four bookcases of book spines with cozy stickers, by genre, star rating, year finished or format. A gold band means 5 stars.

Dashboard

Your reading goal and pace, six live cards (books, pages, audio hours, goal pace, average rating, average spice) and books finished per month.

Book Log for 1,000 books

ISBN, title, author, series, genre, format, pages, audio hours, status, dates, half-star rating and spice rating.

Currently Reading

Progress bars, pages per day and your estimated finish date, up to 10 books at once.

Reading Habit

Daily minutes, reading streaks and a 24-prompt reading challenge that ticks itself off.

Series + Wishlist

Up to 30 series with what you own, what you've read and what's next. Up to 50 books to buy or pre-order, with release countdowns.

Book Club, Calendar + Stats

Meetings, picks, hosts and ratings; a month view of what you finished and started; top authors, longest and shortest books.

How it works

Log a book
Type the ISBN and the cover appears. Dropdowns for genre, format and status.
Set your goal
The goal bar fills as you read, and goal pace shows if you're ahead or behind.
Watch your shelves fill up
Finished books land on the bookshelves with their titles on the spines.

Watch the how-to

See the Ultimate Book Tracker set up and in use.

Plus the free 12-page Quick Start guide (PDF) comes with your purchase.

Two versions: Light and Dark

You get the Ultimate Book Tracker in two versions, Light mode and Dark mode: the same tracker, your pick of mood.

Books read trackerTBR listSeries trackerReading challengeBook clubDigital library

Works for any year: type a new year and the Dashboard, Stats and Calendar switch to it
Your Book Log keeps every book from every year
Type in the cream cells; everything else is calculated for you

What you get, how you get it and what you need

What you get

The Ultimate Book Tracker in Light mode and Dark mode (.xlsx), 12 linked tabs each
The free 12-page Quick Start guide (PDF): setup, every tab and what to do if something looks off
A one-time purchase, no subscription

How you get it

Buy direct: right after you pay, you land on your download page with both spreadsheets and the guide.
On Etsy: open Purchases in a web browser and click Download Files. The Etsy phone app can't download files.
Open it in Excel, or upload it to Google Drive and open it with Google Sheets. The guide shows each step.

What you need

Microsoft Excel (Windows or Mac), Google Sheets or LibreOffice Calc
An internet connection for the covers

Good to know

Covers load online by ISBN, so you need to be online, and a few books don't have one.
In Excel, covers show in Excel 365. In Google Sheets, covers show after you click Allow access.
LibreOffice Calc: everything works except the covers.
It's a digital download. Nothing is shipped.

Reviews

The Ultimate Book Tracker Spreadsheet doesn't have reviews yet.

Our Etsy shop has 150 reviews with a 4.8-star average.

Read all our reviews on Etsy →

Questions

How do the covers work?

Type the ISBN and the cover pops in. Covers load online, so you need to be online, and a few books don't have one.

Does it work in Google Sheets?

Yes. Covers show in Google Sheets after you click Allow access. It also works in Microsoft Excel (covers show in Excel 365) and in LibreOffice Calc, where everything works except the covers.

What's the difference between Light and Dark?

Nothing but the look. It's the same tracker in two versions, and you get both.

How many books can it hold?

The Book Log has room for 1,000 books. Currently Reading tracks up to 10 at once, the Wishlist up to 50 books and Series up to 30 series.

Does it work for next year?

Yes. Type a new year and the Dashboard, Stats and Calendar switch to it. Your Book Log keeps every book from every year.

How do I get it after I buy?

Buy direct and you land on your download page right after you pay, with both spreadsheets and the free Quick Start guide. On Etsy, open Purchases in a web browser and click Download Files.

Can I try it before I buy?

Yes. Try the free demo right in your browser before you buy.