Merge Multiple Employee Excel Files into One with Python – Step‑by‑Step Guide

Introduction

In a recent Python community query, a user asked how to automatically combine multiple Excel files containing employee performance data (date and score) into a single spreadsheet.

Solution

The provided Python script uses pandas to read each Excel file in a specified folder, concatenate the data vertically, and save the combined result.

import pandas as pd
import os

file_names = os.listdir("C:/Users/pdcfi/Desktop/绩效")  # get all file names
df1 = pd.DataFrame({"日期": [], "绩效得分": []})
for file in file_names:
    if file.endswith(".xlsx") or file.endswith(".xls"):
        df2 = pd.read_excel("C:/Users/pdcfi/Desktop/绩效/" + file, engine='openpyxl')
        df3 = pd.concat([df1, df2])  # vertical concatenation
        df1 = df3
        print(f"{file}已经合并！")

print(df1)
df1.to_excel("合并表格.xlsx", engine='openpyxl')

Running the script produces the expected merged spreadsheet, as shown in the screenshots.

The result confirms that all employee performance tables have been successfully combined without reading errors.

Conclusion

This article demonstrates a practical Python automation solution for merging Excel files, providing the full code and explaining each step, which helps users efficiently handle similar data‑processing tasks.