且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何将excel文件转换成mysql数据库?

更新时间:2022-10-17 23:19:19

如果您有一个Web服务器启动并运行PHP支持,我强烈建议 phpMyAdmin


  1. 将其配置为连接到MySQL

  2. 创建数据库和表

  3. 单击导入选项卡,然后导入CSV。

如果这是一个简单的一次性导入,这可能是不值得的努力。另一方面,如果再次与MySQL一起使用,您将永远不会后悔安装和配置phpMyAdmin的时间。


my boss wants me to create a mysql database for an existing excel file. I was wondering if there are any ways to do convert or import excel file? I have searched google but didn't find anything useful. I appreciate for any reply....Thanks.

If you have a web server up and running with PHP support, I highly recommend phpMyAdmin.

  1. Configure it to connect to MySQL
  2. Create the Database and table
  3. Click the import tab and you can import a CSV.

If this is a simple one-time import this probably isn't worth the effort. If, on the other hand, you will ever have to work with MySQL again, you will never regret the time to install and configure phpMyAdmin.