Hi, Hannah_M. Our Excel spreadsheet file is just a newly generated version of a database list that we have uploaded before without problems. The file format is .XLSX, and contains 14,742 people's names and email addresses, some of which do contain single quotation marks as apostrophes. We should not have to delete the single quotation marks, especially given that removing them from email addresses would make those addresses invalid.
I tried splitting the one large file into smaller files of 5,000 or less, but importing from the first of those files has also failed. Just as before, the failure message offers no details at all regarding the reason for the failure. Your system must have logs that record these errors. Why can't your failure message cite the quantity and nature of the problems causing the import to fail?
Someone at ConstantContact obviously changed something in the code or settings of your importing process. I would strongly suggest that you try comparing the current code and settings to archived system backups so that you can find the problematic changes and correct or remove them. Seeing the repeated pop-ups promoting upcoming improvements in your import process, I am reminded of the old adage: "If it ain't broke, don't fix it."
... View more