BenDer Posted August 31, 2020 Share Posted August 31, 2020 Hi There I can not import a csv file of email addresses – always get the same error message: "The first column of your CSV must contain at least one email address." Of course first column contains nothing but an email address. Also the doc has exactly three columns as requested. Nothing works. Even if I download a list that has been created within squarespace, open, export from numbers as csv and import it again – I get the same message. Also tried to export on an pc and exel > same result. I'm desperate. Has anyone experienced issues like these and has an idea how to solve? Link to comment
creedon Posted September 1, 2020 Share Posted September 1, 2020 (edited) Lets try an experiment. Create a file with just the first line of your email list and import that. What happens? Edited September 1, 2020 by creedon Find my contributions useful? Please like, upvote, mark my answer as the best ( solution ), and see my profile. Thanks for your support! I am a Squarespace ( and other technological things ) consultant open for new projects. Link to comment
matneidhardt Posted September 21, 2020 Share Posted September 21, 2020 i have the same problem on and on... i did try with one email... it not works as well... maybe something to do with formats. of the CSV? Link to comment
Langballe Posted October 1, 2020 Share Posted October 1, 2020 I had the same problem. Then I manually added a few contacts to the mailing list in Squarespace, and then I downloaded that ist to my computer. From there I added the emails I had in my original .csv file to the one I had downloaded from Squarespace. That new list I could then upload to Squarespace. Hope it works for you as well. Anyais_Krisztina 1 Link to comment
TheodorCph Posted October 12, 2020 Share Posted October 12, 2020 It need to be "," and not ";" nenad 1 Link to comment
MikkoS Posted November 17, 2020 Share Posted November 17, 2020 Hi, I have the same problem and now understand that one needs to use a comma and not a semicolon. But where, exactly, do I use a comma? Since I haven't used any semicolons either... Link to comment
MikkoS Posted November 17, 2020 Share Posted November 17, 2020 (edited) ...and I finally have a solution that works. It seems that the problem persists, if you use Apple Numbers and export them to CSV. The easiest way to go around this is not to use Numbers. Instead I used Google Sheets and it worked beautifully. Edited February 20, 2021 by MikkoS Spelling mistake kirillillenkov 1 Link to comment
STEFAANDECORTELAUREA Posted December 21, 2020 Share Posted December 21, 2020 I had the same problem (using Microsoft Excel to create the list, saving it as a CSV) = did not work. I followed MikkoS method: copy pasting into a google sheet and next, save as CSV => works perfectly. kirillillenkov 1 Link to comment
Hannah_Sutton_Design Posted October 5, 2022 Share Posted October 5, 2022 I can confirm that MikkoS ' solution works! (thank you!) open the .csv in Google Sheets, resave as a .csv and try uploading again. The error message should dissappear. Squarespace should work on this issue though; I was uploading a .csv file directly downloaded from Squarespace 7.0 site and re-uploading into 7.1 without any interference and it gave me the error message. Very confusing for users! Link to comment
CSA Posted November 17, 2022 Share Posted November 17, 2022 On 10/5/2022 at 3:05 PM, Hannah_Sutton_Design said: I can confirm that MikkoS ' solution works! (thank you!) open the .csv in Google Sheets, resave as a .csv and try uploading again. The error message should dissappear. Squarespace should work on this issue though; I was uploading a .csv file directly downloaded from Squarespace 7.0 site and re-uploading into 7.1 without any interference and it gave me the error message. Very confusing for users! At 17/11/2022, I'm using 7.0 version. Perhaps this has been remedied in 7.1 later version. Can someone, please, confirm if this is corrected there? In the meantime, I'll seek to get my Company's version updated anyway. Link to comment
Wildpines Posted December 2, 2022 Share Posted December 2, 2022 I can confirm an alternative solution. Open a brand new spreadsheet and save it blank and ensure that the delimiter is a comma or quotation. Save. Then copy and paste into it and then save. Then import. I use openoffice and it worked a treat. Thanks for this thread though as it helped. Thanks. Link to comment
jala Posted July 14 Share Posted July 14 This problem occurs in Europe, where excel uses ";" to separate data and not "," as in the US. Theodors comment above helped me to detect the problem. The easiest way out is in Mac or Windows to go to the "system settings" or "Systemeinstellungen", choose "Language&Region" and change it to "English". You can change it generally or just choose specific apps. I chose excel in the apps and it reseted immediately and when I saved my excel file as csv, I could finally import it to Squarespace...😇. Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment