Export contact info from MailChimp
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.