Answers.Body: <p>Your file seems to be a valid csv file with a comma separator. It should be readable by CiviCRM but you have to ensure you tell CiviCRM about :</p>
  
  <ol>
  <li>the separator, see the field "Import Field Separator" in the Contact Import page or change it globally in <code>Administration -&gt; Settings -&gt; Languages, Currency, Location</code> or <code>civicrm/admin/setting/localization?reset=1</code></li>
  <li>the encoding if it's not UTF-8, see the page <code>Administration -&gt; Settings -&gt; Languages, Currency, Location</code> or <code>civicrm/admin/setting/localization?reset=1</code></li>
  </ol>
  
  <p>If you want to read and edit this file using a Spreadsheet, you can follow Heather O. suggestion for MsExcel or use LibreOffice/OpenOffice which should be able to autodetect the csv file configuration.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-20T15:32:53.233Z
Answers.LastActivityDate: 2015-10-20T15:32:53.233Z
Answers.UserDisplayName: samuelsov
Answers.Body: <p>If you are working with Microsoft Excel 2000 or later, you can use the following steps. </p>
  
  <p>Select the "Data" tab. You should see an option that say "Text to columns". Highlight your column and choose that. A little window should pop up to walk you though, but you'll want to choose "Delimited" (next) and that your separator is a comma. When you click finish, this will put the data between each comma into a new cell.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-20T09:39:30.207Z
Answers.Text: You forgot to add the program name (Microsoft Excel 2000 or later). Not everyone use Excel and some may use only text editor (e.g. Notepad++), which this answer doesn't apply.
Answers.UserDisplayName: Andrew T.
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-20T09:15:05.867Z
Answers.LastActivityDate: 2015-10-20T14:20:00.920Z
Answers.LastEditDate: 2015-10-20T14:20:00.920Z
Answers.UserDisplayName: Heather O.
Body: <p>I just tried to export all my contact info from MailChimp. Basically, it worked and I am now the happy owner of a pretty CSV file... but all the data is saved in only one column, one row per contact.</p>
  
  <p>For example, my data is stored as</p>
  
  <pre><code>axel.grunt@zukunft-statt-autobahn.at,Axel,Grunt,"Lieber Herr Grunt",,J,J,J,,,"Zukunft statt Autobahn",,,,"Deciders only, Deciders auch","progressive GroÃŸspenderInnen",Newslettertest,,,html,5,,,"2012-09-13 19:32:42",184.173.181.254,48.2092000,16.3728000,1,2,Europe/Budapest,AT,9,"2013-10-28 08:14:49",26171677,963968a07a,
  </code></pre>
  
  <p>When I want to import the data on CiviCRM, it can't read the data but thinks it would be a terrifying misspelled email address.</p>
  
  <p>Any solution?</p>
  
Tags: <export>
Title: Export contact info from MailChimp
ThreadText: # Export contact info from MailChimp
  
  (Asked by: username_0 on 2015-10-20)
  
  I just tried to export all my contact info from MailChimp. Basically, it worked and I am now the happy owner of a pretty CSV file... but all the data is saved in only one column, one row per contact.
  
  For example, my data is stored as
  
  ```
  username_0.username_0@zukunft-statt-autobahn.at,username_0,username_0,"Lieber Herr username_0",,J,J,J,,,"Zukunft statt Autobahn",,,,"Deciders only, Deciders auch","progressive GroÃŸspenderInnen",Newslettertest,,,html,5,,,"2012-09-13 19:32:42",184.173.181.254,48.2092000,16.3728000,1,2,Europe/Budapest,AT,9,"2013-10-28 08:14:49",26171677,963968a07a,
  
  ```
  
  When I want to import the data on CiviCRM, it can't read the data but thinks it would be a terrifying misspelled email address.
  
  Any solution?
  
  **Tags:** export
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2015-10-20. Score: 1
  
  Your file seems to be a valid csv file with a comma separator. It should be readable by CiviCRM but you have to ensure you tell CiviCRM about :
  
  1. the separator, see the field "Import Field Separator" in the Contact Import page or change it globally in `Administration -> Settings -> Languages, Currency, Location` or `civicrm/admin/setting/localization?reset=1`
  2. the encoding if it's not UTF-8, see the page `Administration -> Settings -> Languages, Currency, Location` or `civicrm/admin/setting/localization?reset=1`
  
  If you want to read and edit this file using a Spreadsheet, you can follow username_2 O. suggestion for MsExcel or use LibreOffice/OpenOffice which should be able to autodetect the csv file configuration.
  
  
  ---
  
  ### Answer by username_2 on 2015-10-20. Score: 1
  
  If you are working with Microsoft Excel 2000 or later, you can use the following steps.
  
  Select the "Data" tab. You should see an option that say "Text to columns". Highlight your column and choose that. A little window should pop up to walk you though, but you'll want to choose "Delimited" (next) and that your separator is a comma. When you click finish, this will put the data between each comma into a new cell.
  
  > **Comments:**
  > **username_3**: You forgot to add the program name (Microsoft Excel 2000 or later). Not everyone use Excel and some may use only text editor (e.g. Notepad++), which this answer doesn't apply.  
  
  ---
  
  