[Support] [Functions] [Features] [Updates]
[Usage] [Screen Shot]
[Download] [Purchase]
[ Demos - How To ]
.
Functions
Export MySql Data To XLS XLSX and CSV. Create Excel compatible spreadsheets from your sql data. Reads Mysql database tables, and easily allows export to Excel. Open a connection to your Mysql server, execute a sql statement, and export to your favorite format. Optionally, you can even filter, and group and or edit your data interactively before committing to the conversion.
MySqlExcelExporter |
|
|---|---|
Reads MySQL Databases |
yes |
Reads MySQL Tables |
yes |
Creates XLS spreadsheets |
yes |
Creates XLSX spreadsheets |
yes |
Creates CSV files |
yes |
[ back to top ]
Features
- Works with all versions of Windows
- Works with all versions of MySQL
- Works with all versions of Excel
The MySql Excel Exporter creates a customizable spreadsheet from any sql query you can apply to your MySql data source:
- Full Data Tables
- Aggregate Data
- Grouped or sorted
- Filtered
- Column re-alignment and much more
[ back to top ]
.
Updates
Version 1.1 released
Now MysqlExcelExporter is Free!
Version 1.0 released
Brand New Release!
[ back to top ]
Example Usages
Need to supplemental your current backup strategy with csv files?
Looking for an easy way to provide real Excel worksheet data to your business partners?
Need a fast way to transfer data ?
Have repetitive tasks that require spreadsheet reports ?
Works great with nearly any MySql server !
[ back to top ]
[ back to top ]
Download
| Download Links | Size | Comments |
|---|---|---|
| This is the full setup | The trial is limited to 30 days. Requires Access to a MySQL Server. Requires .Net framework |
|
| Microsoft .NET framework only *note: Install this first if you are having trouble! |
MS Download Page | |
Note! There is no guarantee that this product will perform as expected. There is no warrantee offered or implied. Use at your own risk. |
||
[ back to top ]
[ back to top ]
Demos and How To.
How to get started:
- Enter your server's username, password.
- Enter your server's hostname.
- Select the Database you want to work with.
- Enter the SQL you would like to execute .
- Press the Fetch button.
- Press the Export to XLS button.
Other things you can do:
- Double click on a table to generate simple sql code
- Sort and reorder the sql fetched results .
- Group the data results by columns.
- Filter your MySql data interactively.
- Search your results for specific data rows .
[ back to top ]
.
.
