Excel Customer Data Cleanup & Deduplication

My customer list lives in a single Excel workbook and it needs a proper scrub before import into our CRM. The file contains a mix of new and legacy records; my priority is to remove every duplicate while keeping the original formatting intact and ensuring no valid entry is lost.

You’ll work directly in Microsoft Excel—Power Query, advanced filtering, or any reliable technique is fine—as long as the final sheet is spotless and ready for upload.

Deliverables
• A cleaned Excel file with all duplicate customer records removed
• A short summary sheet noting how many duplicates were identified and deleted, plus any edge cases you spotted

If you can start right away and finish quickly without sacrificing accuracy, let’s get this done.