Importing data into mysql

hi

i need to import data into a table in mysql from phpmyadmin using the
Import option instead of using insert statements.

for example if the table has 10 fields should the file that needs to
be uploaded have the same field names on top and the associated values.

ideally should this be as an excel or csv file or text file.

in each case please advice the format in which the data needs to be
added into the csv/txt file.

please advice.

thanks.