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
firstname.lastname@example.org,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",18.104.22.168,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.