From your explanation, there is no error in Excel itself. The problem is that the .csv file is not properly formatted to be digested from (imported into) Mail Chimp. The problems could be tons: from improper value formats, to incorrect delimiter.
At this point - I would refer to Mail Chimp community, as this is problem in preparing for import in their software.