import pandas as pd data = pd.read_excel (r'C:UsersRonDesktopProduct List.xlsx') df = pd.DataFrame(data, columns= ['Product']) print (df)