# read multiple files and store them in a dictionary 'sheets' wb = pd.ExcelFile('./data.xlsx') sheets = {} for name in wb.sheet_names: sheets[name] = pd.read_excel(wb, name) # access dataset sheet.get('sheet_name')