Worksheet A worksheet is a collection of cells where you keep and manipulate the data. Each Excel workbook can contain multiple worksheets . One of the ways to read an Excel file is loading the file, in our case linear_regresion_data.xlsx , by using pd.ExcelFile , and after that call each of the sheets that you have in your spreadsheet or workbook. # Load Excel File xlsx = pd.ExcelFile(r'C:\linear_regresion_data.xlsx') df1 = pd.read_excel(xlsx, 'Set 1') df2 = pd.read_excel(xlsx, 'Set 2') df3 = pd.read_excel(xlsx, 'Set 3') df4 = pd.read_excel(xlsx, 'Set 4') df5 = pd.read_excel(xlsx, 'Set 5') df6 = pd.read_excel(xlsx, 'Set 6') # Preview datasets display('Set 1', df1.head()) display('Set 2', df2.head()) display('Set 3', df3.head()) display('Set 4', df4.head()) display('Set 5', df5.head()) display('Set 6', df6.head()) As you can see in the example above, this is an inefficient way...