Convert xls to mySQL

Convert xls to mySQL is a small-sized software tool whose purpose is to aid people in converting MS Excel documents to an SQL format, as well as run SQL commands.

The installation process does not take too long and does not come with any unpleasant surprises. The interface you come across is quite clear-cut, seeing it includes a few buttons, some boxes and two tabs which enable you to easily access all the available options.

Although Help contents are not included, this utility is suitable to both power and novice users, as long as they have some knowledge regarding MySQL databases. However, it is not particularly appealing.

This application enables you to upload an XLS document with the help of an incorporated file browser, as well as specify if the table you want to use has a title or not.

It is possible to view the contents of the XLS in the main window, as well as input information regarding the MySQL database you want to connect to. You are requires to add details such as host, database, user name and password.

The second tab enables you to write SQL commands in a dedicated panel, as well as execute them and view the results, with just a click of the button.

In conclusion, Convert xls to mySQL is an efficient piece of software when it comes to converting XLS documents to SQL, without putting a strain on the computer’s performance. The interface is friendly to all users, the response time is good and we did not detect any bugs or errors.

Nevertheless you should know this utility has been discontinued and therefore will no longer receive updates, and might not work on newer operating systems, such as Windows 8 and 8.1.