Via Daily python tip, a snippet to read xls files in python. This will come in handy. Saving for future.
Get set up with:
pip install pandas
pip install xlrd
Read with:
import pandas
xlf = pandas.ExcelFile("sheet.xlsx")
print xlf.sheet_names
[u'my sheet']