You have a MySQL database full of records, and someone who needs them in a spreadsheet. Copying tables by hand, or writing export scripts, takes longer than the job deserves. MySQL to MS Excel Database Converter is a Windows tool that does this conversion through a graphical interface.
Quick facts
- Platform: Windows, on systems that support MySQL server
- Price: $45.00
- Input: MySQL database records
- Output: MS Excel worksheets
Key features
Convert a whole database or only the tables you pick
You can convert the entire database or selected table records. That helps when you only need part of the data in a sheet.
No scripting or database coding
A conversion wizard guides you through the process. You don't write scripts or design tables, and you don't need programming skills.
Keeps constraints, data types, rows and columns
The vendor says the tool supports key constraints, data types, attributes, tables, rows and columns. It also says the source database files are not altered.
Save the result where you want it
You choose the location on your system where the converted file is saved.
Who it's for
It suits IT staff, DBAs, and people in schools or small businesses who need MySQL data in Excel and don't want to code the export. It works on all major versions of MySQL server.
Pros and cons
Pros
- Simple wizard-style interface
- Converts everything or just selected tables
- Works with all major MySQL server versions
- No technical skills needed
Cons
- Windows only
- It converts in one direction, MySQL to Excel. Excel to MySQL is a separate product.
- Paid software at $45.00
FAQs
Do I need to know SQL or programming?
No. The vendor says no scripting, database coding or table design is required.
Can I convert only some tables?
Yes. You can convert the whole database or selected table records.
Will it change my original database?
The vendor says conversion happens without altering the source database files.
Can I go from Excel back to MySQL?
Not with this tool. The vendor sells a separate MS Excel to MySQL converter.
System requirements
- 128MB RAM
- 20MB disk space for installation
- Windows with MySQL server support