not csv format files, but .xls or .xlsx format excel files, is there any free software for mac, that can import data into mysql?
Full disclosure.. I am the author of the following program. Give it a try and let me know what you think. I have tried many applications including the excel add-in from MySQL, but was not satisfied with them, so I wrote my own.
The current version of my program is slow (just like the MySQL add-in), doesn't support international characters, and doesn't support command line parameters, but it is free and works well.
I am working on a much better version which will remedy the aforementioned shortcomings and should be available soon.
I haven't tried any of the followings. But just sharing with the hope that this may help you...
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.
Save it as
.csv and then use the mySQL CLI [or other client-side utility] to issue a
LOAD DATA LOCAL INFILE statement.