Personal template
Reading log
Track books, pages and ratings through the year with a yearly goal. A chart shows how many books you finished each month.
- Free
- No account needed to try
- Download as .xlsx
What's inside
Everything is a normal workbook once you open it: change the numbers, rename the sheets and make it yours.
1 sheet
- Books
103 formulasTotals, lookups and checks are already worked out, so the sheet updates as you type. 261 filled cells in all.
Built in
- Charts
- Conditional formatting
- Dropdowns
- Live dates
- Frozen headers
- 1 chart
A look at the Books sheet
The top left of the first sheet, calculated by SheetsBat. Open the template to see all of it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Reading log | |||||||
| 2 | Add a row for each book. Leave Finished empty while you are reading it. | |||||||
| 3 | Goal for 2026 | 24 | Finished | 16 | Progress | 67% | Pages | |
| 4 | Avg rating | 3.9 | Pace | 18 books | ||||
| 5 | ||||||||
| 6 | Title | Author | Genre | Pages | Started | Finished | Rating | |
| 7 | The Lantern Keepers | M. Ashdown | Fiction | 342 | Jan 3 | Jan 15 | 4 | |
| 8 | Salt and Signal | R. Okoye | Science fiction | 410 | Jan 18 | Feb 6 | 5 | |
| 9 | A Short History of Bridges | T. Varga | History | 288 | Feb 8 | Feb 27 | 3 | |
| 10 | Quiet Hours | L. Benedetti | Poetry | 96 | Mar 1 | Mar 4 | 4 | |
| 11 | The Fourth Locker | S. Kimura | Mystery | 356 | Mar 6 | Mar 19 | 4 | |
| 12 | Tides of the Inner Sea | J. Halloran | Science | 264 | Mar 22 | Apr 10 | 4 | |
- books
- reading
- goals
- library
More personal templates
PersonalHome renovation budgetCost out a renovation room by room with materials, labor and a contingency buffer. Track status and spending against what you can afford.
PersonalBill payment trackerKeep every recurring bill in one list with this month's due date, days left and a paid checkbox. Overdue and soon due bills light up automatically.
PersonalSubscription trackerList every subscription with its price and billing cycle to see the true monthly and yearly cost. Upcoming renewals are flagged so you can cancel in time.
PersonalHabit trackerTick off daily habits on a monthly grid. Progress toward each goal, the best streak and a daily score are calculated for you.
Start your reading log now
It opens in your browser in a second. Create a free account to save it, share it and open it anywhere.