Excel template · Instant download

Every book. Every star. Your year in reading.

Track every book you read, want to read and give up on. See your reading goal, whether you’re ahead or behind, your top rated books and your year in numbers. No macros.

Get the tracker $5.99

✓ One-off payment   ✓ Instant download   ✓ Excel for Windows & Mac

Lee from Sheet Leveller
Made by Lee at Sheet Leveller, whose tutorials have been watched 6.3 million times on YouTube.
Reading-Tracker.xlsx
This year23 of 30Pace+1 aheadPages read7,744Avg rating4.1 ★
Top rated this yearAuthorRatingFinished
The Girl Who Mapped the StarsAda Quinn★★★★★Sep 2
Pride and PrejudiceJane Austen★★★★★Jul 29
Ink and IronRowan Ashby★★★★★Jun 12
The Quiet HoursHannah Pryce★★★★★May 8
The Last Train to ArdmoreJ. P. Calloway★★★★★Mar 22
Start HereDashboardBooksSettings
Sound familiar?

Readers deserve better than a notes app

📚

Goal forgotten by March

You set a reading goal in January and have no idea how you’re doing.

🤔

“What was that book?”

Someone asks for a recommendation and your mind goes blank.

📝

Lists everywhere

Want-to-read in one app, ratings in another, notes on scraps of paper.

How it works

Simple to keep up, lovely to look back on

  1. Set your goal

    How many books you want to read this year.

  2. Add your books

    Want to read, reading or finished, with dates, pages and a star rating.

  3. Watch your year build

    Goal, pace, top rated, genres and stats, all worked out for you.

Every book

One list for everything you read

Title, author, genre, format, pages, dates, a star rating, where you got it and notes. Statuses for want to read, reading, finished and did not finish.

  • Room for 500 books
  • Print, ebook and audiobook
  • Filter to your want-to-read list
Books
Every book you read, want to read and gave up on.
TitleAuthorStatusFinishedRating
Echoes of TomorrowTheo LindqvistFinishedSep 14★★★★
The Bookshop on Elm StreetClara BentonFinishedSep 25★★★★
The Midnight ArchiveAda QuinnReading
Atomic MorningsDana WhitcombeReading
The Glass HarborIsabel NavarroWant to read
Crown of EmbersRowan AshbyWant to read
Year in numbers

Stats every reader loves

Average pages and days per book, your longest book, your fastest read, your most-read author, library books and what you spent.

  • Goal progress and pace
  • Average rating
  • Pages read this year
Dashboard
Worked out the moment you finish a book.
Year in numbers
Average pages per book337
Average days per book10
Longest bookA Season of Wolves (520 pages)
Fastest readThe Quiet Hours (6 days)
Most-read authorClara Benton (3 books)
From the library7
Spent on books$100.91
Genres and months

See what you really read

Books by genre with their share of your year, plus a chart of books finished each month. Change the year to look back at any past year.

  • 12 genres you can rename
  • Books each month chart
  • Every year in one file
Dashboard
Plus books finished each month, and any past year.
GenreBooksShare
Fiction313%
Mystery and thriller313%
Romance313%
Historical fiction313%
Fantasy29%
Science fiction29%
Who it’s for

For every kind of reader

Goal setters

Know exactly where you stand on your yearly reading goal.

Library lovers

Track where every book came from, and what you saved.

Book clubs and bookworms

Ratings and notes for every book, ready for the next recommendation.

Everything you get

  • Room for 500 books
  • Want to read, reading, finished and did not finish
  • Star ratings and notes
  • Reading goal with pace (ahead or behind)
  • Top rated books of the year
  • Year in numbers stats
  • Books by genre and by month
  • Look back at any year
  • One-off payment, no subscription
Reading Tracker
$5.99

One-off payment. Yours to keep.

Get instant access $5.99

Secure checkout by Payhip · Card or PayPal
Download link emailed straight away

Lee from Sheet Leveller

Hi, I’m Lee

I run Sheet Leveller on YouTube, where I make quick, no-nonsense Excel tutorials.

This tracker uses the COUNTIFS, SUMIFS and INDEX formulas from my tutorials, so your stats update the moment you finish a book.

6.3Mtutorial views
11,900+YouTube subscribers
500tutorials

Questions

Do I start a new file every year?

No. Keep every book on one Books tab. The Dashboard shows this year, and you can change the year to look back.

Does it work for audiobooks?

Yes. Pick Audiobook as the format and type the page count of the print edition, or leave pages blank.

Can I import my books from another app?

If your app exports a spreadsheet, you can copy the titles, authors and dates straight in.

Does a book I didn’t finish count?

No. Mark it Did not finish and it won’t count toward your goal.

Does it use macros?

No. It’s a normal .xlsx file, so there are no security warnings and nothing to enable.

Which versions of Excel does it work with?

Microsoft 365, Excel 2010 or later on Windows, and Excel for Mac. It’s built for Microsoft Excel.

Is this a subscription?

No. You pay once and the file is yours to keep.

Your best reading year starts here.

Every book, every star, in one beautiful file.

Get the tracker $5.99

Want to see it first? Watch how it works on YouTube.

Reading TrackerInstant Excel download
Buy · $5.99
Scroll to Top