This documentation relates to CiviCRM version 3.1. It's not maintained anymore.
Current version of documentation.

Import Fields

Skip to end of metadata
Go to start of metadata

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


Documentation Search


CiviCRM 3.1 Documentation

Support and Participation

Developer Resources


CiviCRM book!

Make sure to check out Understanding CiviCRM as well! You can also support this project by ordering a hard copy.

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.