As @Rick James has already said
CREATE TABLE ... with the columns approximating the Excel columns.
LOAD DATA LOCAL FILE ... into that table in MySQL.
I am just goin to explore a bit more. I am writting the steps by steps the procedure based on (SQLyog,MySQL Workbench) tool . How you shall import excel file or CSV file into Mysql DB.
1) First create the HR Stuff table in your database through your MySQL
tool (like SQLyog, MySQL Workbench).(For Example, I have taken here 5 fields)
2) Create same date field appropriate column name in excel sheet.
NB: Here i am using SQLyog tool to import excel data in MySQL DB.
3)Right Click on table name -> Import->Import CSV Data Using LOAD LOCAL
4)Click your select button to choose your excel file
Then click over
import button and
To show the
HRStuff database details in MySQL DB .
Use 'YouDatabaseName'; (Where HRStuff is present)
After that you shall all details of your
hrstuff table details. Hope it will help out .