Excel Syntax errors

%3CLINGO-SUB%20id%3D%22lingo-sub-1208703%22%20slang%3D%22en-US%22%3EExcel%20Syntax%20errors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1208703%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20import%20a%20small%20.csv%20database%20into%20Mail%20chimp%20but%20it%20is%20rejected%20because%20of%20Syntax%20errors.%20How%20do%20I%20check%20for%20Syntax%20errors%20in%20Exel%20please%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1208703%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESecurity%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1208833%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Syntax%20errors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1208833%22%20slang%3D%22en-US%22%3EFrom%20your%20explanation%2C%20there%20is%20no%20error%20in%20Excel%20itself.%20The%20problem%20is%20that%20the%20.csv%20file%20is%20not%20properly%20formatted%20to%20be%20digested%20from%20(imported%20into)%20Mail%20Chimp.%3CBR%20%2F%3EThe%20problems%20could%20be%20tons%3A%20from%20improper%20value%20formats%2C%20to%20incorrect%20delimiter.%3CBR%20%2F%3E%3CBR%20%2F%3EAt%20this%20point%20-%20I%20would%20refer%20to%20Mail%20Chimp%20community%2C%20as%20this%20is%20problem%20in%20preparing%20for%20import%20in%20their%20software.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

 

2 Replies
Highlighted
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.
Highlighted

Thanks