1001 Books — To Read Before You Die Spreadsheet Work _top_
Starter Google Sheets template layout (columns row 1) ID | Title | Author | Year | Genre | Tags | Priority | Status | Start date | Finish date | Pages | PagesRead | Rating | Notes | Link
Format the percentage cell as a percentage ( % ) to watch your progress climb from 0% to 100%. Dynamic Conditional Formatting
: A massive overhaul swapped out 286 titles to welcome a broader, international scope of global literature.
=SPARKLINE(COUNTIF(H2:H1301, "Completed"), "charttype","bar"; "max", 1001; "color1", "green") 3. Dynamic Checklist Checkboxes 1001 books to read before you die spreadsheet work
Remember, the goal is not just to check off boxes, but to experience great literature. Use your spreadsheet to tailor the challenge to your tastes. You might choose to:
The list is inherently subjective, offering a mix of high modernism, genre fiction, magical realism, and post-colonial voices. A spreadsheet helps visualize these shifts in literary trends over centuries.
Happy tracking. You have 1,001 books to go. Starter Google Sheets template layout (columns row 1)
Copy the data into Google Sheets (best for cloud access across devices) or Microsoft Excel (best for advanced data processing and offline use). Step 2: Essential Columns for Your Spreadsheet
For those who want a free, comprehensive spreadsheet, a popular community-maintained version is by a user named Rosemary. This Google Sheet lists all 1,316 books from the combined 2006, 2008, 2010, 2012, and 2018 editions. It's hosted on Google Drive, and anyone can open the link and save a personal copy to their own account.
This is where "spreadsheet work" becomes an art form. You are not just checking boxes; you are building a personal literary analytics engine. Dynamic Checklist Checkboxes Remember, the goal is not
Use your spreadsheet filters to alternate between heavy historical epics and lighter, contemporary novels from the 21st century.
Helps maintain the original chronological or numerical list order. Title: The book's name. Author: The writer's full name.
