Microsoft Excel is a very good software for working with a large amount of data. It has many powerful features for data manipulating.
It is very beneficial to work with MySQL database within Microsoft Excel. Fortunately, Oracle the creator of MySQL has Microsoft Excel plugin.
MySQL for Excel enables you to work with a MySQL database from within Microsoft Excel. MySQL data can be imported into Excel, Excel data can be exported into MySQL as a new table or appended to a current table, and MySQL for Excel enables you to edit the MySQL data directly from within Excel.
To use this plugins make sure you white-list your IP in remote MySQL option.
To download this FREE plugin browse to
Manual for MySQL for Excel can be found in this page