For some countries the default Delimiter value is a semicolon ";" versus a comma "," even when selecting Comma Separated Values (.csv) in Excel. This can apply to French Canadian customers as well as some European country settings as well.
Changing the Computer Regional Setting:
If .CSV is not a common use case for you, then you may have the option to update your regional delimiter in your computer's settings. This default should be present and will change for other software. This step will change the default value for your applications when using a delimiter value. You will need to restart your computer to reflect the changes.
To change your default delimiter setting in Windows:
1. Open the Windows Start Menu and click Control Panel
2. Open the Regional and Language Options dialog box
3. Click the Regional Options tab
4. Click Customize/Additional settings (Windows 10)
5. Type a comma into the 'List separator' box (,)
6. Click 'OK' twice to confirm the change
To change your default CSV setting on Mac:
1. In Spotlight Search, find "Language & Region"
2. Select "Advanced"
3. Make sure the number separators for grouping are set to comma (,)
To indicate the separator directly in CSV file:
For Excel to be able to read a CSV file with a field separator used in a given CSV file, you can specify the separator directly in that file.
Open your file in any text editor. For example, Notepad or TextEdit
Type this string before any other data: sep=,
Open your text file in Excel, from Excel itself or your file explore
Unable to Change the Computer Delimiter
If you already have a CSV file with the incorrect delimiter.
Correct the CSV file to have the correct delimiter.
Edit your desired file in Excel and save as a .CSV. This will still have the incorrect delimiter.
Go to the File tab
Click Save As
In the Save as type box, choose to save your Excel file as CSV (Comma delimited)
DO NOT OPEN or Convert the file in Excel.
You will want to open the file in a text editor (ie Notepad if available) Notepad++ is a good freeware option. This will display the text version of the file showing the semicolons.
Open the .CSV file in the text editor.
Edit Menu and Find and Replace (may be called Replace in your text editor)
Find the ";" and replace with [Blank] (nothing in the replace box)
Choose Replace all
Save your document, do not rename
Other Considerations
This should give you a prepared CSV with comma-separated values to be able to import the file correctly.
Note: if you get an error when importing locations you may need to format your address import without commas in the address field. Normally the commas are ignored in the standard .CSV import you may need to remove them. In Excel, you can find the "," and replace it with nothing to remove them from the addresses. Then repeat the procedures for saving the CSV.