Thank you for reaching out to the Constant Contact Community. It's my pleasure to assist you today.
I'm sorry you are having trouble uploading your .csv file. You might try it as an xlsx or Excel workbook file, this will often correct the problem. You may also email us the file at social_support(at)constantcontact(dot)com, be sure to include your username, a reference to this post and the file you are trying to import.
Thank you for choosing Constant Contact. Have a great day!
Thanks for getting back to us, Adrienne. Our system is designed to generate a csv file from the site's database. We add hundreds of customer emails every week and we're trying to get this to work without involving third party software like Excel or Google Sheets.
When we upload our csv file into Google sheets and then download it from there as an .xlsx file, it works. When we do the same thing and download it as a csv file (that is, we upload our .csv file and download Google's .csv file) it doesn't work. We get the same message telling us to upload it in a supported file format and not an error. It seems a lot like csv and txt support is wonky right now.
Thank you for getting back to us!
In this case I think it would be best if we could take a look at the actual file that you are trying to upload to troubleshoot what the problem may be. Please email that CSV file to social_support(at)constantcontact(dot)com Please include a mention of this post and your Constant Contact username on that email as well. At that time we'll take a look and see what may be preventing you from uploading that file.
Thank you for using Constant Contact, have a great day!
A minor update for anyone curious.
The error message is misleading and seems to occur when there is some sort of illegitimate character in a contact's information. I haven't been able to find such a character, but you can get around the issue by selecting "type in or paste contacts" in the options panel and then selecting the "paste names & emails" tab. Just copy the contacts and pasting into the box that appears and it should work, even if there is an illegitimate email address or two in there.
Thanks for updating us on that! Glad to hear that you have it working for you. Another thing that may be worth a try if you are still wanting to figure out what is going on with that CSV is to try removing any sort of background formatting by saving it as a different spreadsheet type in your program of choice and then reverting it back to a basic CSV. I have personally seen a few files with hidden bits of unicode hidden in them.