Start from the earliest works and move forward. Focus on a genre: Tackle all the Gothic novels first. Mix it up: Alternate between a classic and a modern work.
When you finally hit 100% complete on your spreadsheet—whether that takes 5 years or 20—you won’t just have a green-lit column of 1,001 titles. You will have a dataset representing years of your intellectual life.
Books you currently own or plan to read in the immediate future. Current: The book or books you are reading right now. Completed: Books you have successfully finished. Conditional Formatting for Visual Anchors
Here is how to build, customize, and optimize your ultimate reading spreadsheet workflow to conquer the 1001 Books challenge. 1. Sourcing the Master Data 1001 books to read before you die spreadsheet work
Arukiyomi's original project, born from a LibraryThing forum post, is still the most referenced. You'll typically find two versions:
Apply a color gradient to your "Publication Year" column. This allows you to visually scan your sheet and instantly see the transition from ancient classics to ultra-modern fiction. Drop-Down Data Validation
Ready to get started with your own digital reading journal? Here are your main options: Start from the earliest works and move forward
To see exactly how many books you have read, use the COUNTA and COUNTIF formulas: =COUNTIF(Status_Column, "Completed")
Ensure your spreadsheet is built in Google Sheets or saved to a cloud drive (OneDrive, iCloud) so you can access it on your phone. When browsing a used bookstore, you can quickly open the app, filter by "Unread," and verify if a cheap book on the shelf is part of your lifetime challenge.
Collaboration & sharing
I can also help you by genre or century to help you find a starting point.
A dedicated spreadsheet provides several distinct advantages:
Use simple formulas to turn data into motivation: When you finally hit 100% complete on your
on StoryGraph lists over 1,600 titles, including bonus "deleted" books from older editions. How the List Evolves