For any avid bibliophile, Peter Boxall's curated literary canon, , is both a dream and an intimidating challenge. It’s a comprehensive guide reviewing seminal literary works across a century, featuring critical essays on each book’s importance and influence, plus publishing history and design details.
: A frequently updated, free spreadsheet listing all 1,316 books from every edition is maintained by the community on Goodreads .
Avoid burnout by balancing heavy doorstoppers with shorter novellas. Use the spreadsheet's filter tool to sort your unread list by . If you just finished a massive 900-page classic like War and Peace , use your filter to find an unread 150-page title like The Old Man and the Sea for a quick, refreshing win. Logging Personal Metrics
Title, Author, Year of Original Publication, and Genre.
The "1001 Books to Read Before You Die" spreadsheet is a artifact of modern digital culture. It strips the mystique away from the literary canon and replaces it with sortable data. While this allows for personalized tracking and a sense of accomplishment, it risks commodifying the reading experience. 1001 books to read before you die spreadsheet work
: Fields for start/end dates, personal star ratings (1–5), and a brief review or summary. Visualization
Instead of manually scrolling to find a book, use the filter tool. This allows you to temporarily isolate specific subsets of the list with a single click. You can filter for "All books under 200 pages that are Not Started," or "All 18th-century French literature." The "Next Up" Randomizer
: Widely considered the gold standard for tracking this challenge. It includes all editions and allows you to input your age to calculate the reading pace needed to finish "before you die". You can find the latest version on the Arukiyomi blog Karen Hoehne’s Combined Spreadsheet : A free, detailed resource on
Use conditional formatting to make your spreadsheet visually engaging. For example: Completed Yellow: Reading Red: Not Started Strategies for Tackling the List For any avid bibliophile, Peter Boxall's curated literary
: 1,318 titles
To make your spreadsheet functional, start by establishing your core data points. Create a header row with the following essential columns: Metadata Columns
To see exactly how many books you have completed, use the COUNTIF function. =COUNTIF(A2:A1300, "Read")
When you build your master sheet (Google Sheets or Excel), you need the following columns minimum: Avoid burnout by balancing heavy doorstoppers with shorter
The name of the book (consider adding a column for the original title if translated).
If you are looking for pre-made templates or community support: How Do I Keep Track of My Boxall Books? Showing 1-20 of 20
Helps you track your annual reading velocity.
The writer's full name (formatted as "Last, First" for easy alphabetical sorting).