phpMyAdmin 3.4.2 setup

Customize import defaults

Format of imported file
Character set of the file
Partial import: allow interrupt
Partial import: skip queries

SQL compatibility mode
Do not use AUTO_INCREMENT for zero values

CSV
Replace table data with file
Do not abort on INSERT error
Columns terminated by
Columns enclosed by
Columns escaped by
Lines terminated by
CSV using LOAD DATA
Replace table data with file
Do not abort on INSERT error
Columns terminated by
Columns enclosed by
Columns escaped by
Use LOCAL keyword

Excel 97-2003 XLS Workbook
Column names in first row
Excel 2007 XLSX Workbook
Column names in first row

Open Document Spreadsheet
Column names in first row
Do not import empty rows
Import percentages as proper decimals (12.00% to .12)
Import currencies ($5.00 to 5.00)