Automated Multi-File Excel Reporting with Python
An in-progress Python script that merges and appends data from multiple Excel files into one dataset and generates the report automatically, cutting preparation from 12–16 hours to around 2.
At a glance
-
A recurring report had to be assembled by hand from multiple Excel files — merging columns and appending rows before reporting could start.
-
A Python script merges columns and appends data from the Excel files into a single dataset, then generates the report automatically.
-
Reduces report preparation from 12–16 hours of manual work to around 2 hours.
Overview
Recurring reports often start with the same manual routine: open several Excel files, line up their columns, copy rows into one sheet and then build the report on top of it.
This project replaces that routine with a Python script. It merges columns and appends data from multiple Excel files into a single dataset, then generates the report automatically.
Status: in progress.
Problem
Preparing the report by hand meant:
- Combining data spread across multiple Excel files
- Merging columns and appending rows manually before any reporting could start
- Repeating the same preparation steps every reporting cycle
This took 12–16 hours of manual work each time.
Approach
The script uses pandas and NumPy to:
- Read the input Excel files
- Merge columns and append rows into one unified dataset
- Produce the finished report with openpyxl
Expected Impact
- Reduces report preparation time from 12–16 hours of manual work to around 2 hours
Technologies & Tools
- Python – Scripting and automation
- pandas – Merging and appending tabular data
- NumPy – Numerical operations
- openpyxl – Writing the Excel report