Answers.Body: <p>If you are using Multi-value Custom Data, see <a href="https://civicrm.stackexchange.com/questions/3957/how-to-import-to-multi-record-set-custom-fields/3971">How to import to multi-record set custom fields</a> and the answer.</p>
  
  <p>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:</p>
  
  <pre><code>First Name,Last Name,Language
  Joe,Smith,"English, Spanish"
  Frank,Jones,"Dutch, English"
  </code></pre>
  
  <p>Tip: Try exporting a couple of existing records (with similar data) to see what CiviCRM expects in the import.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-01T15:19:40.910Z
Answers.Text: Worked fine! Thank you for your idea to export existing records.
Answers.UserDisplayName: Vassilis Chryssos
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-02T00:03:31.430Z
Answers.Text: There is a difference between a field with multiple options, and a field that can have multiple records. Sanjay I think you might be confusing the two as the link is for the latter, while it sounds like the question is about the former - which i interpreted as requiring an answer like "ensure your languages are comma separated in a single cell" - maybe you can tweak your answer to match?
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-02T01:51:10.950Z
Answers.Text: Petednz, I was not confused between the two types, but your language change suggestion is helpful. Thanks - I edited my answer.
Answers.UserDisplayName: Sanjay Jain
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-01T13:34:13.163Z
Answers.LastActivityDate: 2016-03-02T01:57:52.797Z
Answers.LastEditDate: 2017-04-13T12:53:13.017Z
Answers.UserDisplayName: Sanjay Jain
Answers.Body: <p>You can import the multi value data. Format should like this below.<br/>
  ContactID   Language<br/>
  101     English<br/>
  101     German<br/>
  102     Spanish<br/>
  102     Greek<br/>
  102     English<br/></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-01T11:59:02.530Z
Answers.LastActivityDate: 2016-03-01T11:59:02.530Z
Answers.UserDisplayName: Prakash
Body: <p>I have a custom field for Individual contacts which can carry multiple values, i.e. 'Languages' can be 'English, German, Spanish, Greek'.</p>
  
  <p>An individual may speak 'English, German', another 'Spanish, Greek, English' and so on.</p>
  
  <p>How can I populate this field with multiple values when importing contacts?</p>
  
Tags: <custom-fields><import>
Title: Import multiple options in one field
ThreadText: # Import multiple options in one field
  
  (Asked by: username_0 on 2016-03-01)
  
  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?
  
  **Tags:** custom-fields, import
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2016-03-01. Score: 2
  
  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.
  
  > **Comments:**
  > **username_0**: Worked fine! Thank you for your idea to export existing records.  
  > **username_2**: There is a difference between a field with multiple options, and a field that can have multiple records. Sanjay I think you might be confusing the two as the link is for the latter, while it sounds like the question is about the former - which i interpreted as requiring an answer like "ensure your languages are comma separated in a single cell" - maybe you can tweak your answer to match?  
  > **username_1**: Petednz, I was not confused between the two types, but your language change suggestion is helpful. Thanks - I edited my answer.  
  
  ---
  
  ### Answer by username_3 on 2016-03-01. Score: 1
  
  You can import the multi value data. Format should like this below.  
  ContactID Language  
  101 English  
  101 German  
  102 Spanish  
  102 Greek  
  102 English
  
  
  ---
  
  