Remember every book you read. This reading tracker spreadsheet is a book log and a yearly dashboard in one: add each book with its genre, format and pages, rate it with stars, set a reading goal and watch your year in books take shape.
Who this template is for
- Book lovers tracking a reading challenge
- Book clubs
- Students keeping a reading log
Features
- Reading log for up to 150 books: title, author, genre, format, pages, start and finish dates, status, rating and notes
- Status drop-down: To read, Reading, Finished, Did not finish
- Star ratings, days to read and pages per day calculated
- Yearly reading goal with a progress bar and “books to go”
- Dashboard with books read, pages read, average rating and days per book
- Books per month chart and books and pages per month table
- Favorite genres, what you are reading now and your top 5 rated books
How to use it
- Add your books on the Reading Log.
- Type the start and finish dates and pick a status.
- Rate each finished book from 1 to 5 stars.
- On the Dashboard choose the year and type your goal.
What’s included
- Reading Tracker (.xlsx) with Dashboard and Reading Log tabs
- “Start Here” guide with simple instructions in plain English
Compatibility
Works in Microsoft Excel (2016 or later, Microsoft 365, Mac) and Google Sheets. No macros.
FAQ
Can I use it for more than one year? Yes, keep logging and switch the year on the dashboard (2024 to 2035).
Do audiobooks count? Yes, pick Audiobook as the format.
Can I keep a to-read list? Yes, add books with the status “To read”.
Does it work in the free version of Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. A free Google account is all you need.
Can I use it on a Mac, iPad or phone?
Yes. It works in Excel for Mac and Windows, Excel online and the Google Sheets app. For editing, a computer or tablet is the most comfortable.
How do I get the file?
Right after checkout you get a download link on the confirmation page and by email.
More templates like this: Habit & Goal Trackers.
This is a digital product. No physical item will be shipped.
Reviews
There are no reviews yet.