Book Tracker

Book tracker spreadsheet and digital reading journal: log every book you read, rate it with stars, write a short review and your favourite quote, keep your to-read list, set a reading goal for the year and see your year in books on one dashboard.

WHAT IT DOES

• Reading Log tab: title, author, genre, format (print, ebook or audiobook), pages or listening hours, status, start date, finish date, days to read (worked out for you), a rating from 1 to 5 shown as stars, source (owned, library, borrowed, subscription, gift), series and number, price paid, a review and a favourite quote
• Statuses: To Read, Reading, Finished and Did Not Finish. Rename them or add your own on the Setup tab
• Reading Challenge tab: your books goal and pages goal against what you have read, progress bars, how many you would have read by now at an even pace, whether you are ahead or behind, and how many books and pages a month you need to finish the year on target. Plus a month-by-month table and a chart of books so far against the goal pace
• Dashboard: books finished this year, how much of your goal you have reached, pages read, audiobook hours, average rating, currently reading, did not finish, average days and pages per book, money spent on books and books on your to-read list
• Also on the dashboard: books and pages per month with a chart, your top genres with a chart, a format split, your longest book, your fastest read, your 5 top-rated books and what you are reading now
• TBR list tab: books you want to read next with a priority, where to get each one (buy, library, borrow, subscription), who recommended it and the date you added it. Top priority rows are highlighted
• Setup tab: the year, your goals and every drop-down list (19 starter genres, formats, statuses, sources, priorities) are yours to rename and extend
• Room for 250 books in the log and 100 on the TBR list. Price paid is a plain number, so any currency works

WHAT YOU GET

• Book-Tracker.xlsx (blank, set to 2027)
• Book-Tracker-with-Sample-Data.xlsx (a filled-in example: 27 made-up books, including currently reading and did-not-finish ones, plus a 10-book TBR list)
• Quick-start guide (PDF)

HOW YOU GET IT

Digital download. After checkout you get a download page right away, plus a receipt by email. Nothing is shipped.

COMPATIBILITY

• Microsoft Excel 2016 or newer (Windows or Mac) and Excel for the web
• Google Sheets: upload the .xlsx to Google Drive, open it, then File > Save as Google Sheets
• Needs a computer or tablet with a spreadsheet app. This is not an app or a printable journal, and it does not connect to any book website or reading app

GOOD FOR

Readers who want to track every book they read in one place, book club members, anyone doing a yearly reading challenge, and a thoughtful gift for the bookworm in your life (it is an instant digital file, so you can send it on the day).

PLEASE NOTE

For your own personal use; please don't resell or share the files.

DISCLAIMER

This template is a record-keeping tool. Check the results before you rely on them.

HOW IT WAS MADE

Designed by VARS Digital with AI-assisted tools. Every formula is checked before release, and the sample file shows each tab working.

QUESTIONS

Email varsdigitals@gmail.com and we'll help you get set up.