ADHEAVEN - Natali Ardianto Official

When you open a CSV file with Excel, they will check your regional settings, and sometimes depending on your regional setting, they will use comma or semicolon. To let Excel know that you only want one of those type of separators, you should generate your CSV like this:

sep=,
“col1”,”col2”,”col3” 

… or this:

sep=;
“col1”;”col2”;”col3” 

Please take note that you must put this on the first line, and it will not be shown when you open this with Excel.