Forum Discussion

Mike Redshaw's avatar
Mike Redshaw
Copper Contributor
Mar 04, 2020

Excel Syntax errors

I want to import a small .csv database into Mail chimp but it is rejected because of Syntax errors. How do I check for Syntax errors in Exel please?

 

Thanks

 

office 365
security

2 Replies

  • LudProfesor's avatar
    LudProfesor
    Copper Contributor
    Mar 04, 2020
    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.

Resources