How to open CSV files with the correct delimiter/separator in excel

Adding “sep=;” or “sep=,” to the CSV

When you have a CSV that is separated by semicolons (;) and your system/Excel default is commas (,), you can add a single line to tell Excel what delimiter to use when opening the file. To do this:

1. Open your CSV using a text editor.
   1. Windows: NotePad (notepad.exe)
   2. Mac: TextEdit (textedit.app)
2. Skip a line at the top, and add sep=; if the separator used in the CSV is a semicolon (;), or sep=, if the separator is a comma (,). 
3. Save, and re-open the file.

Please refer this article for the more details.