I did an initial import of Contact data using Data Loader. One of the fields on the Contact is a lookup to an Account object (custom record type called School). I loaded my csv with corresponding Account Id for the contacts school. After I completed the import and i look at the contact record in Salesforce, it is showing the actual text of the Id in the lookup field instead of the school name. I'm baffled why it would do this. Screen Capture

  • can you put a picture of the lookup field and .csv file which you are uploading Commented May 21, 2017 at 18:34
  • is your field a lookup field in salesforce. If it is shohwing as text, possibly your field in salesforce is custom text field
    – sf_user
    Commented May 22, 2017 at 4:42

1 Answer 1


Just to close the circle on this, I'm going to admit I made a goof and set the field as Text(100) instead of Lookup, fully convinced it was a Lookup. Anyhow, I created a new Lookup field and it imported just fine. Problem solved.

You must log in to answer this question.

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