How to delete duplicates from Merged Outlook contacts?

[trusty]

Hello,

We just bought a CRM software and until today, each salesman had his own contact list in Outlook. I retrieved, for each of them, XLS files from Outlook and I copy-pasted it in one file. Thing is, now I have hundreds and hundreds of duplicate records .

I would like to get rid of all the duplicates, how can I handle this easily?

[Talgru]

Hello!

I'd recommend you have a look at an ETL tool. It allows, among other things, to "clean up data" including deleting duplicate records. Also I know there are open source ETL tools, making it pretty easy to download.

[trusty]

I've been looking at those etl tools you talk about and would like to know which, among the open source etl tools, is the easiest to use? I'm asking because now I've seen what I can do with these tools, I'll use them on a regular basis (data integration?).

Once I've chosen the one I'm going to use, I will come back with more technical questions.

Thanks for your answers.