Features

Features

Excel2MySQL is very robust and boasts a wide variety of features.

  1. Stand-alone application, means nothing to install
  2. Supports ALL versions of Microsoft Excel
  3. Does NOT require Microsoft Office or Excel installation
  4. Fully Functional Free Trial, EXCEPT some random records will load as Null until you purchase a license
    This way you can verify it will suit your needs before spending your money.
  5. Reliable. Excel2MySQL has been thoroughly tested and used by many over the years (since 2013)
  6. Supports international unicode characters (e.g. English, Japanese, Arabic, Russian... etc)
  7. Speed, accuracy, simplicity (see below)
  8. Supports scriptable Command Line parameters which enables batch automation
  9. Supports secure encrypted SSL connection with MySQL server
  10. Imports all worksheets from Excel file into tables
  11. Append or Replace existing MySQL data
  12. Automatically detects and adds new fields during append to existing table
  13. Ability to unmerge merged cells
  14. Automatic column type optimization
  15. Auto calculates column width
  16. Localhost or Remote MySQL server updating
  17. Supports MySQL Innodb or MyISAM
  18. Compatible with all versions of Unix and Windows MySQL servers

Intuitive Iinterface

Excel2MySQL has an intuitive and easy to use user interface. Most products in this category have chosen a tedious wizard interface with many confusing choices. Excel2MySQL fully automates the conversion process while still providing complete control over important decisions.

Accuracy

Excel2MySQL is incredibly fast, but what good is speed if your data isn't imported correctly?
With Excel2MySQL you get speed and accuracy. Excel2MySQL does the best job of importing your data accurately while correctly optimizing field types and sizes.

This small Excel file is difficult for most importers to handle. Download it and try with another importer. Few converters will import it correctly and none will optimize the fields correctly.


Speed

Excel2MySQL is not only the most accurate tool in its class, it's also very fast.

We imported the same Excel spreadsheet containing 18884 records and 31 columns into MySQL using many competitors and here are the results (measured in seconds).

Download and try this spreadsheet with your own machine and software for comparison.

Platform: 2013 Mac Pro with Intel Xeon E5-1620 v2 @3.70GHz + 16.0GB Ram Running Window 8


Measured in seconds
Shorter is better

Best in Class

Excel2MySQL is just what you're looking for when it comes to importing Excel data into MySQL...
Accuracy, Speed, Simplicity and Flexiblity. If you know of a better solution for transferring Excel into MySQL, we'd love to here from you.