import csv file into mysql with custom data change

I have a .csv file contains data like this:

Username   Password   Email
test123    123        test@foobar.com

I'm currently using MySQL, and I have a table named user with some columns like this:

UserID    Username    Password    Email

What i'm looking for is how can I import my csv data into user table and convert password column with MD5 method so what I have at the last is

UserID    Username    Password                          Email
1          test123     202cb962ac59075b964b07152d234b70  test@foobar.com

NB: I have a hundred record in my csv file. Any help please. Thanks for advance.