This is where "spreadsheet work" becomes an art form. You are not just checking boxes; you are building a personal literary analytics engine.
If you have ever stood in front of a groaning bookshelf, scrolled endlessly through a "Best Books" list on Goodreads, or felt the quiet panic of mortality mixed with the joy of literature, you have likely encountered the behemoth: 1001 Books to Read Before You Die , edited by Peter Boxall.
Use a Pivot Table to see which decades you are ignoring. Most readers naturally drift toward the 20th century. Your spreadsheet will reveal if you have read zero books from the 1600s (spoiler: you probably have The Pilgrim's Progress waiting for you, and it is a slog).
: A simple count of books currently on your physical or digital "to-be-read" pile compared to the 1,001 list. AI responses may include mistakes. Learn more Boxall's 1001 Books You Must Read Before You Die 1001 books to read before you die spreadsheet work
: Determines how many post-2000 contemporary works you have finished.
Track whether you read a physical copy, ebook, or listened to the audiobook.
Before diving into the data, it is important to understand the scope. Edited by Peter Boxall, this list is not merely a collection of "classics." It is a curated timeline of human storytelling, spanning from the Epic of Gilgamesh (c. 2000 BC) to contemporary works published in the last decade. This is where "spreadsheet work" becomes an art form
Divide your total read books by the total number of books on the list to see your overall progress. =COUNTIF(G2:G1002, "Read") / 1001 Use code with caution.
Several long-standing community templates are available for those who don't want to build one from scratch: How Do I Keep Track of My Boxall Books? Showing 1-20 of 20
=SUMIF(I:I, "Completed", H:H) (assuming column H is Page Count). Drop-Down Menus (Data Validation) Use a Pivot Table to see which decades you are ignoring
: A frequently updated, free spreadsheet listing all 1,316 books from every edition is maintained by the community on Goodreads .
For those ready to start their own spreadsheet journey, the first step is understanding the source material, which is more extensive than a simple list of one thousand and one titles.
: The original release focused heavily on canonical Western prose.
Having a spreadsheet is great, but it won’t read the books for you! Here are some strategies to manage the overwhelming volume:
Set up a separate "Dashboard" tab for your charts, graphs, and total counts.