CRM Company Data Cleanup and Deduplication by Sam ZeninCRM Company Data Cleanup and Deduplication by Sam Zenin

CRM Company Data Cleanup and Deduplication

Portfolio project
Sam Zenin
Sales and ERP exports can describe the same organisation differently. I used the confirmed company registry key to match records, standardized company and contact fields, and kept the input identifiers for every record. The workbook uses fictional company names and reserved contact details.

Conflicts and missing identifiers

The review queue records missing keys, missing required fields and differing email values. The crosswalk shows the disposition of all 600 source rows, including 14 held source rows. A reviewer can locate each original record and identify exactly which decision remains open.

Handoff to the CRM

The release contains 471 distinct company records for import. The Excel workbook includes the original exports, crosswalk, review queue and control totals. A separate CSV carries the fields selected for import.
Source-ID crosswalk and the review queue used to resolve registry and contact conflicts.
Source-ID crosswalk and the review queue used to resolve registry and contact conflicts.

0 likes · 0 views · Nov 17, 2026

Matched 600 records from two exports on confirmed company keys. Delivered 471 import-ready CRM company records and source traceability for every input.

Tags