What are the best practices for separating data with tabulators in a CSV file for Excel compatibility in PHP?

When separating data with tabulators in a CSV file for Excel compatibility in PHP, it is important to use the "\t" character as the delimiter. This ensures that Excel can properly read and display the data when the CSV file is opened. Additionally, make sure to enclose each field in double quotes to handle cases where the data itself contains tabulators or commas. 

// Sample data
$data = array(
    array("Name", "Age", "City"),
    array("John Doe", 25, "New York"),
    array("Jane Smith", 30, "Los Angeles"),
);

// Output CSV file with tabulator delimiter
$fp = fopen('output.csv', 'w');
foreach ($data as $fields) {
    fputcsv($fp, $fields, "\t");
}
fclose($fp);

Keywords

CSV tabulators Excel compatibility PHP functions data separation

Related Questions