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
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.
You can use MAILCHIMP CIVICRM INTEGRATION extension to import contacts to civicrm based on mailchimp as wells as to mailchimp based on civicrm.