Several community-maintained resources offer downloadable spreadsheets for tracking your progress: Arukiyomi's 1001 Books Spreadsheet
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
This growing library presented a unique challenge. In the pre-List App era (before 2010), how did you keep track? Some tried to check off entries in the book's index or maintain a handwritten list. But a forum user under the pseudonym had a better idea. In 2007, he released a downloadable spreadsheet to track reading progress, and a small community phenomenon was born. For completists, having the full list in a dynamic, sortable digital format was a revelation.
The "1001 Books" spreadsheet is more than a simple book list—it's an interactive tool that turns a monumental reading challenge into a manageable and rewarding personal project. By combining Peter Boxall’s expertly curated list with a customizable, dynamic tracker, you can not only discover essential works of literature but also watch your progress grow year by year. 1001 books to read before you die spreadsheet
: Often cited as the "gold standard" for tracking, this spreadsheet includes all versions of the list (2006, 2008, 2010, 2012, 2018, and 2021). It highlights "core" books—those that have never been removed—in blue. You can find it on arukiyomi.com Goodreads Community Spreadsheets
Filter out books you already own, view only titles available at your local library, or isolate specific genres like sci-fi, magical realism, or historical fiction. Essential Columns for Your Tracking Sheet
The writer's name (last name first helps with alphabetical sorting). But a forum user under the pseudonym had a better idea
Make your spreadsheet visually rewarding. Set up a conditional formatting rule on your column:
Do not try to read all 1001 books in two years. Use your sheet to map out a realistic goal—such as 25 books from the list per year—and track your annual quotas on a separate summary tab. Final Thoughts
The subreddit dedicated to this list maintains a legendary Google Sheets template. It includes all editions cross-referenced, checkboxes, and pre-built charts. Search for the "Official r/1001Books Spreadsheet" – it is the gold standard. The "1001 Books" spreadsheet is more than a
Helps you monitor the geographic diversity of your reading.
Make your spreadsheet dynamic by using color codes to highlight your progress: Highlight your column. Open Conditional Formatting .
Challenge yourself to read all the listed books from a specific continent or country before moving on.
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.