PHP Write data in seperate columns

Question

When I want to put data in a CSV/Excel file it will automatically put all data in one column. This isn't very clear to read and I would like to have a single column for each data. Here is my code:

<?php
$data = array(
  'aaa,bbb,ccc,dddd',
  '123,456,789',
  '"aaa","bbb"'
);
$fp = fopen('test.csv', 'w');
foreach ( $data as $line ) {
  $val = explode(",", $line);
  fputcsv($fp, $val);
}
fclose($fp);
?>

and this is what it is showing inside the CSV/excel file:

How it is now:

How it is now

And here is how it should be:

How it should be

If you want to create a proper Excel file with the format you want, try out PHPSpreadsheet instead. What you're doing now is simply creating a CSV-file which you then open in Excel. At that point, it's up to Excel to parse the file and won't have anything to do with your code. — M. Eriksson
– M. Eriksson, Commented Dec 9, 2019 at 10:30
Show us the contents of the CSV file, open it in a notebook. You probably choose the wrong delimiter when you open the CSV file in Excel (you choose ";" instead of ","). — Gander
– Gander, Commented Dec 9, 2019 at 10:30

Gander · Accepted Answer · 2019-12-09 10:50:51Z

2

Try it like this:

<?php
$data = array(
  'aaa,bbb,ccc,dddd',
  '123,456,789',
  '"aaa","bbb"'
);
$fp = fopen('test.csv', 'w');
foreach ( $data as $line ) {
  $val = explode(",", $line);
  fputcsv($fp, $val, ";");
}
fclose($fp);
?>

answered Dec 9, 2019 at 10:50

Gander

2,0111 gold badge25 silver badges32 bronze badges

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

Comments

CodyKL · Accepted Answer · 2019-12-09 10:29:33Z

0

Seems that fputcsv use semicolon as default delimiter. You can pass the delimiter you want as third parameter to fputcsv.

$data = array(
    'aaa,bbb,ccc,dddd',
    '123,456,789',
    '"aaa","bbb"'
);
$fp = fopen('test.csv', 'w');
foreach ( $data as $line ) {
    $val = explode(",", $line);
    fputcsv($fp, $val, ',');
}
fclose($fp);

answered Dec 9, 2019 at 10:29

CodyKL

1,0647 silver badges14 bronze badges

Collectives™ on Stack Overflow

PHP Write data in seperate columns

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related