2. Save the Excel sheet in .csv format.
3.Open the saved file with a text editor.
4.You can see rows are separated in new lines and columns separated with commas.
5. Create mysql database and create a table with same number of columns as the Excel table.In my example, my sql table fields are username,password and type.
6.Execute this query
LOAD DATA LOCAL INFILE 'C:\\Users\\Monto\\Documents\\Book1.csv' INTO TABLE alumini.login FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' (usrename, password,type);
7. The result
