No duplicate entries when uploading contact list in SugarCRM

Question

I have an excel file that I upload to append my contact list in SugarCRM. I would like for if a name the excel file is already present in the database, this particular entry is not appended. Is this possible?

Answer 1

i think the easiest way for this is to:

1) export your current contact list to CSV

2) add it as a new in sheet in your current excel file

3) cross-reference which rows have are present between both (use 'vlookup' or 'match' on whatever criteria you use to determine duplicates)

4) filter the results so non-duplicates are shown, and save that as the a new CSV file

5) import the new csv-file via sugarcrm UI

hope this helps