Essential tools for data analysis and tables management for novice and advanced Excel's users. A set of tools that will strengthen your Microsoft Excel to manage data bases and huge tables in your spreadsheets.
DBConvert for Excel & MySQL with scheduler feature converts Excel file (.xls) to MySQL and MySQL to Excel spreadsheets. You can save Excel data to PHP script or to MySQL Dump file for overcoming the restrictions on MySQL server.
This add-in for Excel 2000-2010 will allow you to fast and easy transform current tables to construct pivot ones, to divide one table into several ones or to unite two tables in one
Split Table Wizard instantly splits an Excel worksheet into multiple tables by selected column values. You can have the split tables inserted into the current or new workbook, or have each one pasted into a separate file. For Excel 2010-2003.
XlsToMy is a tool to import Excel data to Mysql. Main features: 1 Read data from excel sheet into a Mysql table. 2 Run SQL command to see importing results. 3 Support text,blob type. 4 Support Unicode. 5 Wizard - step by step.