Deduplication of two sets of contacts

Question

One of our users has two sets of contacts in his email: 7000 or so from and old mail system, and even more in his current Apple Address Book. What we're trying to do is get the two sets of contacts into similar formats (.csv, .xls, whatever) and compare to look for duplicates. I suspect the larger set includes all of the entries from the smaller one, but I'd like to prove that with some kind of checking tool without scrolling through the list manually.

Can anyone recommend any tools to do something like this?

Answer 1

Not sure about Apple apps but if you can export both to xls and get them to a Windows installation then a program called Beyond Compare will do a comparison of the contents on a row by row basis

Answer 2

Gmail has an automatic duplicates detector. You could:

1. Set up a new account
2. Import both sets of contacts
3. Use the Gmail duplicates finder to delete and merge them
4. Export into a master contact list.

Your user would also get a bonus Gmail account out of it...

Answer 3

I ended up using an Excel add-in called DigDB. It allowed me to de-duplicate each of my sets individually, then compare/de-dupe, and consolidate the two sets into one. I've now got a unified set we're happy with.