Home > Documentation > MS Excel to MySQL

Command line version of MS Excel to MySQL converter

To perform batch conversion or call the conversion procedure from an automation script you can use console version of Excel-to-MySQL X2SAGENT.EXE. Find this file in Excel-to-MySQL installation folder. You can either run this tool directly from command line or call it from any script as well. The program supports the following command-line options:

Notes:

1. You can omit 'host' parameter to connect local MySQL server
2. It is necessary to specify 'port' parameter only if it differs from the default MySQL port 3306
3. If you omit 'tab_file' parameter, all worksheets will be converted
4. If you omit 'mode' parameter, default mode will be used (it is 'overwrite the entire database' when converting xls file or 'overwrite existing tables only' when converting csv file)
5. Command line parameters that contain spaces should be enclosed in quotes (for example --dest="my database")

Sample 1. The program converts MS Excel spreadsheet "c:\book1.xls" to MySQL database "book1_from_excel" on the remote MySQL server "mysqlhost" using table names file "c:\tabfile1.txt":

X2SAGENT.EXE --src=c:\book1.xls --dest=book1_from_excel --host=mysqlhost 
--user=administrator --pswd=the_passsword --tab_file=c:\tabfile1.txt

Worksheet names file should be formatted as follows:

Table_1
Table_2
...
Table_N


Sample 2. The program converts CSV file "c:\sheet1.csv" to MySQL database "Northwind" on the local MySQL server:

X2SAGENT.EXE --src=c:\sheet1.csv --dest=Northwind --tab_name=sheet1 
--user=administrator --pswd=the_passsword --from_csv --extr_fn --csv_delim=2

MySQL character sets

This parameter specifies correct encoding of text values in the destination MySQL database. It can have one of the following values:

Please refer to MySQL documentation to better understand the concept of character sets and collations.