# Streamlining Excel-based workflows with Python automation

> An investment management firm · Financial Services

How QuantSpark modernised an investment management firm's Excel-based reporting with Python automation, cutting manual effort and improving data quality without replacing familiar tools.

## What was the problem?

The firm consolidated data from multiple Excel sheets into a master sheet every quarter, pulling from various sources, running calculations and preparing the final output by hand. The manual approach consumed significant time and introduced the risk of errors that could affect important business decisions. The firm wanted to modernise without a full digital transformation or abandoning its reliance on Excel.

## What did QuantSpark do?

QuantSpark built a custom Python pipeline that ingests data from APIs, databases and existing Excel workbooks, applies predefined transformations and calculations, and runs extensive automated data-quality checks before anything reaches production, with automatic alerts to the relevant parties when a check fails. The final master sheet can be generated on demand through a web application or scheduled to run automatically at the start of each quarter, with the same data also loaded into an interactive dashboard for users who prefer visualisations. The solution integrated with existing workflows rather than replacing them.

## What changed?

The firm saved substantial time previously spent on manual consolidation and improved data accuracy through rigorous automated checks, while retaining control of its data and its familiar Excel tools. Users can trigger the process on demand or on a schedule, keeping the team focused on analysis and decision-making rather than repetitive tasks.

---

Canonical page: https://quantspark.ai/case-studies/excel-python-automation-financial-services
More about QuantSpark: https://quantspark.ai/llms.txt