MySQL for Excel is an add-in that enables you to browse MySQL schemas, tables, views, and procedures from within Microsoft Excel. With MySQL for Excel, you can perform the following operations:
Import MySQL data into Excel.
Export Excel data to MySQL as a new table or append data to an existing table.
Modify MySQL data directly from within Excel.
Known limitation for binary data.
Import data and export data operations ignore columns containing
binary data (Varbinary
or
Blob
). This limitation is due to the following
factors:
Binary data within Excel cells have undefined characteristics by design.
Excel cells use text and numbers instead of binary data in a native form. Likewise, dates are stored as numbers internally in Excel.
Excel cells restrict the size of data that they can store, which a binary data field is likely to exceed.
External Resources That Supplement the Documentation
Release Notes: for notes detailing the changes in each release of MySQL for Excel, see MySQL for Excel Release Notes.
Support Forum: visit the MySQL for Excel forum for additional MySQL for Excel help and support.
Video Introduction: for a short introductory to MySQL for Excel video, see Video: MySQL for Excel Introduction on the official MySQL YouTube channel.
Developer Blog: developers of MySQL for Excel post related blog posts on the official MySQL on Windows Blog.