← Case Studies In progress · Reporting automation

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

  1. 01 Problem

    A recurring report had to be assembled by hand from multiple Excel files — merging columns and appending rows before reporting could start.

  2. 02 Approach

    A Python script merges columns and appends data from the Excel files into a single dataset, then generates the report automatically.

  3. 03 Target

    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:

  1. Read the input Excel files
  2. Merge columns and append rows into one unified dataset
  3. 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