Do you work with both MySQL and Excel? Are you stuck editing Excel file after Excel file, while you know that in a database things would be easier? Fetching data from a database to then get it into an Excel spreadsheet to do analysis, reporting, transforming, sharing, etc. is a very common task among users. Do you want to interactively “connect” to an MySQL database, retrieving content? Do you need to keep having office users updating excel sheets, while you still need to have the data on a database? 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 an Excel Add-In that is installed and accessed from within the MS Excel’s Data tab offering a wizard-like interface arranged in an elegant yet simple way to help users
- browse MySQL Schemas, Tables, Views and Procedures and
- perform data operations against them using MS Excel as the vehicle to drive the data in and out MySQL Databases.
MySQL for Excel has been designed to be a simple and friendly tool for data analysts who want to harness the power of MS Excel to play with MySQL data without worrying about the technical details involved to reach the data they want, boosting productivity so they can focus on the data analysis and manipulation.
The basic operations supported through this Excel Add-In are
MySQL for Excel makes the task of getting MySQL data into Excel a very easy one; there are no intermediate CSV files required, only a couple of clicks and data will be imported to Excel. MySQL for Excel supports importing data from tables, views and stored procedures. Learn More »
MySQL for Excel allows users to create a new MySQL table from selected Excel data; data types are automatically recognized and defaulted for the new table and column names can be created from the first row of data, speeding up the process and making it simple for non-technical users. Learn more »
MySQL for Excel lets users save selected Excel data in existing tables; it will automatically attempt to map the columns of the selection with the ones in the MySQL table by column name or by data type, users can then review the mapping, manually change it and store it for later use. Like the Export Data feature, appending data into an existing table is very easy. Learn more »
Edit Data (last by definetaly not least)
MySQL for Excel now provides a way to edit a MySQL table’s data directly within Excel using a new worksheet as a canvas to update existing data, insert new rows and delete existing ones in a very friendly and intuitive way. Changes are pushed back to the MySQL Server as a transaction batch with the click of a button, or can be pushed as soon as they are done with no further clicks if users prefer it. This is a powerful feature since Excel is a natural user interface to operate with data, and these changes can be reflected in the database immediately. Learn more »
The latest version is MySQL for Excel 1.2.1 and you can find out more through the documentation at http://dev.mysql.com/doc/refman/5.6/en/mysql-for-excel.html
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 MySQL for Excel over the web and install it when run.
You can download MySQL for Excel from our official downloads page at
- http://dev.mysql.com/downloads/windows/excel as a standalone MSI,
- http://dev.mysql.com/downloads/installer/ as part of the MySQL Installer for Windows
Make sure to also checkout the MySQL for Excel team blog at https://blogs.oracle.com/MySqlOnWindows/ for updates on MySQL on Windows (ie Excel, Visual Studio, etc)