pandas Pandas IO tools (reading and saving data sets) Spreadsheet to dict of DataFrames


Example

with pd.ExcelFile('path_to_file.xls) as xl:
    d = {sheet_name: xl.parse(sheet_name) for sheet_name in xl.sheet_names}