We suggest starting with "How to Import Contacts into Tern" if you haven't already read it.
The following table includes the fields that are supported by the core import. Only a few of these fields are required. Note that in future updates additional imports will be possible to add additional phone numbers, emails, relationships, and loyalty programs.
Field Name | Required | Can map multiple columns into this field? | Description |
Import ID | No | No | The unique identifier to use to look up the contact. This can be used to override the email lookup. Useful when multiple contacts might share an email or when multiple contacts without an email share a name. |
Prefix | No | No | (Mr/Mrs/etc) |
Legal First Name | Yes | No | The first name of the contact |
Middle Name | No | No | The middle name of the contact |
Last Name | Yes | No | The last name of the contact |
Suffix | No | No | (e.g. Jr. Esq, etc). |
Preferred First Name | No | No | The name the contact goes by (e.g. Jim for James). |
Birthday | No | No | The birthday of the contact. |
Wedding Anniversary | No | No | The anniversary of the contact. |
Job Title | No | No | The job title of the contact. |
Gender | No | No | The gender of the contact. |
Contact Type | No | No | Supplier, traveler, etc. |
Primary Email Address | No | No | The primary email of the contact. |
Primary Email Address Description | No | No | A note about the primary email. |
Secondary Email Address | No | No | The secondary email of the contact. |
Secondary Email Address Description | No | No | A tag associated with the secondary email. |
Primary Phone | No | No | The primary phone of the contact. Note that Tern only supports one phone number in the core import at this time. |
Address Line 1 | No | No | First line of the primary address. |
Address Line 2 | No | No | Second line of the primary address. |
Address Country | No | No | Primary address country |
Address City | No | No | Primary address city |
Address State | No | No | Primary address state |
Address Zip Code | No | No | Primary address zipcode |
Known Traveler Number / PASS ID | No | No | Global Entry / TSA Precheck known traveler number. |
Known Traveler Number / PASS ID Expiration Date | No | No | Expiration date of the known traveler number (e.g. when their global entry expires). |
Redress Number | No | No | The redress number of the contact. |
Redress Number Expiration Date | No | No | |
Passport Number | No | No | Passport number of the client. |
Passport Country of Issue | No | No | Country of issue |
Passport Date of Issue | No | No | Date of issue of the passport |
Passport Date of Expiration | No | No | When the passport will expire |
Passport Given Names | No | No | The first name of the contact as it appears on the passport. |
Passport Surname | No | No | The last name of the contact as it appears on the passport |
Passport Gender | No | No | The gender of the contact as it shows up on the passport. |
Passport Place of Birth | No | No | The location the contact was born per their passport. |
Passport Nationality | No | No | |
Food, Drink & Allergy Preferences | No | Yes | A semi-colon seperated list of food and drink preferences. Use with caution as this data can be messy when imported. |
Activities & Interests Preferences | No | Yes | A semi-colon seperated list of activity preferences. Use with caution as this data can be messy when imported. |
Tag List | No | Yes | A list of tags separated by semicolons that will appear on the contact profile. |