Same problem here as well. Squarespace should really look into this. We only get this problem from Excel-files. So we tell customers to copy the list from Excel, paste it into a Google sheet - and then import the downloaded csv-file from Google. But this is not good enough - and should be solved asap.