Home > Excel Business Solutions > Excel Productivity > Converting and Integrating > MySQL Data Source Share

MySQL Data Source

Excel mysql data source for converting and integrating

Excel MySQL Data Source

Rate this solution:
(3/5 from 1 vote)
MySQL Data Source screenshot
MySQL Data Source for Excel exports Excel compatible spreadsheets (XLS, XLSX and CSV) from MySQL data sources. MySQL Data Source for Excel reads MySQL database tables by creating a data source connection to a MySQL server, executing an SQL statement and exporting data to the desired Excel format. Furthermore, data can be optionally filtered, grouped and edited interactively before the MySQL data is converted and export to Excel.

Key features of MySQL Data Source for Excel include:
  • Works with all versions of Windows, MySQL and Excel
  • MySQL data can be full data tables, aggregated data, grouped or sorted data, filtered data, column re-aligned data, and more customization options.
  • Easy to use by specifying the data source server host name, user name, password, database, and SQL statement before fetching the data and exporting to Excel formats.
  • Allows double click on a table to generate simple SQL select code.
  • Allows sorting and reordering of the MySQL data results.
  • Allows grouping of the exported data results by columns.
  • Ability to filter the MySQL data interactively on export.
  • Ability to search the data source results for specific data rows.

Try It  Get It

(Pricing is available on the next page)
(Updated on 2019-04-01)

Related Excel Solutions for MySQL Data Source

Database and Cloud Data UpdatingData Management  Database ConversionConverting and Integrating  SQL Database ConverterConverting and Integrating  ODBC SQL QueryConverting and Integrating  MySQL ConverterConverting and Integrating  MySQL TableConverting and Integrating

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum.