MySQL for Excel is an application plug-in enabling data analysts to very easily access and manipulate MySQL data within Microsoft Excel. It enables you to directly work with a MySQL database from within Microsoft Excel so you can easily do tasks such as:
* Importing MySQL Data into Excel
* Exporting Excel data directly into MySQL to a new or existing table
* Editing MySQL data directly within Excel
MySQL for Excel is installed using the MySQL Installer for Windows.
The MySQL Installer comes in 2 versions
- Full (150 MB) which includes a complete set of MySQL products with
their binaries included in the download.
- Web (1.5 MB – a network install) which will just pull the MySQL for
Excel over the web and install it when run.
You can download MySQL Installer from our official Downloads page at https://urldefense.proofpoint.com/v2/url?u=http-3A__dev.mysql.com_downloads_installer_&d=CwIFaQ&c=IV_clAzoPDE253xZdHuilRgztyh_RiV3wUrLrDQYWSI&r=b3rm4E2nx7aGlNTnMaOjlzWmTXv_sJTyehHR_J-0TT4&m=MNKqrM4wOBaJFL1sLBDcd_51hRakxL9J36IXe6W5Xao&s=biWElijgNfFAEB5zTpXOEzKFv8VnHeOK4NTfmjeP7HY&e=
The MySQL for Excel product can also be downloaded by using the product standalone installer found at this linkhttps://urldefense.proofpoint.com/v2/url?u=http-3A__dev.mysql.com_downloads_windows_excel_&d=CwIFaQ&c=IV_clAzoPDE253xZdHuilRgztyh_RiV3wUrLrDQYWSI&r=b3rm4E2nx7aGlNTnMaOjlzWmTXv_sJTyehHR_J-0TT4&m=MNKqrM4wOBaJFL1sLBDcd_51hRakxL9J36IXe6W5Xao&s=QTrLZCERkFq1f5vnvv3zVm6OZv8_YD2DWfcRpfUcmEM&e=
Changes in MySQL for Excel 1.3.6 (2016-01-07)
* Functionality Added or Changed
* Bugs Fixed
Functionality Added or Changed
* A new Generate an INSERT statement for each data row
option was added to the Advanced Options dialog for
Append and Export Data operations. This is disabled by
default. A single INSERT statement is generated that
inserts all affected rows, unless this option is enabled.
When checked, an INSERT statement for each data row being
appended or exported is generated in the resulting SQL
query sent to the MySQL server. When unchecked, a single
INSERT statement is generated as a bulk data operation,
which performs better than multiple INSERT statements.
While row-by-row inserts are slower, for debugging errors
it could help determine which row causes an error, since
the MySQL Server will process them row by row.
* Added column properties to the Export Data dialog to
support the definition of Auto Increment and Default
Value for new MySQL tables where the data will be
Added a context menu to declare a numeric field to be
Unsigned or to have Zero-Fill, accessible by
right-clicking the Data Type combo box.
Added the TIMESTAMP data type to the full list of valid
data types, as it was not being shown before. Added help
tool tips to fields in the Export Data dialog that
explain in detail how the column properties work in a
* The Pivot Table feature was updated to work with Excel
2016. (Bug #22387425)
* Closing the plugin via the Close button in the panel
would not toggle the MySQL for Excel checkbox in the Data
ribbon. (Bug #22374026, Bug #79655)
* Fixed the content detector for the active Excel cell
after importing data and after loading database objects
when a database is opened. Now, the data options are not
enabled until a table is selected. (Bug #22372915)
* Append and Export operations would not append/export
boolean data. (Bug #22138966)
* The MySQL for Excel Refresh All function would throw an
unhandled exception. (Bug #22110627, Bug #78941)
* With Office 2007, data would not auto-save after closing
Excel. (Bug #22081313, Bug #78910)
* Numeric data stored in text columns is now correctly
formatted by Excel as text, and not as the “General”
format that automatically formats cells as numbers when
the data is stored in a text object. This fixes the issue
where text columns were formatted as numbers, which
stripped leading zeros. (Bug #20905284, Bug #76738)
* Changed settings for containers and forms to let all UI
components automatically scale on different DPI settings.
Also removed the restriction to resize the MySQL for
Excel’s pane, so in case a different DPI setting is used
and the fonts look too big, the pane can be resized to
see contents as best as possible. (Bug #18099454, Bug