How to split a record in cvs from mySQL into columns in Excel'e?

Question

PHP

Good day to all.
I export a table from the database to a CSV file, but all the data is written in one column, how can I split them?
The code itself:

$result = $db->AllStudents($db);
$file_name = 'export.csv';

$out = fopen($file_name, 'w');
fputs($out, $bom =( chr(0xEF) . chr(0xBB) . chr(0xBF) ));
foreach ($result as $student){

    fputcsv($out,$student);
}
fclose($out);

Answer 1

Nadi use semicolons instead of commas.