The Column Options area is located below the preview grid. When you click each column header of the preview grid, you see the option values for the selected column. Some values are set by default: Column Name, Data Type, and so on. If a column option does not apply to the selected column or if the value cannot be changed, the option appears dimmed.
Useto modify the default behavior of the options that apply to all columns intended for export to a MySQL table.
MySQL for Excel analyzes and detects the data type of each column by default; however, you can override the detected value by selecting a different data type from the drop-down list. To reset a column back to the detected value, right-click within the Data Type field and select Reset to auto-detect, as shown in the figure that follows.