CiviCRM Stack Exchange is a question and answer site for administrators and users of the CiviCRM Constituent Relationship Management software. It only takes a minute to sign up.
Sign up to join this community
I have a custom field for Individual contacts which can carry multiple values, i.e. 'Languages' can be 'English, German, Spanish, Greek'.
An individual may speak 'English, German', another 'Spanish, Greek, English' and so on.
How can I populate this field with multiple values when importing contacts?
If you are using Multi-value Custom Data, see How to import to multi-record set custom fields and the answer.
But it sounds like you are importing multiple options in a field, in which case you can use comma separated values in a single cell. The import file will look something like this:
First Name,Last Name,Language
Joe,Smith,"English, Spanish"
Frank,Jones,"Dutch, English"
Tip: Try exporting a couple of existing records (with similar data) to see what CiviCRM expects in the import.
You can import the multi value data. Format should like this below.
ContactID Language
101 English
101 German
102 Spanish
102 Greek
102 English
