Is there a free software that can import excel into mysql on mac?

Question

not csv format files, but .xls or .xlsx format excel files, is there any free software for mac, that can import data into mysql?

Answer 1

I haven't tried any of the followings. But just sharing with the hope that this may help you...

http://blog.mclaughlinsoftware.com/2011/02/27/excel-2011-query-mysql/ http://blog.mclaughlinsoftware.com/microsoft-excel/excel-2011-mysql-config/

Source: http://forums.mysql.com/read.php?171,561930,561930

FYI, MySQL officially introduced a tool namely MySQL for Excel (for Windows) to work with Excel.

MySQL for Excel allows you to work with a MySQL database from within Microsoft Excel. MySQL data can be imported into Excel, Excel data can be exported into MySQL as a new table or appended to a current table, and MySQL for Excel allows you to edit the MySQL data directly from within Excel.

Answer 2

Save it as .csv and then use the mySQL CLI [or other client-side utility] to issue a LOAD DATA LOCAL INFILE statement.