Privacy-Safe Excel CRM Stabilization for a German Real Estate Firm
Developed by R. Paulo Delgado.
A fragile, conflict-prone Excel-based CRM was stabilized into a reliable multi-user operational system without introducing new infrastructure or privacy risk.
Client Context
The client was a long-term German customer relying on Excel as a de facto CRM for managing thousands of client and prospect records accumulated over many years.
The CRM consisted of a single shared Excel file used by multiple staff members, with no structure, governance, or concurrency control. Privacy considerations ruled out the use of cloud-based CRM platforms or third-party SaaS solutions.
The Problem
The existing Excel-based CRM had become operationally fragile and unreliable. Multiple users accessed the same file simultaneously, resulting in conflicting versions, duplicated records, and frequent data loss. Coordination depended on verbal agreements, which routinely failed. Preparing clean, segmented data for business-critical activities required extensive manual effort.
Key challenges included:
Multi-user file conflicts
Simultaneous access to a shared Excel file caused conflicting copies, overwritten data, and loss of trust in the system.
Unstructured and duplicated data
Thousands of records existed without normalization, leading to duplicates, inconsistent fields, and unreliable filtering.
Manual, error-prone campaign preparation
A major annual physical mail campaign required extensive manual preparation and filtering.
Strict privacy constraints
German data protection expectations limited acceptable solution paths and excluded external or cloud-based CRM platforms.
The core issue was not feature scarcity, but the lack of reliability and data integrity in a system the business already depended on.
The Solution
The solution focused on preserving Excel as the user interface while eliminating its failure modes through structured data storage and controlled access patterns.
The solution addressed several architectural focus areas:
- 1
Data cleanup and consolidation
The original Excel data was cleaned, deduplicated, and normalized to establish a consistent and trustworthy dataset.
- 2
Structured data storage
All records were migrated into a local SQLite database to act as a single source of truth.
- 3
Excel-based application interface
Custom VBA-based UI components were added to Excel, giving users a controlled, desktop-application-like experience.
- 4
Atomic operations and reliability
All read and write operations were executed against the database, eliminating file-level conflicts and ensuring data integrity.
- 5
Campaign tooling
The system was extended to generate clean, mail-merge–ready Excel exports and support explicit tagging of campaign recipients.
Architecture & Technology
Data Layer
- SQLite database as a single source of truth
- Normalized schema derived from legacy Excel data
- Atomic read/write operations
Application Layer
- Excel retained as the primary user interface
- Custom VBA-driven UI components
- Controlled interaction between Excel and the database
Reliability & Integrity
- Elimination of shared-file editing
- Deterministic data access patterns
- Removal of manual coordination between users
Privacy & Compliance
- No external services introduced
- All data retained within the client's local environment
- Architecture aligned with conservative German privacy expectations
Execution & Delivery
The engagement was executed as a focused stabilization effort with clear operational objectives.
Key characteristics of delivery:
- Worked within strict privacy and environmental constraints
- Improved reliability without replacing existing tools
- Delivered a pragmatic architecture aligned with real user workflows
- Focused on operational outcomes rather than feature expansion
The project prioritized stability and trust in a core internal tool over unnecessary system replacement.
Outcomes & Impact
- Eliminated multi-user file conflicts
- Established a clean and consolidated CRM dataset
- Enabled reliable sorting, filtering, and segmentation of records
- Significantly reduced manual effort for the annual physical mail campaign
- Produced mail-merge–ready exports on demand
- Restored confidence in a business-critical internal system
A small, targeted intervention removed a recurring operational burden and stabilized a system the business relied on daily.
Why This Project Matters
This project demonstrates the ability to:
- Stabilize critical systems without introducing unnecessary complexity
- Deliver reliable solutions under strict privacy constraints
- Improve legacy Excel-based workflows with sound architectural judgment
- Focus on operational impact rather than system size
- Act as a trusted long-term technical partner
Project Tags
- Germany
- Excel
- Excel VBA
- Privacy
- CRM
- Real Estate