MySQL to Microsoft Excel Migration.

 DBConvert for Excel & MySQL

Version: 2.4.1

Release Date: Feb. 3, 2017

Conversion directions:

  • Excel → MySQL, MariaDB MySQL Dump, PHP Script
  • MySQL, MariaDB → Excel, MySQL Dump, PHP Script
  • Excel ↔ Amazon RDS

DBConvert software for database transformation helps you to perform data migration from MySQL or MariaDB servers to Microsoft Excel .xls and .xlsx spreadsheets and vice versa. It lets your data to be sent directly from MySQL database to MS Excel files and back from MS Excel spreadsheets to MySQL database.

Every MySQL table is converted to one Excel sheet and inversely – one Excel sheet to one MySQL table by default. But you can deselect unwanted data at customization stage to be transferred before conversion process starts.

The Build-in Scheduler and Command Line Support will do the database transfer for you in the automated mode.

This software was designed to transfer data between MySQL tables and MS Excel sheets quickly and neatly and to simplify the process of data conversion as much as possible.

Product Highlights

  • Amazon RDS MySQL DB Instance support
  • Microsoft Excel 2000 or higher 2003/2007/2010
  • Views conversion from MySQL to MS SQL and Oracle and back support
  • Ability to create tables from MS Excel file with Integrated Data Selector
  • Speed conversion with Bulk and Quantization features
  • Ability to connect to MySQL Server 4.x/5.x located on Linux, Solaris, Mac OS X, Windows machines
  • Saving data into a MySQL Dump and PHP script for export to MySQL database

Interface languages

English German French Spanish Italian Danish Chinese Russian Portuguese Polish Greek Bahasa

Product Requirements

  • Necessary privileges to write into network shared folder (LAN or VPN) where destination database Excel resides
  • Microsoft Visual C++ 2008 x86 Redistributable package
  • Necessary privileges to write into database on the target MySQL server (this requirement is optional as there is an option to overcome the restrictions using dump file or PHP Script)

Latest News

  • Conversion for large databases is speeded up. Now 500 thousand records can be migrated in 3-5 min.
  • Variable quantization step added