Read the excel files, concat them and append the data − for file in filenames: df = pd.concat (pd.read_excel (file, sheet_name=None), ignore_index=True, sort=False) outputxlsx = outputxlsx.append (df, ...