When saving a CSV file in Excel, it is really not 'Comma Separated'.It would be better to call it 'List Separator Separated' because it uses the list separator that is currently defined in the Control Panel's regional settings.
1. Start Excel and open the workbook with the sheet you want to convert.
2. Start Control Panel, Double-click Regional Settings, Click the Number tab
3. Change the list separator (it is probably a comma or maybe a semicolon before you change it) to a pipe symbol.
4. Click 'OK'
5. Return to Excel...
6. File - Save as, Type: CSV (Comma delimited). Click OK once or twice to accept the save.
7. After the save, go back to Control panel and set your list separator back to normal.
