You need to sign in to do that
Don't have an account?
Jenna Hildebrand
Checking List Against Records in Salesforce
Hi there,
What is the best way to check a list—like an excel spreadsheet—against existing records in Salesforce? This seems like a super basic question, so I might be missing an obvious solution. I've been given a spreadsheet of 3,000+ leads that our Marketing department will take action on. However, they first want to know if any of these leads in the spreadsheet already exist in Salesforce as leads or contacts.
If the list is small, I can pull a report matching by email address or something like that. However, with thousands of leads needing to be checked, that process is less feasible. I'd really appreciate any advice you can offer!
Thanks!
What is the best way to check a list—like an excel spreadsheet—against existing records in Salesforce? This seems like a super basic question, so I might be missing an obvious solution. I've been given a spreadsheet of 3,000+ leads that our Marketing department will take action on. However, they first want to know if any of these leads in the spreadsheet already exist in Salesforce as leads or contacts.
If the list is small, I can pull a report matching by email address or something like that. However, with thousands of leads needing to be checked, that process is less feasible. I'd really appreciate any advice you can offer!
Thanks!
A trick could be:
- Create a csv file with two columns: email , mkt_dept__c
- Create the new custom fields: mkt_dept into Lead and Contact
- Upsert your file with the data import wizard or the dataloader using the email as a standard external Id
- Create a report filtering on mkt_dept is not null
- Delete the fields mkt_dep now useless
That could be sufficientThe second advantage is that the Excel export of the result of a report is not restricted for the number of rows.