I was able to import an Excel file as follows: import pandas as pd df = pd.read_excel(r"T:\P&A\MVP\ABoutput.xlsx", sheet_name=['Report'], skiprows=[0]) print(df) There is one word in row 1 of the file that I want to fix the spelling for. I've tried str.replace, iloc, etc. No idea what I'm doing wrong. Continue reading...