I just downloaded the latest XlsToMy 3.1, a simple but powerful software to convert Microsoft Excel to MySQL Database format. The user interface of this program is not fancy but its pretty easy to use. The wizard based conversion process is very clear and easy to use even if you are new to XlsToMy.
Connect to MySQL Server
Open the program and you will need to connect your MySQL Server to this program. It support local or remote MySQL Server.
Export Wizard
Once connected, you will see the following window where you can select the task. XlsToMy support multiple files export.
This program will detect spreadsheets inside the excel file. Browse the file and then specify the spreadsheet to export.
The next window we need to specify the MySQL Schema and table. We can also create new MySQL table if we need to. We can also select different load type such as Append, Replace and Update.
The free version of XlsToMy only allows us to export limited rows (55 rows). If you like this software, you will need to purchase it from the official website.
Bottom Line
XlsToMy is a useful software for you who needs a simple way to convert your excel files to MySQL Database. The wizard based conversion works smoothly. I don’t have any problems during the test.
The Good:
- Wizard based conversion
- Supports multiple file conversion
- Can create new MySQL table from this software
- Can save conversion session for future use
The Bad:
- Pretty expensive ($59 for 1 license)
You can download XlsToMy 3.1 from the link below. Please note that we do not provide XlsToMy full version, XlsToMy serial number, XlsToMy keygen.
XlsToMy 3.1 Download