MySQL for Excel Guide  /  Introduction

Chapter 1 Introduction

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