Software for Excel to MySQL Import
We tested many products for importing Excel into MySQL. This chart shows 4 established products..| Product | Excel2MySQL |
SpectralCore |
Oracle MySQL for Excel |
NaviCat for MySQL |
| Auto calculate column width |
|
|
||
| Optimize field types |
|
|
||
| Stand-alone exe | |
|
||
| International unicode character support |
|
|
||
| Load multiple sheets |
|
|
||
| Command Line Interface Conversion |
|
|
||
| Excellent Documentation |
|
|
||
| Accurate | |
|||
| Unmerge merged cells |
|
|||
| Detect and add new coloumns during append to existing table |
|
|||
| Works with all versions of Excel | ||||
| Support for SSL | ||||
| Quick, Easy and Intuitive |
|
|
||
| Time to Load 18884 rows 31 cols |
17 secs |
156 secs |
82 secs |
10 secs |
| Price | $300 |
Free |
$100+ |