Skip to main content

In excel/CSV sheet can we give Name value for Lookup field

For example - When loading bulk data for contact field we give account lookup

Like we have XYZ as account name. so can I write in csv file 'AccountID.Name' and value as XYZ.

I tried like this but getting issue, we can do via ID but it changes based on Org. so can I created one csv which I can use in Dev, QA, UAT and so on...

 

Please guide

 

#Salesforce Developer

1 answer
  1. May 1, 2024, 9:41 PM

    @Priti Gohil you will need to use the Account ID to which the Contact is associated. Make note of whether you are using the 15-character or 18-character ID as the 18-character ID is case-insensitive, and the 15-character ID is case-sensitive. 

0/9000