What is it like to import an excel file into mysql database?

My excel table looks like this

Country   |   Amount   |   Qty
----------------------------------
America   |   93       |   0.60

Greece    |   9377     |   0.80

Australia |   9375     |   0.80

Best Answer

There's a simple online tool that can do this called sqlizer.io .

You upload an xlsx file to it, enter a sheet name and cell range, and it will generate a create table statement and a bunch of insert statements to import all your data into a mysql database.

(Disclaimer: I help run SQLizer)