Jump to content
Search In
  • More options...
Find results that contain...
Find results in...
Advanced Search

Mailing list import error


Recommended Posts

I am trying to import a CSV file into my mailing list - however even though I have very carefully checked the original file and it is clearly in three columns - email, first name, last name, many of the last names are showing as doubled. that is marysmith@gmail.com Mary Smith Smith

It seems that the error is created when there is an email which has either numbers in it or an underscore .. eg mary_smith@gmail.com or marysmith14@gmail.com.I have imported the same list into MailChimp with no problem and no errors seen.I have been in touch with Squarespace help but without any luck so far. If anyone has any solution to this or has experienced similar please let me know.

Edited by Shazar
Initial Revision
Link to comment

Be aware everyone.. make sure your mailing list is in the correct format and is clean before you do any import into the Squarespace mailing program.. because if you import a faulty list - then realise it and delete that list - it will remain in the background of your lists and if you import a cleaned up list with the same names in it.. those will simply be pulled from the background data and will show as faulty again.
Not having any ability to edit individual email addresses would seem to be an essential feature - but it is not yet available on Squarespace mailing.

Link to comment
  • 4 months later...
  • 7 months later...
  • 2 months later...
On 7/3/2019 at 5:46 AM, Shazar said:

I am trying to import a CSV file into my mailing list - however even though I have very carefully checked the original file and it is clearly in three columns - email, first name, last name, many of the last names are showing as doubled. that is marysmith@gmail.com Mary Smith Smith

It seems that the error is created when there is an email which has either numbers in it or an underscore .. eg mary_smith@gmail.com or marysmith14@gmail.com.I have imported the same list into MailChimp with no problem and no errors seen.I have been in touch with Squarespace help but without any luck so far. If anyone has any solution to this or has experienced similar please let me know.

Hi Shazar, same with me.. did you got solutions?

Link to comment
  • 4 months later...

Not sure if this will help with your specific issues, but I was experiencing something similar before I tried these steps and I was then able to successfully import my CSV list:

  1. Remove special characters in both first, and last name fields. I'm using Gsheets for editing the data and I first selected both columns, then "Find-and-Replace" from the menu to remove special characters like quotation marks, periods, hyphens, underscores, and spaces.
  2. Make sure the CSV filename has NO special characters. "nameofyourfile.csv" VS "name-of your_file.csv". As you can see the second example here has a hyphen, space, underscore, and a period in the middle of the filename.

This worked for me and really I think it was the filename (STEP 02 here) that did the trick. Hope this helps!

Link to comment
  • 2 months later...

Hi I am trying to import a mailing list, at first it was around 1200 subscribers, I tried uploading then it says its failed "This list has addresses that may cause high bounce rates and spam reports. Remove any fake, invalid, and improperly formatted addresses, and ensure you have consent to mail everyone on your list." then I user Bouncer, to remove all undeliverable, risky or spam emails. I uploaded the new CSV and its still the same.

Please help i do not want to manually add one each but I will if I have to.

Link to comment
  • 4 months later...

Hi all I found a work around. 

I was having the same issues and found that using Mac numbers was the problem. Simply exporting as a .csv file was not working. What I did was export as an excel spreadsheet and then exported as a .csv file. This worked!

Edited by Squeegeeclean
Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

×
×
  • Create New...