1001 Books To Read Before You Die Spreadsheet Work ◆
This is where the "spreadsheet work" gets powerful. Add these columns to the right of your master list:
Pro tip: Use conditional formatting (found under Format > Conditional formatting in Sheets/Excel). Set a rule that turns the entire row green when the "Status" column says "Finished." Turn abandoned books gray. The visual dopamine hit of seeing rows turn green is a genuine psychological driver.
You’ve seen the list. 1001 Books to Read Before You Die, edited by Peter Boxall. It’s the literary world’s most ambitious bucket list—a glorious, intimidating mountain of classics, hidden gems, and doorstop-sized tomes spanning centuries. 1001 books to read before you die spreadsheet work
But let’s be honest: staring at that dense, 10-page fine-print list in the back of the book is overwhelming. How do you know what you’ve read? What should you tackle next? Where’s the data?
The answer is simple, geeky, and gloriously satisfying: the spreadsheet. This is where the "spreadsheet work" gets powerful
If you search for "1001 books to read before you die spreadsheet work," you are looking for a system, not just a list. You want to move from passive wishing to active tracking. Here is how to build, customize, and use the ultimate literary spreadsheet—and why it works.
Not all 1,001 books are equal. Infinite Jest (1,079 pages) is not the same commitment as The Mezzanine (135 pages). Add a column for "Estimated Reading Hours" (Pages / 50 pages per hour on average). Pro tip: Use conditional formatting (found under Format
The Master Formula:
=SUM(ReadingHoursRange) - SUM(FinishedReadingHoursRange)
This tells you exactly how many hours of life you have pledged to this list. It is terrifying. It is motivating.
At the top of your sheet, create a mini-dashboard using simple formulas:
Pro tip: Use conditional formatting. Turn the row green when Status = "Read". Turn it yellow when Status = "Reading". Watch your spreadsheet bloom like a literary garden.