import pandas as pd f = r'C:\work\CP_Automation\Simulated_Assessment_Engine\output\dry_run\adolescense\5_domain\Grit_14-17.xlsx' df = pd.read_excel(f) print(f"File: {f}") print(f"Columns: {list(df.columns)}") print(f"First row: {df.iloc[0].tolist()}")