While I think Pandas are a far better way to deal with spreadsheet type data, using xlrd and xlwt come in handy when you are dealing with irregular spreadsheets.
I like ethercalc.org an open source google like spreadsheet that puts spreadsheet data into an online database.