How to Import a MySQl Database Table Into Excel
Pankaj Pathak
To import MySQL data into an Excel worksheet, select the table, view, or procedure with data to import and then click Import MySQL Data. A preview window displays the selected data and provides Options and Advanced Options to be used during the import operation.
https://dev.mysql.com/doc/refman/5.6/en/mysql-for-excel-import.html