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
(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
posted by admin at 1:51 PM
permalink
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!
Your very welcome SuriG -- glad to hear it helped! :-)
Cheers. Perfect.
Awesome! I, too, waded through hours of jargon-filled explanations. Thanks for such an easy tip!
Thank you! This was very helpful for me as well!
Give that man a medal!
Thank you.
Again your awesome. Thanks a ton.
Thank you! This was a BIG help.. I have a small problem now, what if some of my fields already have commas within the entries - how would i go about fixing that?
I'm amazed this helped everyone so well. Eveyone shows the command to load the file but no one shows an exaple of what the fiile should look like. Does anyone care to show an example of what the file should look like? (the file that you are importing)
You are probably the only man who knows how to import csv data. Thanks a ton. Can u pl. tell me the reason for using /r in the field "Lines terminated by". Thanks a ton again.
Thanks for the post!!! you have saved me lots of time dude!!!!
Beautiful!
thanks! much appreciated
great!!!
thanks a lot for this men...
:D
Seriously, you don't know how many people have been challenged with problem, and you made it look so simple. It's a gift i guess. Thanks, you're the Best...
Thank you dude. Been looking around on how to solve this. Save me a lot of time