PHP Creating CSV not working as expected

Question

i'm trying to create a CSV using this solution: Creating csv file with php

Something is wrong, i keep getting data stuffed into one cell like this:

each value should be in an own cell .. any ideas what's wrong? seems like the csv uses the wrong delimiter.

thanks

Answer 1

I finally found the solution: seems like it doesn't work for the German version of Excel, all I had to do is changing the delimiter to a semi-colon like this:

fputcsv($fp, $val, ";");