df.to_excel(r'C:\Users\Ron\Desktop\File_Name.xlsx', index = False) #if you omit the file path (must also omit 'r') and #enter only file_name.xlsx, it will save to your default file location, # that is, where the file you're reading from is located.
import pandas as pd pd.read_excel('tmp.xlsx', index_col=0)
import pandas as pd data = pd.read_excel (r'C:\Users\Ron\Desktop\Product List.xlsx') df = pd.DataFrame(data, columns= ['Product']) print (df)
#You will need the package openpyxl to use the .read_excel function. # pip install openpyxl import pandas as pd inFile = "Table.xlsx" inSheetName = "Sheet1" pd.read_excel(inFile, sheet_name = inSheetName)