phpmyadmin import database table from google spreadsheet

Question

I'm managing a small website, which allows people to register as members. Previously I used a google form to manage member registration, but now as the number of users becomes quite big I am switching to mysql. Currently I have around 500 members in the database, saved in a google spreadsheet. How can I do a bulk import from a google spreadsheet to a table in mysql? BTW I'm using phpmyadmin, so a solution for phpmyadmin is preferable :)
Thanks.

Answer 1

Now import the table query again, it will replace the dummy table you created before.

Answer 2

SQL is just plain readable text. Make a new table in PHPmyAdmin with the structure you want, two dummy entries and export the query for it to a .sql text file with a "drop table" mark. With the spreadsheet, export a comma-separated text file. Now cut and paste the parts from the csv file into the sql file, and adjust the number of fields in the SQL header. If needed use search and replace to match punctuation. Use Notepad++ (Smultron on a Mac) for easy editing of .sql files. You can use 2 search and replace actions to convert the CSV to SQL

replace , with ','

replace return with ');INSERT INTO tablename fieldname1,fieldname2) VALUES (

Then copy paste the edited list into the dummy SQL query.

Now import the table query again, it will replace the dummy table you created before.