I hate to say it, but the easiest solution is to go through Google Sheets. I have years of experience in excel and CSV and just could not get it to work so copied to Google Sheets.
Really disappointed in SquareSpace with this, it should be easy. They would be much better of stating clearly "use google sheets" and save yourself time and effort.