Import Excel Data into MySQL with PHP

PHPExcelReader.

To import Excel data, first you need to have a Excel reader. It should be accurate enough to interpret Excel data as expected. There 's a good old Excel reader.

Download PHPExcelReader.

In the downloaded archive, you only need Excel directory with files including oleread.inc and reader.php.

Just extract it where your web server can access.

Next place your excel file or just create one with some dummy data. Make sure this file is readble by the web server.

Finally create your php script to connect with database, read Excel file and insert data into db.

<?php

require_once 'Excel/reader.php';

$data = new Spreadsheet_Excel_Reader();

$data->setOutputEncoding('CP1251');

$data->read('a.xls');



$conn = mysql_connect("localhost","root","");

mysql_select_db("test",$conn);



for ($x = 2; $x <= count($data->sheets[0]["cells"]); $x++) {

$first = $data->sheets[0]["cells"][$x][1];

$middle = $data->sheets[0]["cells"][$x][2];

$last = $data->sheets[0]["cells"][$x][3];

$sql = "INSERT INTO mytable (First,Middle,Last)

VALUES ('$first','$middle','$last')";

echo $sql."\n";

mysql_query($sql);

}



?>