Read More Books by Keeping A List


Read more books by keeping track of what you've read with this spreadsheet

Read more books by keeping track of what you’ve read with this spreadsheet

Trying to read more books this year? Keep yourself motivated by tracking this. When you open the spreadsheet to add the book you’re reading, seeing what you’ve already read can help encourage you to make the time to read more books. I have written about other strategies to help make reading a daily habit.

Book Tracking Spreadsheet

View Book Tracker in Google Docs | Download Book Tracker in Excel

Keeping track of what you’ve read throughout the year will encourage you to read more books. If you have trouble finding time to read, seeing this list provides a reminder of the previous books you’ve read and enjoyed. It also serves as a reminder to keep reading!

The spreadsheet is pretty simple to use. You can always use a notebook & pen if you’re not a fan of digital tracking. There is one tab per year. It can be fun to go through previous years to see what you’ve read. This is also very useful when friends ask you for recommendations. There is also a tab for “half-read” books. These are books that I just couldn’t get into even after 100 pages. I like to remember these just incase I want to go back and try them again later in life.

The last tab is for suggestions. I do not consider this a list of books to read. I do not have a list of books to read. I never want to think of reading as a chore or a task to check off a list. However, I am always looking for things to read. So if I come across a list of top books for the month, I’ll jot some down as a suggestion. Then, when I need another book to read, I browse the new york public library online catalog for one of the titles to put on hold. This can also help you to read more books because you won’t find yourself with downtime while looking for something else to read.

It’s easy to get into the habit of updating the spreadsheet. As soon as you start a book, write it down. If you try to do this after reading several books, you may not be able to remember each of them. Then when you’re finished with a book, go back to the sheet and input your rating (1 out of 5) and the day you finished it. Feel free to customize this sheet with whatever information you prefer. Yes, sites like Goodreads (owned by Amazon) can track this for you but I like controlling my own data.


If you have thoughts on this and would like to discuss please use Twitter or send me an email.