Excel Customer Data Cleaning Automation

I have several large customer-data workbooks that need to be cleaned, de-duplicated, and consistently formatted so they are ready for analysis and reporting. The raw files arrive from different sources and use mixed layouts, naming conventions, and date/number formats, which slows the entire reporting cycle. Here’s what I need: • An Excel-based routine (VBA macro or Power Query workflow—whatever is fastest and most stable) that imports each raw file, standardises column headers, enforces data validation rules, removes duplicates, fixes common entry errors, and outputs a tidy, uniformly formatted table. • Built-in logic that applies advanced formulas where appropriate—think XLOOKUP or INDEX-MATCH for look-ups, COUNTIFS/SUMIFS for basic checks—and flags any records that still need manual review. • A brief set of usage notes inside the workbook so my team can refresh the process with one click when new customer dumps arrive. Acceptance criteria: 1. Pressing a single button (or refreshing a query) transforms the sample raw sheets I provide into a clean master sheet with no validation errors. 2. Processing time stays reasonable (<30 seconds on a 50k-row file on a standard office laptop). 3. No broken links, hidden hard-coded ranges, or externally referenced paths remain in the finished file. If you are comfortable automating repetitive Excel tasks, optimising code for speed, and documenting your solution clearly, I’d love to see examples of similar data-cleanup work you’ve done and discuss the hand-off timeline.

Project ID: 40537120