TriCO

Manually inserting tables into MySQL databases and having as a start point Excel data can be really tiresome, especially when dealing with large volumes of data. The best way of transferring table data from spreadsheets to a MySQL database is through the aid of a conversion utility, such as TriCO. This app was designed for offering users the means to easily transfer XLS and XLSX data into either MySQL or MongoDB databases.

The application is based on a form-style layout that accepts manual text string input. All that users need to do is indicate the name of their MySQL or MongoDB databases and the login credentials. A preferred table name also needs to be inputted, although things are not clear about the correspondence in the Excel file.

Once an XLS or XLSX file has been added, the application will establish a connection to the existing database and will perform the conversion.

The app does offer conversion for two database types – MySQL and MongoDB, and accessing each one is done by entering a menu. Regarding this aspect, it would have been beneficial for the app to feature two, distinct buttons or sections for performing the switch between the two, this way saving up time.

Compact app for transferring Excel table data into external databases, which lacks batch-processing functionality

Leaving looks aside and focusing solely on functionality, this app could be a fair choice for users who require a way of quickly adding their XLS and XLSX files into external databases. Indeed, the app doesn’t provide simultaneous multi-file processing, but this fact alone is not enough to tilt the balance.