import pandas as pd import os df1 = pd.read_excel(r'C:\Users\datai\Desktop.find.xlsx') df2 = pd.read_excel(r'C:\Users\datai\Desktop.find1.xlsx') merged = pd.concat([df1, df2], axis=0, ignore_index=True) merged.to_excel('result.xlsx', index=False)