MySQL

Categories:

Import Excel/CSV into MySQL

To import an Excel file into MySQL, first export it as a CSV file. Remove the CSV headers from the generated CSV file along with empty data that Excel may have put at the end of the CSV file.

You can then import it into a MySQL table by running:

md5 of "password"

password

5f4dcc3b5aa765d61d8327deb882cf99