Customer Data Cleaning & Validation

I have several Excel spreadsheets containing raw customer information that now need to be turned into a single, reliable data set. Your task is to go through the files, eliminate duplicates, fix obvious entry errors, standardise formats (names, phone numbers, email addresses, dates), and flag anything that looks inconsistent or suspicious. I will provide the spreadsheets plus a short style guide so you know exactly how each field should look when it is “clean”.

You’re free to use any solid Excel-based method—formulas, Power Query, VBA, even third-party tools—so long as the end result meets the guidelines and can be inspected easily inside Excel.

Deliverables
• A cleaned master worksheet with all customer records consolidated and validated
• A concise change log (or column comments) noting issues found and the actions you took
• A brief summary of any records that still need manual confirmation

Once I spot-check the file and everything matches the agreed rules, the project is complete. Let me know your estimated turnaround and any questions you have about the data or validation rules.