All Collections
Importing Contact Data Into Tern
What fields are supported in the core import
What fields are supported in the core import

This article outlines the fields that are supported by the core contact import.

David Shull avatar
Written by David Shull
Updated over a week ago

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.

Did this answer your question?