How to Import Excel Data Into MySQL Table

Transfer Excel data to MySQL very easily. No need to convert to CSV or jump through hoops. This will save you hours of work, and frustration.

[deongovender]

This was such a huge help!!, thank you

[deckearns]

I wish I could like this video more than once. It has been so very helpful, and so very well explained in an uncomplicated way. Thank you so much.

[AbdulRehman-qthu]

this video was such a life saver, thank you very much.

[cineverseproductions]

Thanks a lot, man. It worked for me. Appreciated.

[sevenadams]

Thanks for the video, it also worked for me. I tested it with multiple sheets and it happens that each will be considered as a separate table. 1 thing to take note is that if you enter values in certain cells and delete the entries, excel somehow keeps them as important to your worksheet but just empty, when you import to database, the empty cells will also be imported and you will end with more columns with letter names and null as rows. Excluding importing null values fails

[kasunkumarasinghe]

omg, you are so amazing. just what I was searching for.... thank you

[algercomalekmalki]

Very good. No need to buy a special app to do the job. By the way I suppose that saving it in the doc format strip the file from all the information that makes an excel file . Just like exporting it to a cvs format then importing it to the MySQL workbench.
Great video, thank you !

[luisluiscunha]

Nice video, great voice, man. You should do more online courses... wow

[SMILE-ziir]

hello sir, what about after connecting it on mysql table, why not to try to connect it the pycharm?

[solomonaiyede]

this video is amazing. Thanks so much.

[naveenkumarnaidu]

Does it's store only some amount data or we can import 1lakh also

[juliennapoli]

Nice, I'll think about this later

[FaizAnsari-buho]

Hey your video helped me a lot. Thanks Bro

[juanserranos]

Thanks for the video sir. Now, the only thing is that I have a table already created; - and using the method that you show in the video. The file is imported, but a whole new table is created, the data is not added to the table I select.
Why this could be happening?

[prasunjeetsoni]

bt what happend we have already more than a table and we just wanted to add a record to table 1 not in table 2 in that case we dont have any table selection option here .. what we do for this??

[salaheddinemakkaoui]

You attempted to load file with unsupported compression (application/zip). Either support for it is not implemented or disabled by your configuration.

[TheMotassam]

Thank you for this video. i am tried to find the correct solution to import ARABIC data into mysql data bas. THANK YOU ALOT

[mikha]

hello sir thankyou for the tutorial. it works!