Answers.Body: <p>I think if you are doing a one off transfer of what is a relatively small set of contacts then an export from MailChimp and then import to CiviCRM is easiest option. Depends on what fields you have in MailChimp (is it more than name and email?) I'd just export everything from MailChimp and then you can set which fields you want to import and where to map them in the CiviCRM contact import. If you need to do any adjustment, then I find Excel the easiest place to do this.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-05T22:47:42.867Z
Answers.LastActivityDate: 2018-08-05T22:47:42.867Z
Answers.UserDisplayName: Mick Kahn
Answers.Body: <p>There is a mailchimp extension which you could install in CiviCRM and which then connects to your mailchimp and imports the contacts from mailchimp into CiviCRM.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-05-03T15:18:29.643Z
Answers.Text: Thank you! I don't have much of an idea of how to install an extension. Is it quite easy to do and not a big job, or would it be something I should ask our technician for support with?
Answers.UserDisplayName: grace
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-05-03T20:33:45.667Z
Answers.Text: Installing an extension is not that diificult. Some extensions could be installed from within CiviCRM it self. Others you have to upload to the right folder and could then be installed. 
  See the documentation on how to do so: https://docs.civicrm.org/sysadmin/en/latest/customize/extensions/
  If that sounds too techie I would recommand ask your technician.
Answers.UserDisplayName: Jaap Jansma - CiviCooP
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-05-03T15:14:43.107Z
Answers.LastActivityDate: 2018-05-03T15:14:43.107Z
Answers.UserDisplayName: Jaap Jansma - CiviCooP
Answers.Body: <p>To just answer the simple version of the question - you can use the Import Wizard at Contacts > Import Contacts which is also at this path civicrm/import/contact?reset=1</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-07T22:36:29.973Z
Answers.LastActivityDate: 2018-08-07T22:36:29.973Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>You can use <a href="https://civicrm.org/extensions/mailchimp-civicrm-integration" rel="nofollow noreferrer">MAILCHIMP CIVICRM INTEGRATION</a> extension to import contacts to civicrm based on mailchimp as wells as to mailchimp based on civicrm.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-06-05T19:38:08.020Z
Answers.LastActivityDate: 2018-06-05T19:38:08.020Z
Answers.UserDisplayName: Hassan Farooq
Body: <p>I am looking to import a list of 185 contacts from MailChimp to our database and wanted to know how I can do this in one go. As far as I know I have to export the list from Mail Chimp and then edit the fields in an excel document, but how to I make sure the fields will match with those in CiviCRM?  Does anyone have or know where there is a template of what needs to be on the spreadsheet?
  Are there any guides to how to layout the columns to refer to the fields I want to mark in Civi, also can I stop it importing duplicate contacts?
  Thank you!
  Grace </p>
  
Tags: <import>
Title: How can I import a list of contacts from MailChimp to the database all at once?
ThreadText: # How can I import a list of contacts from MailChimp to the database all at once?
  
  (Asked by: username_0 on 2018-05-03)
  
  I am looking to import a list of 185 contacts from MailChimp to our database and wanted to know how I can do this in one go. As far as I know I have to export the list from Mail Chimp and then edit the fields in an excel document, but how to I make sure the fields will match with those in CiviCRM? Does anyone have or know where there is a template of what needs to be on the spreadsheet?
  Are there any guides to how to layout the columns to refer to the fields I want to mark in Civi, also can I stop it importing duplicate contacts?
  Thank you!
  Grace
  
  **Tags:** import
  
  
  ---
  
  ## 4 answers
  
  ### Answer by username_1 on 2018-08-05. Score: 1
  
  I think if you are doing a one off transfer of what is a relatively small set of contacts then an export from MailChimp and then import to CiviCRM is easiest option. Depends on what fields you have in MailChimp (is it more than name and email?) I'd just export everything from MailChimp and then you can set which fields you want to import and where to map them in the CiviCRM contact import. If you need to do any adjustment, then I find Excel the easiest place to do this.
  
  
  ---
  
  ### Answer by username_2 on 2018-05-03. Score: 1
  
  There is a mailchimp extension which you could install in CiviCRM and which then connects to your mailchimp and imports the contacts from mailchimp into CiviCRM.
  
  > **Comments:**
  > **username_0**: Thank you! I don't have much of an idea of how to install an extension. Is it quite easy to do and not a big job, or would it be something I should ask our technician for support with?  
  > **username_2**: Installing an extension is not that diificult. Some extensions could be installed from within CiviCRM it self. Others you have to upload to the right folder and could then be installed.  See the documentation on how to do so: https://docs.civicrm.org/sysadmin/en/latest/customize/extensions/ If that sounds too techie I would recommand ask your technician.  
  
  ---
  
  ### Answer by username_3 on 2018-08-07. Score: 0
  
  To just answer the simple version of the question - you can use the Import Wizard at Contacts > Import Contacts which is also at this path civicrm/import/contact?reset=1
  
  
  ---
  
  ### Answer by username_4 on 2018-06-05. Score: 0
  
  You can use [MAILCHIMP CIVICRM INTEGRATION](https://civicrm.org/extensions/mailchimp-civicrm-integration) extension to import contacts to civicrm based on mailchimp as wells as to mailchimp based on civicrm.
  
  
  ---
  
  