Quick Reference: Contact Import CSV

  • 2 minute(s) read
Prev Next

This guide provides a quick overview of how to format a CSV file for importing contacts into Mapp Engage.
For more detailed information, see CSV Format for Contact Imports.

Standard Attributes​

Header Field

Details (incl. Data Type)

user.Email

Must be a valid email address in the format localpart@domain.com. Data type: String

user.MobileNumber

Must include the area code. A plus sign (+) is optional. Do not include extra leading zeroes. Data type: String (digits, optional +)

user.FaxNumber

Stores the mobile app alias (formerly fax number). Accepts numbers, letters, and special characters (periods, underscores). No validation. Max 2000 characters. Data type: String

user.Identifier

External identifier (e.g., from a CRM). Accepts numbers, letters, and special characters (periods, underscores). No validation. Max 2000 characters. Data type: String

user.FirstName

Contact’s first name. No special formatting. Max 2000 characters. Data type: String

user.LastName

Contact’s last name. No special formatting. Max 2000 characters. Data type: String

user.Nickname

Contact’s preferred name. No special formatting. Max 2000 characters. Data type: String

user.PartnerId

Identifies the external source of the contact. Accepts up to 5 numeric characters. Data type: Number (max length = 5)

user.ZipCode

Postal code format depends on the country. Accepts letters and numbers. No validation. Max 2000 characters. Data type: String

user.ISOCountryCode

Must follow ISO 3166-1. Data type: String (2-letter or 3-letter code)

user.ISOLanguageCode

Must follow ISO 639-1. Data type: String (2-letter code)

user.TimeZone

Must follow IANA tz database. Example: America/New_York, Europe/Berlin. Data type: String

user.Title

Accepted values: 1 = Mr., 2 = Ms., -1 = Unknown. Data type: Number (enumeration)

user.DateOfBirth

Use ISO-8601: YYYY-MM-DD or YYYY-MM-DDThh:mm:ss±hh:mm. Example: 1965-08-08T12:00:00+00:00. Data type: DateTime (ISO-8601)

user.Gender

Accepted values: 0 = Unset, 1 = Male, 2 = Female, 3 = Undisclosed. Data type: Number (enumeration)

Date Formatting in Mapp Engage

  • Uses ISO-8601 date formats.

  • Format with time zones as:
    YYYY-MM-DDThh:mm:ss±hh:mm
    Example: 2024-12-25T15:15:15-05:00.

  • Deprecated formats are not fully supported.

Special Characters in Attribute Names

If attribute names include spaces or special characters, you have two options:

  • Use quotation marks:
    "user.CustomAttribute.My Attribute with a Space"
    "user.CustomAttribute.Astrology / Horoscope"

  • Use square bracket notation:
    user.CustomAttribute['My Attribute with a Space']
    user.CustomAttribute['Astrology / Horoscope']

Do not use:

  • Square bracket notation for standard attributes. For example, "user['Email']" will cause an error during import.

  • Function notation. For example, ${user['Email']} will cause an error during import.

Custom, Member, and Group Attributes​

Attribute Type

Header Format

Details

Custom Attributes

user.CustomAttribute.X

Replace X with the attribute name. Can be enumerated or not. Max 2000 characters.

Member Attributes

user.CampaignAttribute.X

Replace X with the attribute name. Cannot be enumerated.

Group Attributes

Headers must include: "group.PropertyName","group.PropertyValue". Rows contain name and value. Must be imported in a separate CSV file (not with contacts).

  • Custom and Member attributes are stored as String values (max 2000 characters).

  • Group attributes are also String values and cannot be enumerated.