Extracting data from Excel files How to extract data from spreadsheets or Excel to database using terminal in Ubuntu? 

I'm using MySQL in Ubuntu and now I have 3 different Excel files using which I need to create a database in SQL. 

Can someone help me with how can I extract that Excel data to MySQL?
The simplest way is to create a formula in the additional column.
This formula has to make a correct INSERT statement. E.g.:

="INSERT INTO MYTABLE (field1, field2) VALUES ('" &amp; A1 &amp; "', '" &amp; B1 &amp; "');"


Then fill in the whole column with this formula
(A1 and B1 become A2 and B2, A3 and B3, etc.)

Select the whole column and copy to clipboard,
then activate the terminal and insert from clipboard.