Thursday, November 22, 2007

How to import CSV file to MySQL using phpMyAdmin

Here's one way to get your Excel file into MySQL via phpMyAdmin:
(NOTE: make sure your table on MySQL has the same number of columns as the excel file):

1. Export your .xls file to .csv and remove the first line (column names)
2. Launch phpMyAdmin -> select table

Import ->
Location of text file ->
CSV using LOAD DATA ->
Fields terminated by [,] ->
Fields enclosed by [ ] ->
Fields escaped by [ ] ->
Lines terminated by [\r] -> Go
Comments (7)
Anonymous SuriG said...

Thank you! Wonderfully simple explanation after hours of surfing through incomprehensible techspeak - I knew I was nearly there and \r finally did it. Thank you again!

Monday, May 26, 2008 2:31:00 PM

 
Blogger admin said...

Your very welcome SuriG -- glad to hear it helped! :-)

Monday, May 26, 2008 2:47:00 PM

 
Anonymous Zebedee said...

Cheers. Perfect.

Wednesday, June 18, 2008 8:16:00 AM

 
Anonymous Anonymous said...

Awesome! I, too, waded through hours of jargon-filled explanations. Thanks for such an easy tip!

Saturday, June 21, 2008 11:43:00 AM

 
Blogger Sarah Ann said...

Thank you! This was very helpful for me as well!

Friday, August 08, 2008 10:18:00 AM

 
Anonymous Anonymous said...

Give that man a medal!
Thank you.

Wednesday, September 10, 2008 5:49:00 PM

 
Anonymous Anonymous said...

Again your awesome. Thanks a ton.

Thursday, November 06, 2008 4:03:00 PM

 

Post a Comment