How to Auto‑Rename Multiple Excel Performance Files with Python in Seconds

Hello, I'm PiPi.

1. Introduction

In a recent Python group, a user asked how to automatically rename multiple Excel performance files whose names are inconsistent, aiming for a uniform format like "ZhangSan8月绩效.xlsx" or "LaoLiu8月绩效.xlsx".

Below are the screenshots of the original files.

And the image of the provided example.

2. Implementation

One contributor provided the following Python script to rename the files:

import os

name = ["张三", "李四", "王虎", "老六", "二虎"]

file_name = os.listdir(r"C:\Users\pdcfi\Desktop\绩效")

for n in name:
    for file in file_name:
        if n in file:
            os.rename("C:/Users/pdcfi/Desktop/绩效/" + file,
                      "C:/Users/pdcfi/Desktop/绩效/" + n + "8月绩效.xlsx")
            print(f"{n}已经替换完成!")

Running the script produces the expected renamed files, as shown below.

The issue was resolved successfully.

3. Conclusion

This article demonstrated a practical Python automation solution for batch‑renaming Excel performance reports, providing both the problem analysis and a ready‑to‑use code snippet.

When posting questions, it is helpful to provide sanitized demo data, concise code, and error screenshots to facilitate quick assistance.