How to import into a lookup relationship custom field

Similar to linking, you can use the lookup relationship custom field to relate records to other records. The object type you are relating to determines the format for the lookup field in your import file. Standard objects, such as contacts, projects, and opportunities, need a specific format to import the data. 

To import standard object information into a lookup field:

  1. Prepare your import file.
  2. Create a column in your import file for the lookup relationship custom field. 
  3. Enter the following format for the standard records: record ID; record Name. Don't put any spaces between the record ID number and record name. For example, let's say we have a contact named Sansa Stark, and the record ID number is 275104122.
    2018-12-18_13h25_06.png
  4. Import the data into your account. 

If you need to relate a record to a custom object record, it depends on the field type for the custom object's record name. Custom object records that use a text field for the field name need to use the record id; record name format. If the field type is auto number, then you only need the record ID in the import file. 

To check which format you're using for the record name on the custom object, go to the Object Details page. The edit page shows what field type is used for the record name.

 To import an auto number custom object record into a lookup field: 

  1. Prepare your import file.
  2. Create a column on your import file for the lookup relationship custom field. 
  3. Enter the following format for your auto number records: record ID. 
  4. Import the data into your account. 
Have more questions? Submit a request
Top