Adding quotation marks to my data so my email addresses are not in the correct format.

0 Votes
I am adding contacts from a CSV and XLS file formats and keep getting this issue. What happens is Constant Contact is adding quotation marks to all of my data in the file. As a result, my contact's email addresses are in the wrong format. I checked the different files multiple times on my end and have not seen the quotation marks. But when I upload into Constant Contact, they are added and I cannot continue to upload them. I have managed to find a work around but it makes no sense why it works. I open in google sheets, then download as a CSV from there, and like magic its working. Same file, same data, different result.
Established Member

Is it happening with both file formats, or only one or the other?


XLS can save a leading single quotation mark--to denote a text-formatted field--that doesn't show up in the spreadsheet grid when you're looking at it.  But when you click into a cell to make it active, if there's a single quote there before the text, you can see it in the Formula Bar.  Do you see any?


Saving XLS to CSV should remove the quotation marks, which is what I assume google sheets is doing.  You should be able to run the same operation yourself: try opening your file in Excel, resaving as CSV, and uploading again.



Status changed to: Closed - No Action
What happens with product feedback?

Find out about the life-cycle of a product idea when it is posted on our Feedback board.

Read More

What's New

See the latest Constant Contact product release notes and updates.

Learn More