我在这里回答了类似的问题 https://***.com/a/16330428/1570901

I have answered similary question here https://***.com/a/16330428/1570901

如果你熟悉html和php，使用这个简单的库 simplex excel库和脚本，你可以创建自己的excel导入到mysql。可能需要几分钟的时间才能创建，但一旦创建就可以使用它。

If you are familiar with html and php, by using this simply library simplex excel library and script you can create your own excel import to mysql. IT may take few minutes to create but once your create you can use it for life time.

//创建一个HTML表单上传EXCEL表

// CREATE A HTML FORM TO UPLOAD EXCEL SHEET

//此后创建一个PHP脚本如下

// THEN CREATE A PHP SCRIPT LIKE BELOW

require 'simplexlsx.class.php';

if (isset($_FILES['Filedata'])) {

$file = $_FILES['Filedata']['tmp_name']; // UPLOADED EXCEL FILE

$xlsx = new SimpleXLSX($file);

list($cols, $rows) = $xlsx->dimension();

foreach( $xlsx->rows() as $k => $r) { // LOOP THROUGH EXCEL WORKSHEET

$q = "INSERT INTO TABLENAME(COL1, COL2) VALUE(";
  $q .=  "'".mysql_escape_string($r[0])."', "; // EXCEL DATA
  $q .=  "'".mysql_escape_string($r[1])."', "; // EXCEL DATA
  $q .= ")";

  $sql = mysql_query($q);

    } // IF ENDS HERE
    } // FOR EACH LOOP
}