Import Excel CSV into MySQL table: I want to import CSV file to MySQL table

I have tables in MySQL database. This is the structure of my database tables:

table 1 - tbl_main_categories:

column(id,category_name)
values(1,jewellery)
values(2,earrings)

table-2(tbl_sub_category)

column(id,main_category_id,sub_cat_name)
values(1,1(from table tbl_main_categories),fine jewellwry)
values(2,1(from table tbl_main_categories),cutting jewellwry)
values(3,2(from table tbl_main_categories),sea earing)

table-3(tbl_products)

column(id,product_name,sub_category_id)
values(1,product1,2(from table tbl_sub_category))
values(2,product2,3(from table tbl_sub_category))
values(3,product3,2(from table tbl_sub_category))

My excel sheet data as follows(product.xls)

row-1

col1->product_name=product4.
col2->sub_category=cutting jewellwry

row-2

col1->product_name=product5.
col2->sub_category=sea earing

row-3

col1->product_name=product6.
col2->sub_category=finejewellwry

row-4

col1->product_name=product7.
col2->sub_category=sea earing

My problem:

How to import file product.xls to MySQL table (tbl_products), as it contains ids from table tbl_sub_categories where as in my Excel there is name of sub_categories?

Please suggest me a library as I am beginner to PHP world.

by Manuel Lemos 26695 - 9 years ago (2015-07-20) Comment

You can use this class if you export your Excel spreadsheet to the CSV format.

It is important that the spreadsheet headers match the database field names.