Several community-driven spreadsheets exist to track Peter Boxall's 1001 Books You Must Read Before You Die
list, often consolidating titles from various editions (2006, 2008, 2010, 2012, and 2018) for a total of approximately 1,315 to 1,318 books Popular Spreadsheet & Checklist Resources Arukiyomi’s Master Spreadsheet
: Widely considered the "gold standard" by the reading community, this spreadsheet includes all books across various editions. Version 7 is currently available via LibraryThing
and includes features like chronological sorting and reading stats LibraryThing Goodreads Community List : A comprehensive Google Sheets document
maintained by Goodreads members. It lists 1,318 books and explicitly excludes non-novels like holy books or plays Scribd PDF/XLSX : A consolidated 1001 Books spreadsheet
is available for download as an XLSX or PDF, featuring the 2006 and 2008 editions The StoryGraph Challenge : For a digital checklist experience, the 1001 Books To Read Before You Die - All Editions challenge allows you to track progress online The StoryGraph Core Titles Often Found in These Lists
While the full list evolves with new editions, these classics remain staples: Pride and Prejudice (Jane Austen), Frankenstein (Mary Shelley), (Herman Melville), and Crime and Punishment (Fyodor Dostoevsky) The Great Gatsby (F. Scott Fitzgerald), (George Orwell), To Kill a Mockingbird (Harper Lee), and The Handmaid’s Tale (Margaret Atwood) 2000s onwards The Secret History (Donna Tartt), (Ian McEwan), and Never Let Me Go (Kazuo Ishiguro) or tips on how to automate your progress tracking using Google Sheets? The Top 10 Classic Books Everyone Should Read
This feature goes beyond a standard "read/unread" checkbox. It uses formulas to calculate exactly how many books you need to read per year to finish the list before you "die," based on your current age and the average life expectancy for your region and gender.
Customized Annual Goal: By entering your current age, the spreadsheet calculates a "Reading Velocity" (e.g., "13 books/year") required to complete the list.
Visual Completion Percentage: As you mark a book with an "r" (read) or "tbr" (to be read), formulas automatically update your total count and the percentage of the 1,001 goal achieved.
Composite Edition Management: Modern templates often track all versions of the list (2006, 2008, 2010, 2012, 2018, and 2019 editions), totaling over 1,300 unique entries as books are added or removed by the publishers.
Filterable Core Lists: A "Core" category highlights the approximately 700 books that have never been removed across any edition, allowing you to prioritize the "true" essentials. Where to find templates:
Arukiyomi’s Spreadsheet: A comprehensive, feature-rich version (v7) that tracks all changes across every edition.
Goodreads Community Lists: Often hosts free community-made versions, such as those by Rosemary or Karen Hoehne.
TheStoryGraph Challenges: While not a spreadsheet, this interactive platform allows you to digitally "tick off" books from the all-editions list. Boxall's 1001 Books You Must Read Before You Die
1001 Books to Read Before You Die " spreadsheet is more than just a checklist; it is a digital monument to a reader’s lifelong ambition. Derived from the seminal reference book edited by Peter Boxall 1001 books to read before you die spreadsheet
, this spreadsheet has evolved into a cultural phenomenon that turns the act of reading into a structured, lifelong quest. The Genesis of the List The foundation of these spreadsheets is the book 1001 Books You Must Read Before You Die
, first published in 2006. Edited by Boxall, a professor at the University of Sussex
, the guide was compiled by over one hundred critics worldwide to highlight seminal works of fiction. Unlike a stagnant canon, the list is dynamic; since its inception, there have been multiple editions (2006, 2008, 2010, 2012, and 2018), with nearly 300 titles
swapped out over time to improve diversity and include contemporary works. The Rise of the Spreadsheet
Because the list changes with each edition, many readers find a single physical book insufficient for tracking progress. This led to the creation of the "Combined List" spreadsheet—most famously Arukiyomi’s spreadsheet
—which aggregates all titles from every edition, often totaling around 1,300 unique books
These spreadsheets offer features that a standard book cannot: Progress Calculation:
Automatic formulas that show the percentage of the list completed. Predictive Logistics:
Some versions calculate exactly how many books you must read per month to finish the list before you die, based on your current age. Personal Customization:
Readers can filter by genre, country of origin, or author gender, often highlighting the "Anglocentric" gaps in earlier versions of the list. Gamification vs. Deep Reading The spreadsheet format introduces a level of gamification
to literature. For many, the satisfaction of turning a cell green or watching a progress bar tick upward provides the motivation to tackle daunting classics like War and Peace
. It transforms a vague "I should read more" into a concrete, measurable goal. 1001 Books: You Must Read Before You Die - Amazon UK
Tracking the 1001 Books You Must Read Before You Die (edited by Peter Boxall) is a major project because the "official" list has changed across multiple editions (2006, 2008, 2010, 2012, and 2018). A comprehensive spreadsheet typically covers the 1,315+ unique titles
that have appeared in any edition to ensure no "must-read" is missed Core Spreadsheet Features
Most high-quality tracking sheets include the following data points to help you manage the challenge: Book Details : Title, Author, Publication Year, and Original Language. Edition Tracking crosses every genre
: Columns marking which edition(s) the book appeared in (e.g., "2006 Only," "Added in 2012"). Progress Dashboard
: Automatic "Totals" tabs that calculate your percentage complete based on your "Read" checkmarks. Reading Stats
: Advanced templates sometimes calculate how many books you need to read per year based on your age to finish the list "before you die". Top Spreadsheet Resources
Several community-maintained versions are widely considered the gold standard: Rosemary’s Combined List : A free, highly detailed spreadsheet on that lists 1,316 unique titles across all editions. Arukiyomi’s Spreadsheet
: Often cited as the most comprehensive "official" community version. It includes advanced stats and tracking for every book ever listed in the series. It is available through the Arukiyomi website Google Drive Templates
: You can find various community-made "checkable" lists hosted on Google Sheets for easy mobile tracking. The StoryGraph Challenge : While not a traditional spreadsheet, The StoryGraph
hosts a digital "All Editions" challenge that acts as a live, interactive database for 1,537 related books. Sample Entry Structure
If you are building your own, your headers should look like this: Date Finished Don Quixote Miguel de Cervantes Pride and Prejudice Jane Austen breakdown of the books added or removed in the most recent 2018 edition? AI responses may include mistakes. Learn more Boxall's 1001 Books You Must Read Before You Die
The Ultimate Guide to the "1001 Books to Read Before You Die" Spreadsheet
If you are a bibliophile, you’ve likely encountered "1001 Books You Must Read Before You Die," the iconic reference book edited by Peter Boxall. While the physical book is a beautiful addition to any coffee table, the true "power user" method for tackling this monumental list is through a 1001 books spreadsheet.
Using a spreadsheet transforms a daunting list of titles into an interactive, trackable, and deeply satisfying literary journey. Whether you are a casual reader or a dedicated completionist, here is why a digital checklist is the ultimate tool for your reading life. Why Use a Spreadsheet for the 1001 Books List?
The "1001 Books" list isn't static; it has seen multiple editions (2006, 2008, 2010, and beyond), with newer titles replacing older ones. A spreadsheet allows you to:
Track Multiple Editions: Some readers aim for the "Master List"—a combination of every book that has ever appeared in any edition of the series (roughly 1,300+ titles).
Filter by Genre and Era: Easily sort by "Pre-1800," "19th Century," or "Post-War" to match your current mood.
Visualize Progress: There is nothing more satisfying than watching a progress bar move from 1% to 10% as you check off classics. 315 to 1
Log Personal Data: Add columns for "Date Read," "Personal Rating," and "Library Availability" to make the list work for your specific lifestyle.
The core function. Use a simple drop-down: Not Started, In Progress, Completed, DNF (Did Not Finish). Color-code these (e.g., red, yellow, green, gray) for instant visual dopamine.
If you are the type of person who gets a thrill out of color-coded tabs and the satisfying "thud" of a heavy hardcover, this post is for you.
Like many readers, I have a "To Be Read" (TBR) pile that is slowly threatening to take over my living room. But a few years ago, I decided to tackle the Mount Everest of reading challenges: 1001 Books You Must Read Before You Die.
If you aren’t familiar, this is a reference book edited by Peter Boxall that attempts to catalog the most significant, beautiful, and groundbreaking novels ever written. It spans centuries, crosses every genre, and includes everything from Pride and Prejudice to The Road.
It is a magnificent list. It is also a terrifying list.
But there is one tool that has saved me from drowning in this literary ambition: The Spreadsheet.
Here is why downloading (or creating) a tracking spreadsheet for this challenge is the best decision a serious reader can make.
The list is intimidating. Let’s be honest: some of the books on there are slogs. I’m looking at you, 800-page modernist stream-of-consciousness experimental fiction.
When I first looked at the list, I felt defeated. I had read maybe 50 of them. I had over 900 to go.
But the spreadsheet changed my mindset. I set up a conditional formatting rule (a fancy way of saying I made the cells change color). When I mark a book as "Read," the line turns green.
Watching that sea of white rows slowly turn green has become addictive. It gamifies reading. It turns The Brothers Karamazov from a homework assignment into a quest objective.
A crucial column for the modern reader. Are you heavy on American/British authors? Use this to hunt for Nigerian, Indian, or Chilean writers on the list.
If you are a bibliophile, you have likely encountered the daunting concept of "The List." Whether based on the popular reference book by Peter Boxall or the "BBC’s Big Read," tracking these literary giants is a rite of passage for serious readers.
While a physical checklist is satisfying, a spreadsheet is the ultimate tool for tracking your progress. It allows for sorting, filtering, and data visualization that a paper list cannot provide.
Here is everything you need to know about utilizing a "1001 Books" spreadsheet.