Here’s what I built in Google Sheets. You can replicate it in Excel or Notion.
For decades, bibliophiles have treated Peter Boxall’s 1001 Books to Read Before You Die as the Mount Everest of literary challenges. It is a dense, opinionated, and glorious list of the greatest novels, short story collections, and memoirs from the 18th century to the modern day. But let’s be honest: staring at a 960-page brick of a book listing hundreds of titles can be paralyzing.
How do you track your progress? How do you filter the 17th-century Russian epics from the post-modern American satires? How do you remember why you hated a particular Booker Prize winner in 2013?
The answer lies in one powerful tool: The "1001 Books to Read Before You Die" Spreadsheet. 1001 books to read before you die spreadsheet work
Far from being tedious busywork, building and maintaining a spreadsheet for this challenge transforms a chaotic literary ambition into a manageable, data-rich, and deeply satisfying project. This article will guide you through every step of creating the ultimate reading tracker—from basic lists to advanced pivot tables that reveal your own reading psychology.
Use HYPERLINK to link the title directly to:
If you create a pivot table or a histogram based on the "Year" column, you will notice a sharp spike in density starting around 1920. The modernist explosion and the post-war boom mean that a massive percentage of the "1001" books were published in the last 100 years. This highlights a shift from "survival" literature to "self-reflective" literature. Here’s what I built in Google Sheets
When you build your master sheet (Google Sheets or Excel), you need the following columns minimum:
The keyword includes "work" because this is not a passive hobby. Here is the weekly routine of a spreadsheet reader.
Sunday Evening (10 minutes):
While Reading (2 minutes per session):
End of Month (30 minutes):