Spreadsheet v2
If you’re looking for the 1001 books spreadsheet, you’ve come to the link for one of the old versions.
For the link to the new version, click
35,385 views Comments (84)
84 Comments
RSS feed for comments on this post. TrackBack URI
Sorry, the comment form is closed at this time.
[...] NEW!!! 1001 Books revised edition (2008) spreadsheet [...]
Pingback by Arukiyomi » NEW!!! - 1001 Books Revised Edition Spreadsheet — August 30, 2008 @ 3:49 pm
Wow, thank you, loved the first edition, will love this one even more! Thanks!
Comment by Plekter — August 30, 2008 @ 9:17 pm
Thanks! This is an awesome spreadsheet. You’ve done an excellent job. The dropped list is especially helpful.
- Jorie
Comment by Jorie — August 30, 2008 @ 9:57 pm
Download doesn’t work for me which is a shame. Would really like to have the new list.
Comment by Nadine — August 31, 2008 @ 5:41 pm
Thank you for this wonderful tool!
Comment by Ben — August 31, 2008 @ 10:49 pm
Had someone point out that Javier Marias has one of his books, All Souls, listed twice in the 2008 list. The more recent book should have been Your Face Tomorrow not All Souls again. I’ve sorted this now and have changed the Excel files.
This is exactly the kind of feedback that Arukiyomi likes. Please, please point out more bugs or errors if you find them.
Comment by Arukiyomi — September 1, 2008 @ 2:05 pm
Trouble downloading ~ after changing the zip file’s extension to xlsx, it downloads as a Read-Only file. Any troubleshooting ideas? I would really, REALLY like to use your wonderful list!
Thanks.
Comment by StarCityWoman — September 1, 2008 @ 5:20 pm
StarCityWoman – thanks for highlighting this issue. I’ve now realised that IE7 prevents you from downloading an .xlsx file directly, so I’ve zipped both files and upped them again to help IE7 users.
Comment by Arukiyomi — September 1, 2008 @ 7:48 pm
hi
when i try to download the 2003 file – it does download the spreadsheet but then it states that data is lost – file error – and then excel shuts down. I also cant download the 2007 version – any suggestions
Comment by still cant download — September 2, 2008 @ 5:47 am
Thank you so much, Arukiyomi. The embedded Wiki link is particularly fabulous ~ instant access to plot summaries confirmed I’d read several books I wasn’t 100% certain about Takes the pain out of losing 39 books with the new edition. You’re a hero!
Comment by StarCityWoman — September 2, 2008 @ 7:56 am
[...] When I found out this had been removed from the 1001 Books List, I could have kicked Boxall and myself in one fell swoop. [...]
Pingback by The Blind Assassin by Margaret Atwood « Jorie’s Reads — September 2, 2008 @ 7:19 pm
Thanks for the comment on my blog. I’m downloading the spreadsheet and checking out the list! Now I have some new goals.
Comment by LeLe — September 2, 2008 @ 7:42 pm
The 2003 download doesn’t work for me either. Such a shame
Comment by Idril — September 5, 2008 @ 12:23 pm
I am getting the “read only” message too. I can’t open either list. Do I have to use IE? I am using Firefox. Thanks!
Comment by Kara — September 7, 2008 @ 3:06 am
Thanks for the new download! One thing I noticed…in the 2008 Edition tab (2003 Excel Version), cell A1002 shows ‘2000s’ where I think it should be ‘pre-1700s’
Comment by Kylie — September 9, 2008 @ 12:57 am
Thanks for letting me know that Kylie. I’ve sorted that and uploaded new files.
Comment by Arukiyomi — September 9, 2008 @ 9:41 pm
Oh dear… I wanted to use the 2007 file and i cant open it. I cant seem to change the file extension either. =(
Comment by Kimberley — September 10, 2008 @ 1:47 pm
What an impressively large amount of work you must have put into this. I especially appreciate the links to the Wikipedia entries, since Wikipedia often links to free online versions of public domain books. Ditto for the Google Books links. Thank you for putting this together.
Comment by Dusk Peterson — September 10, 2008 @ 3:19 pm
Thanks for letting me know about this. I’ve downloaded it and will be adding things to my massive digital TBR pile (on my Kindle). A lot of this should be available for free through Project Gutenberg and similar organizations. But for those books I actually buy, I’ll make sure to go through your links.
Comment by Lucid Lunatic — September 11, 2008 @ 12:49 am
[...] NEW!!! 1001 Books revised edition (2008) spreadsheet [...]
Pingback by Arukiyomi » Indigo - Marina Warner — September 12, 2008 @ 10:04 am
Thanks for your comment on my blog…I really appreciate you sharing this freely with us! Wonderful!!
Comment by flamingandromeda — September 17, 2008 @ 5:16 am
[...] am a sucker for lists. A while ago I found a link to the list of 1001 books I “should” read and I’ve been working my way through it (I’ve read lots of [...]
Pingback by Brave New Genre « Tauken — September 20, 2008 @ 10:36 pm
Thanks for the wonderful list. Damn, I might have to buy the new edition. It was very helpful that you listed the dropped books. I have a book list comparison site at http://classicbooklists.com/ that you might be interested in.
Comment by Jim Harris — September 21, 2008 @ 3:11 am
Thanks so much for this – what a fantastic tool!
I think _Red Harvest_ by Dashiell Hammett is missing. I have the 2006 edition of the book in front of me, and here’s the entry on page 339, but I don’t see _Red Harvest_ on either the 2008 tab or the 2006 removed books tab.
Comment by Suzanne — September 22, 2008 @ 11:49 pm
you know what Suzanne… you are absolutely right. It must be that there are 283 books which have been removed and Hammett’s should be one of them. It can’t be on the revised list as there are already 1001 books there. So, I’ll have to add that at some point.
Jim – thanks for the link to your interesting list comparison site. That must be a unique web project so grateful to know about that.
Comment by Arukiyomi — September 24, 2008 @ 12:15 am
The 2003 version will not download properly. How can I get this to work? Thanks!!
Comment by Heather — September 24, 2008 @ 3:52 am
sorry Heather but I need more info to help me. Email totalrubbish AT gmail.com with more tech details of what OS, browser etc you’re using and what exactly happens when you click the button. Hundreds of people have successfully downloaded this version so it usually works. One or two have said they can’t get it though so I wish I could find out why.
Comment by Arukiyomi — September 26, 2008 @ 11:49 pm
Wow! This is brilliant. It looks like a labour of love. Can’t wait to work my way through it to see what I’ve read and what I havent.
Comment by kimbofo — October 7, 2008 @ 9:09 pm
Dear Arukiyomi and fellow book (and list) lovers,
What a fantastic service. I was wondering, and others may have asked this, but do you have a list of the 282 books *added* in the new edition?
This would really help me with my own list of books that I want to read.
(I realise you have the new 1,001 and the removed 282, but is there a quick or available way to tease out the 282 new titles added?)
Many thanks,
Martin Boer
Amsterdam
Comment by martin — October 21, 2008 @ 11:26 am
Hi John,
Can you e-mail me again, I’ve misplaced your address and have a spreadsheet to send you.
Cheers,
Martin
Comment by martin — October 27, 2008 @ 1:42 pm
Do you have the spreadsheet available with the ones you have read? Just curious . . .
Comment by Jorie — October 28, 2008 @ 8:32 pm
well, I have my own copy if that’s what you mean. I’ve read 133 off the new list and 33 off the 282 that were removed. Currently working on two more.
How about you?
Comment by Arukiyomi — October 28, 2008 @ 11:51 pm
Hi, just wondering, it looks like The Story of Lucy Gault by William Trevor is listed on the 2008 revision, but you also have it on the list of books cut from the 2006 edition. Is it still in? Thanks!
Comment by Sylvia — October 30, 2008 @ 1:52 am
This list is amazing!!! Thank you so much. So, apparently I have only read 2% of the books… I guess I need to get cracking!!!
Comment by Kathryn — November 10, 2008 @ 11:28 pm
Hello, I’m a big fan of the original list. I downloaded the new 2003 version and even upgraded to Office 2003 to use it, but I’m getting the same problem I had when I tried it in Office Excel XP: any link that I click in the new file (such as “click HERE to see the new 1001 books list”) opens up my web browser and goes to the following page:
http://www.listology.com/profile_public.cfm/indv_id.7671/b_check_link_dest.True
I’ve just discovered the tabs (duh!) but why don’t the links work properly? I find that I can’t even click and hold the cells to edit them because it opens my web browser.
Any ideas on what’s going on?
Comment by Joseph — November 12, 2008 @ 1:11 am
Hey All,
some have been asking which books have been added. I’ve found this link which will give you what you want. Eventually, I might colour the additions in the v2 spreadsheet. Don’t hold your breath though!
http://pagesturned.blogspot.com/2008/06/2008-edition-of-1001-books-new-additons.html
Comment by Arukiyomi — November 15, 2008 @ 12:35 pm
@ Sylvia… The Story of Lucy Gault should have been removed. Sorry about that.
@ Joseph… links don’t work for me at all now actually! I think it’s something to do with the protection I’ve got on the workbook. If you search help to find out how to unprotect the workbook, you might be able to use the links.
Comment by Arukiyomi — November 15, 2008 @ 12:44 pm
Thank you for the great resource– I printed out the old list originally and checked the books I had already read off and highlighted the ones I owned-but-had-not-read in some kind of confusing color coded system. My count on the new list is 130, a drop of twenty some books from the old list. Which just means i have 1283 books to read before I die, when these list powers combine.
Comment by Christine — November 17, 2008 @ 11:57 am
Hi Christine,
Good news! I’ve also made a combined list and come up with 1,281 books, so that’s two fewer for you to read.
Comparing our lists, I’ve noticed the following:
* Three books were double-counted as they were also on 2006 list: Rameau’s Nephew (0066 and #35), The Call of the Wild (0223 and #88), Fear and Trembling (0948 and #927)
* One book doesn’t exist on either list as far as I can tell: Insatiability (0334)
* Two books are missing from your list (Some Prefer Nettles, The Life of a Good-for-Nothing)
So, 1,283 – 4 + 2 = 1,281
Cheers,
Martin Boer
Amsterdam
Comment by martin — November 17, 2008 @ 1:32 pm
Apologies, I guess I was responding to Christine and Arukiyomi (John).
But the total still stands, I believe, at 1,281, of which, so far, I’ve only read a modest 130…
Comment by martin — November 17, 2008 @ 1:35 pm
hi,
Really wanted to download the spreadsheet, but having real problems. Renamed the 2007 version to xls and now it says: error, data may be lost!!! sorry to bother – i’m not the best with computers!
thank you!!
Comment by Lucy — November 18, 2008 @ 9:12 pm
hi,
Really wanted to download the spreadsheet, but having real problems. Renamed the 2007 version to xls and now it says: error, data may be lost!!! sorry to bother – i’m not the best with computers!
thank you!!
Comment by Lucy — November 18, 2008 @ 9:12 pm
Hi,
I am having exactly the same problem as Lucy. I download the 2007 version, change the file extension as you stated and it says data lost and won’t open. It’s really great that you have put this list together, do you mind sending a copy over to me though so I can use it?
Many thanks.
Comment by Nikki — November 21, 2008 @ 12:48 pm
Sorry to have bothered you I have now worked it out! Doh! Thankyou!
Comment by Nikki — November 21, 2008 @ 12:52 pm
Hello! Love, love, love the spreadsheet and your photos of the books you’re reading. I don’t think it’s been mentioned as I’ve searched through the comments but not actually read them all…In the new spreadsheet, Ken Kesey’s Sometimes a Great Notion appears in both the updated list and the list of removed books. I believe it’s 281 Books You Used to Have to Read Before You Died, not 282, because one of those you still have to read before you die!
Comment by Emma — November 25, 2008 @ 5:58 am
Ah, but as Suzanne noted on 9/22/08, Red Harvest brings it back up to 282!
e
Comment by Emma — November 25, 2008 @ 6:17 am
Hi,
I work for the company that created “1001 Books You Must Read Before You Die”. We have recently set up a website for this and the other titles in the series, http://www.1001beforeyoudie.com.
We are considering updating this book again in the future, and would love to hear your opinions on this. What books should not be on the list? What books have we missed off? Please stop by and let us know!
Comment by Nell — November 25, 2008 @ 4:41 pm
This is awesome!! Thank you so much!
Comment by Leza Zaman — November 25, 2008 @ 5:28 pm
i can download this 2007 version, but it keeps doing it in read only. so i cant make additions to my version. can you tell me what conversion i need to use to make it so that i can typr in ‘r’ and ‘tbr’ on my spreadsheet and keep it updated?
Comment by shelly — November 26, 2008 @ 11:18 pm
it keeps doing it in read only. so i cant make additions to my version. can you tell me what conversion i need to use to make it so that i can keep it updated?
Comment by shelly — November 26, 2008 @ 11:18 pm
please help me. i cant seem to make this file anything other than read only. i would like it so that i can update it…
Comment by shelly — November 26, 2008 @ 11:46 pm
I believe the book Libra by Don Delillo is listed both on the 2008 edition and on the 2006 removed books list.
Comment by Jory — November 27, 2008 @ 5:10 am
Hi! Could you send me the 2003 version of the spreadsheet. I tried to download it but it didn´t work.
Comment by laura_88 — December 8, 2008 @ 9:04 am
Thanks Arukiyomi! Now it works.
Comment by laura_88 — December 8, 2008 @ 11:43 am
Would loie to get a copy, but the dowbnload didn’t work. Alas, I’m still using Office 2000. Can you please help? Thanks so much!
Comment by Donna — December 17, 2008 @ 4:39 pm
I can’t seem to download the file completely. Could you please send it to christine.horan@yahoo.com ?
Thanks.
Comment by Christine H — December 22, 2008 @ 10:20 pm
Hey there,
Great spreadsheet, thanks!
I just went through and compared the sheet with the “official” list over at the book’s site (I was adding publication dates), and came up with a couple of corrections, assuming their info is correct.
As far as I can tell, The Story of Lucy Gault and Libra shouldn’t be on the current spreadsheet, but Insatiability by Stanislaw Witkiewicz should be. There must be another book missing too, but not sure what it is, sorry.
Hope this info helps.
Cheers
Ben
Comment by Ben — December 30, 2008 @ 11:53 am
Thanks Ben… your comment coincided with me updating the list. Version 2.1 is now out and this is definitely the perfect list – in exactly the same order as the book. I’d been relying on lists published online by amateurs until the website for 1001 was officially upped. So, no further comments necessary (hopefully!) on what should and shouldn’t be there!
Comment by Arukiyomi — December 30, 2008 @ 2:00 pm
Just wanted to say thank you for this. It’s the first I’ve heard of it. I found you on a Librarything page and i think I’ve just struck gold. I’ll let you know if I buy any books on Amazon because of this. You are a genius (if no-one has told you lately). Happy New Year!
Comment by Alex — January 1, 2009 @ 4:44 am
neither of the spreadsheets will work for me
Comment by Kristina — January 2, 2009 @ 11:49 pm
[...] there’s a new edition of Peter Boxall’s 1001 Books You Must Read Before You Die, and Arukiyomi has a new Excel spreadsheet for tracking your progress in reading the new list? My count for the old list from the first edition: 129. My count for the new list: Not sure [...]
Pingback by 12 Best Reading Lists of 2008 at Semicolon — January 3, 2009 @ 5:21 am
Hey, thanks for posting the new edition, can’t wait to download it! I was wondering how you made it available for downloading on your blog though. I want to do the same thing with some spreadsheets I’ve made, but I don’t know how.
Angela/AA1986
Comment by Angela — January 3, 2009 @ 6:10 pm
Wow, this is great! Thanks so much for this.
Comment by Kitty — January 9, 2009 @ 5:02 am
I’ve tried both the ‘07 and the ‘03 versions (have ‘07 viewer), but both come up “data may be lost” and crash excel. Might be because I’ve only got office ‘00
I’ve loved the 1,001 books list, I look forward to seeing the new version!
Comment by Rachael Y. — January 11, 2009 @ 4:38 am
yep… it undoubtedly is because you are using Office 2000. Sorry I can’t help with that. One day you will have a computer with at least office 03 on it!
Comment by Arukiyomi — January 11, 2009 @ 9:43 am
Rachael: You can put data from an old excel in a new excel, but they can’t go backwards. Sorry!
Comment by Angela — January 11, 2009 @ 5:20 pm
I downloaded the ‘03 version a very long while ago and it works splendidly, but for some reason the ‘07 spreadsheet doesn’t work for me. I feel terribly computer illiterate right now.
Comment by Samantha — January 11, 2009 @ 11:41 pm
I’ve download it, opened it and put r next to everything I’ve read and typed in my age, but the formula isn’t working and it’s not showing me what I’ve read or have to read. What am I doing wrong
Comment by Fee — January 15, 2009 @ 3:40 pm
I love your first version, however I can’t get the new one to work. It opens up save-only but none of the links work and if I change the filename my computer can’t open the file at all. *aaaargh* I would really appreciate it if you could help me because I am a list freak as well as a bookworm and I desperately want to see this list.
Comment by Nadine — January 17, 2009 @ 12:02 am
Fee- I had the same problem but once I clicked “save” it filled in the formulas for me. Hope that works for you.
Comment by Laura — January 17, 2009 @ 6:51 pm
Yay!….
Well sort of, I was disappointed to find that about ten of the thirty plus books I HAVE read have been ditched into the ‘has-been’ pile. But that isn’t your fault is it?
Anyway, what I really meant to do was thank you for this little doo-dad. Yet another thing to waste my time on!
Cheers
Comment by Carly — January 18, 2009 @ 1:57 pm
Would you send me as an attachment the new sheet as it does not seem to work by downloading it.
Thanks a lot.
Comment by Kinga — January 25, 2009 @ 12:06 am
Kinga, as some others of you, was trying to open the files using Open Office. As I’ve explained above but will restate, Open Office can’t cope with the features that the new spreadsheet uses. If you have Open Office, please don’t ask me to send you the file or help you open it as I can’t.
Thanks
Comment by Arukiyomi — January 26, 2009 @ 9:33 am
[...] you can go HERE for an Excel spreadsheet of the old list, and HERE for an Excel spreadsheet of the new [...]
Pingback by (Another) 1% Well-Read Challenge : 1% Well-Read Challenge — February 27, 2009 @ 9:01 pm
Hi. I can’t seem download the new version of the spreadsheet. Please help by sending it to me as an attachment? Thank you!
Comment by Michelle — March 2, 2009 @ 2:26 pm
Thanks for the awesome time saver. I’m looking forward to going through it.
Sorry to list this here, but I didn’t see an email address. Here’s one more correction for a future version: Sometimes a Great Notion by Ken Kesey is listed on both tabs.
Comment by Ms. SP — March 3, 2009 @ 12:07 am
[...] to track, some folks online have put everything into Excel spreadsheets. As far as I know, the original version resides at Arukiyomi. The latest spreadsheets there are causing some problems, and I couldn’t use it with my older [...]
Pingback by Ms. Smarty Pants Know It All » I’m 6-8% Well Read — March 3, 2009 @ 5:25 pm
[...] a good list and can’t help finding out just how many books they have already read, check out these great spreadsheets covering both the old and new [...]
Pingback by whelanflynn.com » Blog Archive » 1% Well Read Challenge — March 16, 2009 @ 12:16 am
[...] 15 of “1001 books to read before you die” [...]
Pingback by 101 in 1001 - The List EN « Corien’s Weblog — April 4, 2009 @ 2:44 pm
[...] April 5, 2009 The list can be downloaded here. [...]
Pingback by #47 Read 15 of “1001 books to read before you die” list « Corien’s Weblog — April 5, 2009 @ 8:17 pm
Excel 2003 version doesn’t work at all for me. I put in the books read, but total still remained at 0
Comment by Krys — April 6, 2009 @ 12:07 pm
as it says in the FAQs above…
“I’ve entered in all my r and tbr cells but the totals don’t change. Why is this?
You need to save the file. Once you do, it will calculate the values at the top of the spreadsheet.”
Comment by Arukiyomi — April 11, 2009 @ 2:55 pm
[...] 1001 Books spreadsheet v3 [...]
Pingback by Arukiyomi » 1001 Books Spreadsheet v3 released — May 1, 2009 @ 8:00 am
[...] by heart every Burn’s night 55.Watch my Dawson’s Creek DVD boxset 56.Read 30 books from 1001 Books to Read Before You Die 57.Go to three talks or lectures on any subject 58.Climb 3 Munros (doubling my tally. Oh [...]
Pingback by 101 in 1001 « Badsparklythings — January 4, 2010 @ 11:16 pm