Fix UTF-8 in CSV output

utf8-csv.php

<?php

// Open file pointer to standard output
$fp = fopen( 'php://output', 'w' );

// Write BOM character sequence to fix UTF-8 in Excel
fputs( $fp, $bom = chr(0xEF) . chr(0xBB) . chr(0xBF) );

// Write the rest of CSV to the file
if ( $fp ) {
  fputcsv( $fp, array( "Cars", "Planes", "Ships" ), ";" );
  fputcsv( $fp, array( "12", "2", "6" ), ";" );
  fputcsv( $fp, array( "23", "3", "5" ), ";" );
  fputcsv( $fp, array( "31", "5", "8" ), ";" );
}

fclose( $fp );

Thank you

Worked like a charm. Thanks!

Still working well in 2024 ;)