What’s Trending in 2026? Let’s Plan Ahead—Together. 📈
Explore the trends + tell us how you’d use them.

Contact Import Errors - Quotations around emails

When I upload a csv file - Constant Contact is adding quotations around each email and causing the Contact Import Error. I have checked my file and there are no quotations around my emails. How do I keep this from happening?

 

1 reply
Best reply by William A

Hello @GregL1785 ,

 

The quotations are likely somewhere in the background coding, meaning whatever your source for the list is including them, even if they don't immediately appear in the file. If you're using Excel (or other MS programs), this may be even more of an issue, as some copied / downloaded cell data will result in quotations being included.

 

You may need to use your preferred spreadhseet program (Excel, Numbers, Google Sheets, etc.) to formulate the removal of this from your data, or check with the source of the contacts to see what can be done to remove/prevent these quotations being added.

View original

Join Our New Small Business Marketplace!

We're highlighting small businesses from our community. Add your business to the Marketplace to get discovered by new customers and support other entrepreneurs.