Geeking out with books…

SF Bookshelf

SF Bookshelf

Just finished with a fun little experiment, thought I’d share it.  Anybody that’s ever visited my house knows that I’ve got a lot of books laying around.  A lot.  The 2nd bedroom/office has a good chunk of 3 walls covered and there are bunches more out in the living room.  For some reason I’ve pretty much always held onto the books I’ve read – something I started when young and at this point it seems like  it would be a shame to stop now.   And I do love to be able to pull a previously-read book off of the shelf and dive back into it, even if only for a few minutes.    But I also can’t look at them without contemplating how everything one has read contributes to who they have become.  You are what you read, right?   There’s a little part of each one of these books up in my brain somewhere…

At any rate,  I’ve always thought it would be handy to have a list of them.  (Okay, I’m not really sure why it would be handy… it just seems like it would, okay?)

But even I am not quite obsessive enough to sit down and actually type in such a list… there’s just better things I could spend my time on.  Getting someone else to do the work, however, isn’t a bad idea… and anybody who is plugged into productivity blogs like Lifehacker or 43Folders can’t help but be aware of how easy it is these days to get some cheap outsourced labor for doing exactly this sort of thing.  So, mostly out of curiosity, I thought I’d see how well that sort of thing works.

The first thing I did was take good photos of all the bookshelves.  It took a little more time than I’d planned – I wanted to make sure the images were readable so I shot on a tripod to get nice sharp images and that meant each image took a bit of setup. (There also ended up being some shuffling of lights around in order to find a configuration that didn’t put text-obscuring glare on the books as well – I sure could have used a softbox, but don’t have one handy at the time.)  But overall it wasn’t too painful and as soon as I had a decent picture of most everything I tossed it all up on Flickr.  It took a total of about 50 photos to cover all the bookshelves – a subset of these can be found here, just to give you an idea of what the photos were like.  These are mostly the books from my main ‘SF paperback shelf’ – which is a pretty decent sampling of what I was reading while growing up, along with some newer works.

Just having the photos alone is kind of cool, actually.  At least to me.  But the next step was to get an actual text listing of all these books – so it was time to see if I could get someone to do that work for me.  I used Elance and the bid looked like this:


Convert photos of bookshelf into list of books

I’ve taken high resolution photos of all the books on my bookshelves (so you can see their spines) and want to have someone transcribe this information into a spreadsheet (Excel or Google Spreadsheet). The spreadsheet should have book title, author and then you’ll need to use this information to look up the ISBN for the book and include that. Presumably not all of the books will have an ISBN associated with them but do your best :-). The photos that you will be working from are located here:…

If you look through these you’ll see that towards the end there are several photos that overlap with each other, due to the difficulty in photographing certain shelves. Let me know if there are any other questions.


Elance is pretty straightforward – the interface is a little bit convoluted (actually it’s pretty poorly designed, IMHO) but once you get the basic idea it’s easy enough to set up the parameters of your project.   So I did that, posted it, and then the bids started rolling in.  The first few were a little frightening – several people set their price in the $500 range… and believe me, having a list of the books that I own isn’t worth that much to me.  But the nice thing about Elance is that you can choose to make all bids visible to other bidders so competitive pressure quickly brought the price down.   Like, wayyy down, until we were much more in the range I felt comfortable with.  I ended up choosing someone who had never done work on Elance and was willing to do the work for a very good price ($50) in order to build up his online reputation on the service.  At that price I figured it was a pretty safe bet, particularly since he’d already gone and transcribed the first photo from the set and the accuracy was great.

We agreed that a week was a reasonable timeframe and off he went.  And about 5 days later my oursourced librarian/servant sends me an email saying he’s finished.  Cool.

I quickly looked over the spreadsheet he’d sent (2000+ books!) and spot-checks seemed to indicate that the author/titles were reasonably accurate.  The few ISBN’s that I tested were also good.   I got online and released the $50 I’d put into Elance’s escrow and boom, we’re done.  Here’s an excerpt of the spreadsheet.  It’s all the books from my ‘SF paperback’ shelf… a testament to a youth spent down in the basement, exploring strange and fascinating new worlds…

But Wait, There’s More…

Having the ISBN for each book is particularly handy because now I can export that information into one of the online book-organizational tools like Shelfari.   Shelfari (and other similar sites like librarything and goodreads) allow you to keep a list of all your books online but also to gather additional information about the books, have online discussions with other readers, etc.  Social networking for book-lovers.   (There’s also the very cool Delicious Library, a standalone application for organizing your books, DVD’s and, um, power tools).

Shelfari allows you to enter the books you’ve read in a variety of ways, from manually entering individual titles to extracting them from a webpage.  But they also support importing a big list of books in a text document.  Hey, I just happen to have one of those.

I figured I’d test it with a subset of the big list so I selected only the SF paperbacks again, exported that from Excel to a tab-delimited text (.txt) document and pointed Shelfari at the file.  And off it went.  Took a few minutes and then it came back with a notice that it had imported about 460 books.   That’s out of the 600 or so that I had on the shelf (excluding the bottom row of old Asimov’s magazines) which is a decent percentage I suppose but obviously it would be nice to have gotten more of them.  Still, pretty cool.  I’m not quite sure yet why most of the others didn’t import properly.   Some of the book in the spreadsheet, like J.G. Ballard’s The Crystal World (ISBN 0380551608) didn’t import into Shelfari but a simple google search (as well as a search on Amazon) quickly turned up a correct match for that ISBN number.  Other books in my spreadsheet, like ISBN# 0380359561 (for  Zelazny’s Creatures of Light and Darkness) doesn’t show up anywhere online that I can find (including on the website which is what my Elance guy told me he’d used).  So clearly there is some inaccurate data in the spreadsheet itself.

Ah well, not something I’m going to worry too much about right now.  If you’re curious, the list of books that didn’t import properly is here.

And if you want to see my Shelfari bookshelf for the books that did import (all laid out on that nice wood-grain Shelfari bookshelf), you can go here:

And that’s probably about all I’ll be doing with all this information for now.  The next step is waiting for the day when I can send this list over to some magical machine that’s able to squirt a ‘refresh’ of all the plotlines and character arcs for all of these books back into my brain.   Someday…