=COUNTIF(Status Column, "Completed") / COUNTA(Title Column)

Search for the "1001 Books Master Spreadsheet" on Google. Fans often update Google Sheets that include every book from every edition (around 1,300 total titles). The 1001 Books Library:

Limitations and Risks Yet spreadsheets also risk reducing books to data points. Rich, multifaceted works become rows with cells: title, author, year, rating. The nuance of why a book matters—the texture of its language, the rhythm of its sentences, the subtlety of its ideas—can be flattened into numeric ratings or short notes. Overreliance on metrics (stars, completion percentage) can shift attention from the qualitative experience of reading to the quantitative act of completion. The gamification of a reading life can turn exploration into checklist fulfillment.

Sort by and commit to reading one book from each decade. This turns the spreadsheet into a history of the novel. You’ll see how stream of consciousness emerges in the 1920s and how postmodernism fractures in the 1960s.

This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.

Finding a reliable and complete version of the spreadsheet is crucial to starting your challenge.

However, the "1001" number is a moving target. Because the book has been updated multiple times—notably in 2006, 2008, 2010, 2012, 2018, and 2021—books are frequently added or removed to make room for new works or to provide a more international perspective. If you want to read every book that has ever appeared on the list, you are actually looking at a total of .

If you have specific needs, building your own spreadsheet can be a great option. Whether you use Excel, Google Sheets, or Notion, the key is customization.

: A detailed, free alternative often shared in Goodreads groups that consolidates the 1,316 books from the 2006–2018 editions.

If you add a page count column, you can sum up the total number of pages read using =SUMIF() . How to Customize Your Spreadsheet Journey