Book Tracker

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

• XLSXBook-Tracker.xlsx (blank, set to 2027)
• XLSXBook-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)
• PDFQuick-start guide (PDF)

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).