A reading list spreadsheet turns your vague goal of “read more” into a concrete, trackable plan. By logging what you want to read, what you’re currently reading, and what you’ve finished, you get a clear picture of your progress and a gentle nudge to keep going. This guide shows you how to build a simple spreadsheet that works with any app—Excel, Google Sheets, or Numbers—and how to use it to actually finish more books.
What You’ll Need
- A spreadsheet app (Google Sheets, Microsoft Excel, Apple Numbers, or any similar tool)
- A list of books you want to read (even just a few titles to start)
- Optional: a library card or book-buying budget to get the books
Step-by-Step
- Open a new spreadsheet. Create a new file and name it something like “Reading List” or “Books to Read.”
- Set up your column headers. In row 1, type these headers in columns A through F (adjust as needed):
- Title – the book’s name
- Author – who wrote it
- Status – “To Read,” “Reading,” “Finished,” or “DNF” (did not finish)
- Date Added – when you added it to the list
- Date Finished – when you completed it
- Rating – your personal rating (1–5, or a simple “Loved it” / “Meh”)
- Add your books. Start with the books you already own or have on hold at the library. Add a few that you’ve been meaning to read for ages. Don’t overdo it—10 to 20 is a good starting point.
- Set a “current read” row. Choose one book and set its Status to “Reading.” This becomes your active focus. You can also add a column for “Start Date” if you want to track how long it takes.
- Create a simple progress formula. In a cell outside your list (e.g., H1), type a formula to count how many books you’ve finished. In Google Sheets or Excel, use:
=COUNTIF(C2:C100, “Finished”)
This shows your total finished books. You can also add a formula to show how many are “To Read” or “Reading.” - Update your status regularly. When you start a book, change its status to “Reading.” When you finish, change it to “Finished” and add the date. This is the core habit—it takes 10 seconds and keeps you accountable.
- Review your list weekly. Every Sunday (or whenever), look at your list. Ask yourself: “What am I reading now? Is it time to switch?” If you’re stuck on a book, decide whether to push through or mark it as DNF and move on.
- Add a “Next Up” column (optional). To keep momentum, add a column called “Next Up” and write the title of the book you plan to read after your current one. This removes decision fatigue when you finish.
- Use filters or sorting. Sort by Status to see all “To Read” books together, or filter by Rating to see your favorites. This helps you pick your next read based on mood.
- Celebrate milestones. When you hit 10, 25, or 50 books, take a moment to appreciate the list. You can even add a “Notes” column to jot down memorable quotes or thoughts.
Common Mistakes
- Adding too many books at once. A massive list can feel overwhelming. Start small and add more as you go.
- Forgetting to update. The spreadsheet only works if you use it. Set a reminder on your phone to update it every few days.
- Being too rigid. If you’re not enjoying a book, you’re allowed to mark it as DNF. The goal is to read more, not to suffer.
- Ignoring the data. Don’t just list books—look at your progress. Seeing “12 finished” in the count cell is motivating.
- Using too many columns. Keep it simple. You can always add more later, but a cluttered sheet is harder to maintain.
Tips
- Make it visual. Use color coding: green for finished, yellow for reading, gray for to-read. This gives you an at-a-glance view.
- Add a “Why” column. Write a short note about why you want to read each book (e.g., “for book club,” “recommended by friend”). This helps you prioritize when you’re choosing a next read.
- Set a monthly goal. Use the COUNTIF formula to track how many books you finish each month by adding a “Month Finished” column.
- Link to your library. If you use Goodreads or LibraryThing, you can export your list and import it into your spreadsheet to save time.
- Keep it accessible. Use a cloud-based app like Google Sheets so you can update it from your phone while on the bus or in line.
Troubleshooting
- You stop updating after a week. Try adding the spreadsheet to your phone’s home screen as a shortcut, or set a recurring calendar event to update it every Sunday.
- The COUNTIF formula returns 0. Check that your Status column uses the exact same text (e.g., “Finished” vs “finished”). Use consistent spelling or use a drop-down list (Data > Data validation) to avoid typos.
- You feel guilty about DNF books. Remember, the list is for you. Mark it DNF and move on—the goal is to read more, not to finish every book you start.
- You can’t decide what to read next. Look at your “To Read” list and pick the shortest book, or the one with the most compelling “Why” note. If you still can’t choose, pick a book that’s available at the library right now.
- The spreadsheet feels like a chore. Simplify it. Cut columns, reduce the number of books, or switch to a paper notebook if that feels better. The tool should serve you, not the other way around.
Frequently Asked Questions
Q: Do I need to use a specific app?
No. Any spreadsheet app works. Google Sheets is free and syncs across devices, which makes it convenient, but Excel or Numbers are fine too.
Q: How many books should I put on the list?
Start with 10–20. That’s enough to give you options without feeling overwhelming. You can always add more.
Q: What if I don’t finish a book?
Mark it as “DNF” and move on. There’s no shame in it—life is too short to read books you don’t enjoy.
Q: Can I track audiobooks and e-books?
Absolutely. Just list them like any other book. You can add a “Format” column if you want to see trends.
Q: How often should I update the spreadsheet?
Ideally, every time you start or finish a book. At minimum, update it once a week during a review session.
Q: Will this really help me read more?
Yes, for most people. Seeing your progress and having a clear next choice removes friction. The act of tracking makes reading a conscious priority.
Related
General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.
More in this bed
- Multi-Cloud GPU Failover Design Guide
- Error Code Currant Destiny? Meaning & Fixes
- Spotify Jam Not Working on Mobile? Fixes That Work
- Windows 10 No Internet Secured WiFi Error Fix
- AirPlay with Roku Multi-Device Setup: A How-To
- How to Set a Timer on iPhone (iOS 18 & 17)