Some people like their excel files. For people who want their data exported in an excel format checkout this chunk of code. It's really easy
First of all you need to download this php excel class
Now try this code:
PLAIN TEXT
PHP:
$query = mysql_query("select * from table");
while($q = mysql_fetch_assoc($query)){
$output[] = $q;
}
require_once "excel.php";
$export_file = [...]