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:

enter image description here

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

thanks

It is working fine at my end. I opened file in Excel 2007. which version are you trying? Or, try to open this generated CSV to any other PC. May be some setting changed in your excel. — Apul Gupta
– Apul Gupta, Commented Sep 20, 2014 at 11:46

Funk Forty Niner · Accepted Answer · 2014-09-20 14:26:37Z

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, ";");

edited Sep 20, 2014 at 14:26

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

answered Sep 20, 2014 at 11:49

Fuxi

7,59527 gold badges96 silver badges141 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Funk Forty Niner Over a year ago

I remember a question being posted some time ago where it was the same problem. OP was using a German version of Excel. The issue was quickly resolved because the OP had posted that they were using a German version which made answering/solving the issue faster.

Collectives™ on Stack Overflow

PHP Creating CSV not working as expected

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related