С помощью такого кода содержимое вашей базы данных легко можно отобразить в Microsoft Excel.

                        
<?php

//Настройки подключения

$DB_Server = "localhost" ; //Сервер

$DB_Username = "" ; //Имя пользователя

$DB_Password = "" ; //Пароль

$DB_DBName = "" ; //БД

$DB_TBLName = "" ; //Имя таблицы

$sql = "Select * from $DB_TBLName" ;

$Use_Title = 1 ;

//define date for title: EDIT this to create the time-format you need

$now_date = date ( 'm-d-Y H:i' );

//define title for .doc or .xls file: EDIT this if you want

$title = "Dump For Table $DB_TBLName from Database $DB_DBName on $now_date" ;

//create MySQL connection

$Connect = @ mysql_connect ( $DB_Server , $DB_Username , $DB_Password )

        or die( "Couldn't connect to MySQL:<br>" . mysql_error () . "<br>" . mysql_errno ());

//select database

$Db = @ mysql_select_db ( $DB_DBName , $Connect )

        or die( "Couldn't select database:<br>" . mysql_error (). "<br>" . mysql_errno ());

//execute query

$result = @ mysql_query ( $sql , $Connect )

        or die( "Couldn't execute query:<br>" . mysql_error (). "<br>" . mysql_errno ());

//if this parameter is included ($w=1), file returned will be in word format ('.doc')

//if parameter is not included, file returned will be in excel format ('.xls')

if ( isset ( $w ) && ( $w == 1 ))

{

$file_type = "msword" ;

$file_ending = "doc" ;

} else {

$file_type = "vnd.ms-excel" ;

$file_ending = "xls" ;

}

//header info for browser: determines file type ('.doc' or '.xls')

header( "Content-Type: application/$file_type" );

header( "Content-Disposition: attachment; filename=database_dump.$file_ending" );

header( "Pragma: no-cache" );

header( "Expires: 0" );

/*      Start of Formatting for Word or Excel   */

if ( isset ( $w ) && ( $w == 1 )) //check for $w again

{

/*      FORMATTING FOR WORD DOCUMENTS ('.doc')   */

//create title with timestamp:

if ( $Use_Title == 1 )

{

echo ( "$title \n\n " );

}

//define separator (defines columns in excel & tabs in word)

$sep = " \n " ; //new line character

while ( $row = mysql_fetch_row ( $result ))

{

//set_time_limit(60); // HaRa

$schema_insert = "" ;

for ( $j = 0 ; $j < mysql_num_fields ( $result ); $j ++)

{

//define field names

$field_name = mysql_field_name ( $result , $j );

//will show name of fields

$schema_insert .= "$field_name: \t " ;

if (! isset( $row [ $j ])) {

$schema_insert .= "NULL" . $sep ;

}

elseif ( $row [ $j ] != "" ) {

$schema_insert .= "$row[$j]" . $sep ;

}

else {

$schema_insert .= "" . $sep ;

}

}

$schema_insert = str_replace ( $sep . "$" , "" , $schema_insert );

$schema_insert .= " \t " ;

print( trim( $schema_insert ));

//end of each mysql row

//creates line to separate data from each MySQL table row

print " \n ---------------------------------------------------- \n " ;

}

} else {

/*      FORMATTING FOR EXCEL DOCUMENTS ('.xls')   */

//create title with timestamp:

if ( $Use_Title == 1 )

{

echo ( "$title \n " );

}

//define separator (defines columns in excel & tabs in word)

$sep = " \t " ; //tabbed character

//start of printing column names as names of MySQL fields

for ( $i = 0 ; $i < mysql_num_fields ( $result ); $i ++)

{

echo mysql_field_name ( $result , $i ) . " \t " ;

}

print ( " \n " );

//end of printing column names

//start while loop to get data

while ( $row = mysql_fetch_row ( $result ))

{

//set_time_limit(60);

$schema_insert = "" ;

for ( $j = 0 ; $j < mysql_num_fields ( $result ); $j ++)

{

if (! isset( $row [ $j ]))

$schema_insert .= "NULL" . $sep ;

elseif ( $row [ $j ] != "" )

$schema_insert .= "$row[$j]" . $sep ;

else

$schema_insert .= "" . $sep ;

}

$schema_insert = str_replace ( $sep . "$" , "" , $schema_insert );

$schema_insert = preg_replace ( "/ \r\n | \n\r | \n | \r /" , " " , $schema_insert );

$schema_insert .= " \t " ;

print( trim( $schema_insert ));

print " \n " ;

}

}

?>