Have an excel file with the information. The excel file cannot have any additional information like labels or headers.
Save the file as
CSV
(MS-DOS)
In myphpadmin
select import
browse to the file
uncheck the box for partial import (we don't want a partial import)
change 'Fields terminated by' to a comma.