Program to import a Microsoft Excel spreadsheet into a MySQL table

Question

I am looking for a program that can:

• import a Microsoft Excel spreadsheet into a MySQL table
• support cells containing line breaks
• support cells containing ' (and if possible any other character)

If possible:

• Free
• Windows 7
• allows to specify which columns we want to import

Answer 1

You can simply export the spreadsheet in Microsoft Excel as a CSV, then use MySQL Workbench's import function:

This solution supports support cells containing line breaks and support cells containing '. However, it doesn't support all special characters as the Excel to CSV export will mangle the special characters that aren't ASCII characters. To perform an Excel to CSV conversion with UTF8 encoding, one solution is to first import the Microsoft Excel spreadsheet into Google drive, then export the Google Drive spreadsheet to a CSV, then use MySQL Workbench's import function.

Answer 2

I wrote an application for importing an Excel spreadsheet into MySQL. It meets all your other requirements except specifying columns to import, but it will import everything very fast and you can ignore or remove columns you don't want easily enough. In my biased opinion it is simply the most accurate, easiest and fastest way to import Excel spreadsheets into MySQL.

You can verify that it works with your data before purchase. It will load all your data except some random records will be blank until licensed. There are 2 versions of the program available. An easy to use GUI version and a command-line version which will allow you to automate and append your data to the table. It can handle all versions of Excel and MySQL Server. The process can be fully automated. Once you have the command-line version of the program called from a bat file or your favorite programming language, you can use windows task scheduler to schedule it. Excel2MySQL is capable of handling huge Excel spreadsheets.

http://excel2mysql.net