Table of Contents
MySQL for Excel allows you to work directly and access a MySQL Server database from within Microsoft Excel. The main options include:
Open a MySQL Connection: Choose a saved database connection here, or also add and manage new connections. MySQL Workbench is used to manage connections, and both remote and local connections are available. Double-click a connection and then enter the password, if required.
Select a Database Object: After choosing a MySQL Server connection (local or remotely), this chooses a schema object to edit and offers the Tables, Views, and Procedures. Select one, and then click Import MySQL Data.
Import MySQL Data: This will add the
object's data into an Excel spreadsheet. After choosing a Table,
View, or Procedure to edit, this will generate a Import
Data popup. It includes a preview and offers
additional options for the import. Choose
will import the data into Excel.
Append Excel Data to Table: After importing and changing data, this is how you append the data back into the MySQL database. It will show a diff (exactly what data you changed in Excel), and whether or not columns can be mapped with success. Both automatic and manual mapping options are available.
Export Excel Data to New Table: After importing and changing data, this will export the selected data to a new table.
MySQL for Excel is a product for Microsoft Windows, and it is installed via MySQL Installer.
Microsoft Office 2007 or greater, with Excel.
Visual Studio Tools must be available, and
MySQL Installer will check and install this for you.
An available MySQL Server connection.
MySQL for Excel is loaded and executed within Excel itself by selecting the tab, and then choosing the "MySQL for Excel" Database icon. This will open a new sidebar within Excel that contains all of the available options.
This documentation is in progress. For further support regarding how MySQL for Excel works, please visit the MySQL forums.