How to import xls in phpmyadmin

Environment

phpmyadmin character set utf8_general_ci
excel 2013 export csv character set ansi (gb2312) delimiter (English comma)

Steps

• Export a csv file with comma as the content delimiter.

• Use ultraedit to open the exported csv file. The string at this time should be gbk/gb2312 and saved as utf8-no bom

• phpmyadmin Select Import, use the default utf8 character set, replace all field delimiters and content delimiters with English commas, and click Import.

• Import completed.

Problems encountered

The character set is incorrectly selected, resulting in all garbled characters being imported (including utf8-bom) The content delimiter is incorrectly selected As a result, the import format fails or a format error is prompted halfway through the import, and the import fails.

Recommended tutorial: "phpmyadmin tutorial"

The above is the detailed content of How to import xls in phpmyadmin. For more information, please follow other related articles on the PHP Chinese website!