How to convert excel to mysql

Question

Hello guys, does anyone have an idea of how to convert an excel data file into a mysql database?

Answer 1

Export it into some text format. The easiest will probably be a tab-delimited version, but CSV can work as well.
Use the load data capability.
Look half way down the page, as it will gives a good example for tab separated data:

FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\'
Check your data. Sometimes quoting or escaping has problems, and you need to adjust your source, import command-- or it may just be easier to post-process via SQL.

Answer 2

Thanks Lopez. let me try that out.