From millions of scattered Excel records to a unified, queryable platform

The challenge

A real estate company in Spain had millions of records spread across decentralized Excel spreadsheets with no single source of truth. Data was inconsistent, duplicated, and impossible to query at scale.

Our solution

• Design and development of a custom backend with a NoSQL database
• ETL pipeline to extract, clean, deduplicate, and migrate millions of records from heterogeneous Excel sources
• Custom API layer for the platform to consume unified data
• Data validation and reconciliation process