Skip to end of metadata
Go to start of metadata
CiviCRM Documentation

This page refers to outdated version of CiviCRM. Check current version of documentation.

What fields can I import?

CiviCRM import fields, extracted from the contact entry forms. Note: locations can be repeated several times, as can phone, email, IM, tags, groups and custom fields. (see a separate FAQ on importing tags and groups ).

Set on entry: Individual / Organisation / Household and duplication checking method

Civi FieldName Value
Name & greeting : Prefix (list)
Name & greeting : FirstName
Name & greeting : MiddleName
Name & greeting : LastName
Name & greeting : Suffix (list)
Name & greeting : JobTitle
Name & greeting : Greeting (Dear \[first\],)
Name & greeting : NickName
Name & greeting : Website (http:// . . .)

CommsPrefs : Privacy:No phone (boolean)
CommsPrefs : Privacy:No email (boolean)
CommsPrefs : Privacy:No mail (boolean)
CommsPrefs : Privacy:No trade (boolean)
CommsPrefs : Prefers
CommsPrefs : MailFormat

Location : Home/work
Location : Primary (boolean)
Location : LocationName
Location : Phone:preferred type
Location : Phone:preferred number
Location : Phone:other (mobile)
Location : Phone:other (mobile) number
Location : Phone:other (fax)
Location : Phone:other (fax) number
Location : Phone:other (pager)
Location : Phone:other (pager) number
Location : Email:preferred (validated)
Location : Email:other (validated)
Location : IM:preferred
Location : IM:other
Location : Address:Street address
Location : Address:addit'l 1
Location : Address:addit'l 2
Location : Address:city
Location : Address:County 
Location : Address:zip  
Location : Address:country
Location : Address:Lat+Long

Location 2 : Home/work
Location 2 : Primary (boolean)
Location 2 : LocationName
Location 2 : Phone:preferred
Location 2 : Phone:preferred number
Location 2 : Phone:other x
Location 2 : Phone:other x
Location 2 : Email:preferred
Location 2 : Email:other x
Location 2 : IM:preferred
Location 2 : IM:other x
Location 2 : Address:Street address
Location 2 : Address:addit'l 1
Location 2 : Address:addit'l 2
Location 2 : Address:city
Location 2 : Address:County
Location 2 : Address:zip
Location 2 : Address:country
Location 2 : Address:Lat+Long

Demographics : Gender (list)
Demographics : Date of birth

Contact Notes :

Tag : aaa
Tag : bbb
Tag : ccc
. . .

Group : xxx
Group : yyy
Group : zzz
. . .

Custom field : 111
Custom field : 222
Custom field : 333
. . .
Labels
  • None

Creative Commons License
Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-Share Alike 3.0 United States Licence.