Skip to main content
Topics#Salesforce DeveloperLionel Kamdem's Question
Lionel Kamdem (*****) asked in #Salesforce Developer
Sep 27, 2018, 1:45 PM

comparing excel csv contact list with salesforce contacts

Hi 

I have an excel spread sheet of about 100 names. I want to compare these 100 names with the contacts we already have in salesforce to see how many are in our database. 

I know with dataloader/import wizard you can import, export, update, and delete but I'm not sure how you would go about comparing your own list against your database in salesforce.

Thank you. 
2 answers
  1. Khan Anas Rehmani (Salesforce)
    Sep 27, 2018, 2:01 PM
    Hi Lionel,

    I trust you are doing very well.

    You can do that by exporting all the names from object say contact in a CSV. Once you export you could copy paste the existing data in an excel sheet to this file in a new sheet and compare.

    You can refer the below link for information on comparing data in excel.

    http://www.wikihow.com/Compare-Data-in-Excel

    I hope it helps you.

    Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future.

    Thanks and Regards,

    Khan Anas
Write an answer...
0/9000