I have excel sheet with the lookup name than id and value

ID - value

1 xxx

2 yyy

object 1

LookupId - 1 value = 2

My excel sheet data upload format is

value - value

xxx 2

will it take the lookup id automatically while upload using data import ? is it possible ?

  • 1
    The data import wizard does allow matching lookups based on names rather than Id, you just have to be consistent in the data in the import file so you can't mix names and Salesforce Ids.
    – Dave Humm
    Commented Jan 31, 2017 at 14:08

1 Answer 1


Yes it is possible for the data import wizard to match on names in Lookup fields, you will get the option to select which of them you are using when you select the object that you are loading.

enter image description here

Tipsheet link

Choosing which tool


You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .