Skip to content
Store
AZBuy(opens in a new tab)

A reading tracker spreadsheet where the cover appears from the ISBN

A reading tracker for Excel and Google Sheets. Type a book once: the cover loads from Open Library, the status, days and pages per day fill in, and the dashboards update.

Buy on Gumroad(opens in a new tab)$9

Excel 2016 or newer and Google Sheets. Light and dark.

Reading Tracker: Book Log Spreadsheet with Automatic Covers for Excel and Google Sheets

What you get

  • Library

    Title, author, ISBN, genre, format, pages, status, start and finish dates, the page you are on, rating and notes, for up to 1,000 books, with the cover next to each one.

  • To read

    Your queue, with the pages waiting and how many days they take at your own pace.

  • Dashboard

    Yearly goal with your pace, books and pages per month, average rating, pages a day, top genres, formats and the books you are reading now.

  • Year in books

    Your totals, longest and shortest book, fastest read, highest rated, top genre and author, best month, and a shelf of the covers you finished, in order.

  • Three files

    The tracker, the same tracker on a dark background, and an example filled with 44 sample books so you can see every page working.

Who it is for

  • Readers with a yearly reading goal
  • Bookish creators who share their year in books
  • Anyone moving a reading log out of a notes app

Details

Format
Excel workbook (.xlsx), 3 files
Works in
Excel 2016 or newer, Google Sheets
Covers
Excel 365, Excel 2024 or Google Sheets
Books
Up to 1,000
Editions
Light, dark and a filled example
Price
$9, paid once

How it works

  1. 1

    Open the Library tab and type one book per row: title, author, ISBN, genre, format and pages.

  2. 2

    Pick a status. Type the start date when you begin, and the finish date and rating when you are done.

  3. 3

    Set your yearly goal at the top right of the Dashboard, and open Year in books any time for your wrap-up.

Questions

Where do the covers come from?

From Open Library, a free book catalogue, using the ISBN of your edition. No account or login is needed. If a book has no cover there, paste any image link into the Cover link column.

Which versions of Excel work?

Excel for Microsoft 365 and Excel 2024 on Windows and Mac do everything, covers included. Excel 2016 to 2021 do everything except the covers, which need the newer IMAGE function. Google Sheets: in Google Drive choose New, then File upload, pick the file, open it and choose File, then Save as Google Sheets.

Can I look back at a past year?

Yes. Type the year at the top of the Dashboard and every page switches to it.

Can I add my own genres?

Yes, on the Lists tab. The dropdowns update right away.

Do I need a Google account?

Only to use it in Google Sheets. In Excel it is a normal file on your computer.

Get Reading Tracker

Book Log Spreadsheet with Automatic Covers for Excel and Google Sheets

Need help after you buy? Reply to your receipt email and describe what happened. We will help you get it running.

Buy on Gumroad(opens in a new tab)All products

More from the store

All products