Data
Merge contact lists
Two overlapping exports into one clean list, with the conflicts resolved visibly.
Fill it in
The exports to combine.
What makes two rows the same person.
Which value wins.
Your prompt
Merge the lists in . Match on [your match on]. When fields disagree: The more complete one. Normalise before matching. Case, whitespace, plus-addressing and a trailing dot are why two records of the same person do not match, and a dedupe that misses them produces a list that looks clean and mails people twice. NEVER silently pick a winner on a conflicting field. Report every conflict you resolved and how, and keep the discarded value in a column. A merged CRM where somebody's job title quietly reverted to a two-year-old value is nearly impossible to notice and impossible to undo. Deliver the merged list, a sheet of the conflicts, and a count: in, matched, merged, out.
Continue and pick your folderOpens with everything above already filled in.
Why this works
A dedupe that misses case, whitespace and plus-addressing produces a list that looks clean and mails people twice. Worse, a silent conflict resolution can revert someone's job title to a two-year-old value invisibly. This reports every conflict and keeps the discarded value.
Questions
- How many lists?
- As many as you put in the folder.