Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

share|improve this question

closed as off-topic by Paul White, Phil, Aaron Bertrand Jun 2 at 13:56

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Paul White, Phil, Aaron Bertrand
If this question can be reworded to fit the rules in the help center, please edit the question.

3 Answers 3

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.

http://panofish.net/excel2mysql/

I am working on a much better version which will remedy the aforementioned shortcomings and should be available soon.

share|improve this answer
    
Version 2.0 of Excel2MySQL is available and it is FAST and more importantly 100% accurate. No longer free, but it is cheap. excel2mysql.net –  panofish Jul 16 at 1:00

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

share|improve this answer
    
Agree 1000% using 3rd party software for this type of activity is bound to complicate things more than it needs to. –  Pynner Nov 17 '12 at 1:46

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.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.