New portfolio project: Data Importer & Cleaner v1.0.1
Messy spreadsheets are easy to clean.
Cleaning them safely, reproducibly and without losing track of what changed is the harder problem.
I built a Windows desktop application that turns inconsistent CSV and Excel files into validated, cleaned and reusable datasets through a complete reviewable workflow:
Import ā Profile ā Map ā Validate ā Clean ā Deduplicate ā Review ā Export
Built with C#, .NET 10, WPF, EF Core and SQLite.
Engineering highlights:
ā immutable source data
ā before/after transformation evidence
ā separate validation and cleaning engines
ā deterministic duplicate detection
ā CSV, XLSX and SQLite export
ā 63 automated tests
ā zero-warning Release build
ā 50,000-row pipeline completed in 2.853 seconds
ā CI, coverage gates and automated release verification
The complete project, documentation and Windows release are available on GitHub:
https://github.com/Staniek-Tech-NL/data-importer-cleaner
#dotnet #csharp #wpf #dataprocessing #softwareengineering