No creo que le interese a nadie, pero así siempre lo tengo a mano :)

<?
$data="";
$result=mysql_query("SELECT * FROM tabla");
while($row = mysql_fetch_array($result)){
$data .='"'.str_replace("\r","",implode('","',$row)).'"'."\n";
}
 
header("Content-length: ".strlen($data));
header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=datos.csv");
header("Pragma: no-cache");
header("Expires: 0");
print $data;
?>