Bulk MySQL Data Cleansing

PHP, Data Processing, Excel, SQL, Software Architecture, MySQL, Data Cleansing, Data Management · I’m sitting on a backlog of well over 10,000 customer records—contact information, purchase history, and demographic details—that must be brought into a MySQL 8 database while being cleaned up along the way. The raw files contain plenty of duplicate rows, mixed-format fields, and out-of-date entries, so the job calls for more than a simple import script.

Here’s what I need done: • Import or migrate the source files (CSV/Excel) into MySQL without data loss • Remove all duplicate records at both row and field level • Update or flag outdated phone numbers, emails, and addresses using the reference lists I provide • Standardize naming conventions, date formats, phone masks, currency values, and any other inconsistent fields so the final dataset is uniform and query-ready • Supply change logs or before/after reports so I can audit your work

Acceptance criteria: the final MySQL tables load without errors, pass my spot-check queries for accuracy, and reflect a 100 % removal of obvious duplicates and mis-formatted values.

If you are comfortable writing SQL scripts or using tools like MySQL Workbench, phpMyAdmin, or Python/Pandas for batching, let’s get this cleaned up and runnin