Testing guide
Setting Excel sheets to be comma delimited
To achieve the desired result we need to temporary change the delimiter setting in the Excel Options. Move to :
File -> Options -> Advanced -> Editing Options
Uncheck the Use system separators
setting and put a comma in the “Decimal Separator” field.
Now save the file in the .CSV format and it will be saved in the semicolon delimited format