生成可以通过Excel打开的CSV文件

Question

I generate a CSV file with fputcsv function in PHP. Everything works fine except the fact that each line is one column of data in Microsoft Excel. Is there anything I can add or replace in each data so that it can be opened column per data?

$output = fopen('php://output', 'w');

foreach(...){
  fputcsv($output, $csv_data);

CSV content is like

2017-01-06 14:51:15,1,2
2017-01-06 14:50:08,3,4

Answer 1

Excel will normally parse your records using the comma.

If you want to get the records into a single column, enclose them in double quotes before importing:

"2017-01-06 14:51:15,1,2"
"2017-01-06 14:50:08,3,4"

this yields: