use DBI;
my $mysql_dbh = DBI->connect( ... mysql_dsn);
my $csv_dbh = DBI->connect( ... csv_dsn);
my $mysql_sth = $mysql_dbh->prepare( ...mysql_select_sql);
$mysql_sth->execute;
$csv_dbh->do("CREATE TABLE excelsheet AS IMPORT(?)",{},$mysql_sth);
[download]

Welcome to perlmonks! This is a wonderful place to discuss all things perl - including learning perl. However, it's a really poor place to have someone do your work for you. (In fact, most places are, at least the ones you don't pay for.) So the question is, what have you tried so far?

I'll give you some hints to get you started, though: check out Text::CSV or Spreadsheet::WriteExcel for the writing part, and DBD::MySQL for the reading part.

This is outside of perl but the MySQL query browser which is available from mysql.com has some export routines that will allow you to dump to csv, html, xml and xsl (though only Office XP compatible as it is the xml office format.) And you can do these dumps based on the query result set. Not bad if you need to visualise the data first and get the output quickly. I use the query browser to design the queries my scripts need. And get a visual feel of the data before I automate. The question is, does this need to be an automated process or is it just a dump and go. If it is dump and go use the query browser, if it is automated script check the examples given.

Second, just try using mysql from the command-line with -e'select * from table' and pipe to a file -- by default it will dump in TSV format, which Excel will open.