Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question

3 Answers 3

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

share|improve this answer

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...

share|improve this answer
up vote 0 down vote accepted

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.