Import excel workbook to Mysql database

Question

Is there a way by which I can import an excel workbook which has multiple sheets to mysql database into multiple tables?

Which means, lets say

I have an excel workbook with 3 sheets named sheet1, sheet2 sheet3. Headers for each sheet is on the first row. Now I need these 3 sheets to be stored as 3 tables (sheet, sheet2, sheet3) in the database.

Is there a way to do this using phpmyadmin, php, python or any other?

I know, we can import individual csv sheets. I want to know if batch import works or not

Try file_get_contents(''), see what it displays in the browser. Then $rows = explode("/n",$data);. This is php, so i don't know if you understand it. — user2067005
– user2067005, Commented Jun 23, 2013 at 7:25

Burhan Khalid · Accepted Answer · 2013-06-23 07:42:53Z

Is there a way by which I can import an excel workbook which has multiple sheets to mysql database into multiple tables?

If you have remote access to the database or if the database is on the same machine where you have Excel; the easiest way is the MySQL for Excel addin which allows you direct access to MySQL from within Excel.

If not, you have other options:

Export each sheet as a csv file, and then read those files individually to create the tables and populate them. Other than the Excel addin option, this is the recommended.
Use xlrt or phpexcel to read the native .xls format files and extract the information required from each sheet. This would be closest to your batch import requirement; in that you don't have to deal with multiple files representing each sheet.

Collectives™ on Stack Overflow

Import excel workbook to Mysql database

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related