Apex Code Development You need to sign in to do that
Don't have an account?
Lionel Kamdem 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.
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.
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
All Answers
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