cancel
Showing results for 
Search instead for 
Did you mean: 
Constant Contact wants to help you succeed! We’re celebrating our professional service programs on the Constant Contact Community this week and you have a chance to try one of the services for free! Learn more.

Cannot upload customer contact file

Occasional Participant

Cannot upload customer contact file

I am attempting to upload a .csv file with contact information but am getting an error that the file needs to be a csv, xls, or txt file. But it is a csv file. I even tried doing a txt file and it's not work. This looks like an error that needs to be fixed.
5 REPLIES 5
CTCT Employee

Re: Cannot upload customer contact file

Hi @KyleM961

 

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!


Adrienne B.
Community & Social Media Support

If you find my post helpful, and it answers your question, please mark it as an "Accepted Solution" by clicking the Accept as Solution button in the bottom right hand corner of this post.

Increase your profitability by integrating your email marketing and social media.  Download this guide and learn how you can achieve great results with email marketing and social media combined!
Occasional Participant

Re: Cannot upload customer contact file

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.

Tags (2)
CTCT Employee

Re: Cannot upload customer contact file

@KyleM961

 

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!

 

Evan G.
Customer Engagement Specialist
If you find my post helpful, and it answers your question, please mark it as an "Accepted Solution" by clicking the Accept as Solution button in the bottom right hand corner of this post.

Increase your profitability by integrating your email marketing and social media. Download this guide and learn how you can achieve great results with email marketing and social media combined!


Occasional Participant

Re: Cannot upload customer contact file

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.

Highlighted
CTCT Employee

Re: Cannot upload customer contact file

Heya @KyleM961,

 

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.


Briody_W
Community & Social Media Support

Did I answer your question? If so, please mark my post as an "Accepted Solution" by clicking the Accept as Solution button in the bottom right hand corner of this post.

Anyone can be a marketer! Visit our Blog & Resources page to brush up on the latest tips and tricks.