If you have an Excel spreadsheet containing commas within the fields you will need to follow the steps below to export the sheet, so it will upload correctly. Note: This is for the Windows version of Excel only.
The sheet below is an example of commas within the “Recipient Name” column. Normally, when saved as a CSV file format, it will create 2 separate columns for items separated by a comma, but this can be prevented by exporting the file.
Sample Excel Spreadsheet Containing Commas
With the Excel sheet open, select File, then Export.
Select the option to “Change File Type”, choose “CSV (Comma delimited)”, and click “Save As”.
Save the file, after uploading it to the platform, you will see that it kept the commas in the field instead of separating the name into different columns.