conda install -c anaconda xlrd #libarary that reads excel file df = pd.read_excel (r'Path where the Excel file is storedFile name.xlsx', sheet_name='your Excel sheet name')