Most of the new features added to MySQL for Excel 1.3.x involve improvements to the Data Import functionality.
You can now refresh imported data from the source MySQL database by clickingfrom the context-menu, or from the navigation menu. These check for changes in the source MySQL database and update your imported MySQL data accordingly.
Use case: A colleague sends you a MySQL Excel spreadsheet with data exported from a MySQL database. You open the file several days later, and worry that the data is outdated so you click.
A newbutton was added to the options pages. It changes each option to the default value, and you then confirm (or cancel) the application of these changes.
Enabling the new Add Summary Fields for Numeric Columns option adds a summary field to the end of each numeric column in Excel. From here, you choose the desired function for the column, such as total or average.
You may now import data from multiple objects in a single operation. Use Control or Shift to select multiple objects (tables and/or views) from the MySQL for Excel panel, and click to open the new dialog for selecting additional objects that have direct relationships to the objects you selected. Each object opens in its own Worksheet.
From this new dialog, you may also generate a Relationships model in Excel. This functionality requires Excel 2013 or higher, or Excel 2010 with the PowerPivot add-in.
A new Create a PivotTable with the Imported Data option was added. This creates a Pivot Table in Excel.
All options now have descriptive tooltips. Hover over an option/preference to view helpful information about its use.
You may now specify a collation for created schemas. The collation type defaults to "Server Default." These statements can be reviewed before execution.
All MySQL data types are now available when performing Data Export operations. By default, only the most commonly used data types are listed, which was only behavior in previous versions of MySQL for Excel. You may still type in a type instead of selecting it.