How to Add a Real-Time Progress Bar to Your Python Excel Merge Script

1. Introduction

A few days ago, a question was posted in a Python community about adding a progress bar to a script that merges Excel files, as shown in the image below.

The original code reads all Excel files from a directory, concatenates them with pandas, and writes the combined result to a new file.

import os
import pandas as pd
file_list = os.listdir(r"F:\123")
data_list = []
for file in file_list:
    data = pd.read_excel(r"F:\123\\" + file)
    data_list.append(data)
result = pd.concat(data_list)
result.to_excel(r"F:\123\合并表格.xlsx", index=False)

2. Implementation

One contributor suggested using the tqdm library to display a progress bar. The following modified script incorporates tqdm and prints a completion message.

import os
import pandas as pd
from tqdm import tqdm
file_list = os.listdir(r"F:\123")
data_list = []
for file in tqdm(file_list):
    data = pd.read_excel(r"F:\123\\" + file)
    data_list.append(data)
result = pd.concat(data_list)
result.to_excel(r"F:\123\合并表格.xlsx", index=False)
print('全部表格合并完成')

Running the script produces the expected merged file, as shown below.

Some community members later tweaked the output to make it look more polished.

3. Conclusion

This article demonstrated how to solve the problem of adding a progress bar to a Python script that merges Excel files, providing clear explanations and complete code that readers can adapt for their own data‑processing tasks.