Excel2MySQL Excel to MySQL by Alan Lilly

Excel2MySQL is a standalone freeware utility which can be used to load / import / convert excel spreadsheets into a MySQL database. This is the quickest and easiest way to convert excel to mysql. There are other solutions available to solve this problem, but I believe this solution is easier, quicker and cheaper than most.

Even though this utility is freeware, if you like it, I do ask that you watch some of my youtube videos and share them with your friends.

There is no need to install, it is a stand-alone exe.  Just download, unzip and run it. It does require that you have Microsoft Office or Microsoft Excel installed because it uses the “Component Object Model” API to interface with the spreadsheet.

If you find something better, please let me know

Download http://www.panofish.net/download/Excel2MySQL.zip

The program is fairly intuitive.
I don’t think there is a better excel to mysql converter / importer available, especially at this price (free)!  The current version of this application does not support Unicode characters yet (i.e. Japanese, Korean, Russian… etc.)

 

Can it connect remotely?

I use my Excel2MySQL tool and HeidiSQL to access MySQL databases on my local machine (127.0.0.1 or localhost), on my local network AND on remote host provider servers like my favorite Hostgator. It depends on your provider, but in my case (Hostgator), I have to add my remote ip address to an allow-access list which I can do myself through my hostgator account cpanel.  Then I can access my mysql database through standard tcpip port 3306.  I use my hostgator server ip address for my hostname, same as I would for http or ftp access.  And I use the same userid and password I would to access the mysql database… and again this is all easily configured through my hostgator cpanel.  Keep in mind that your remote ip may change from time to time and you will have to add the new ip address to the access list.  Hostgator provides a simple webpage to that displays your remote ip address if you don’t know it… http://www.hostgator.com/ip

Here is Hostgator’s excellently documented remote MySQL connection page.

Having trouble connecting?

There are many causes for failed connection errors like “2003 – Can’t connect to MySQL server”.  Sometimes, your connection can be blocked by your firewall or possibly virus softare, so make sure your MySQL port is open.  Sometimes you need to remove the default anonymous user account in your MySQL server, otherwise attempting to connect to localhost may fail for other user accounts.  Some MySQL configurations fail to connect with localhost, but port 127.0.0.1 will work instead.  Please let me know if you have a problem, I’d like to help :)

If you like my free program and want to support my efforts… you are welcome to donate any amount you like.

THANKS!

Watch this video to see how it works!

Comments

  1. ratnesh
    May 9th, 2014 at 17:03 | #1

    and saved on desktop as u shown in your video.

  2. May 9th, 2014 at 17:05 | #2

    Can you try with a simple xls file. No others have mentioned this problem, so there must be something unique at your end that is causing the problem. Can you provide more details? Try emailing the xls to my email panofish@gmail.com… I can test at my end.

  3. ratnesh
    May 9th, 2014 at 17:08 | #3

    of course…. i m sending it…

  4. ratnesh
    May 9th, 2014 at 17:16 | #4

    hey bro host means wht i m getting the physical address by cmd,,, which is not of that syntax

  5. ratnesh
    May 9th, 2014 at 17:23 | #5

    bro … u get it….

  6. ratnesh
    May 9th, 2014 at 17:29 | #6

    sorry for the misunderstanding,,, i had correctly fixed the ip add,as host,,, and sql port too….. but i still cant access drag and drop

  7. ratnesh
    May 9th, 2014 at 17:33 | #7

    and plz tell me which option is to be selected i n storage engine

  8. Ahmed
    May 10th, 2014 at 05:22 | #8

    I have problem with arabic languge (utf)format

  9. May 10th, 2014 at 12:00 | #9

    @Ahmed The current version doesn’t support unicode characters, BUT I am working on a much improved version that will fully support unicode characters (Arabic, Japanese, Chinese, Russian… etc…). It will also have command line support and is much much faster.

  10. Ch River
    May 12th, 2014 at 12:39 | #10

    hello,

    I have a problem with number to caracters … ex : ’901005380′ is transform in ’90100538′ the ultimat ’0′ is cut
    If the ultimat != 0 (1,2,3 etc) the transform is good !

    thanks.

  11. May 12th, 2014 at 12:58 | #11

    @Ch River Sorry about that… there must be a bug the number processing logic. I am currently working on a complete rewrite of the code which is a significant improvement and will also have greater speed, field optimization, command line support and unicode support, among others.

  12. David B
    June 12th, 2014 at 14:24 | #13

    Hi Alan,

    This looks like a great little tool for webhosts. I love it. Any plans to add UTF8 support? When?

    Thanks for making it avilable

  13. June 12th, 2014 at 14:29 | #14

    I am just now working on finishing a complete rewrite of the program and it now supports UTF8 AND fully optimizes field types AND is significantly faster AND supports command-line parameters for those that want to script or automate a solution. I hope to finish programming it in the next week or so.

  14. David B
    June 12th, 2014 at 15:19 | #15

    Awesome.. Look forward to it!

  15. David B
    July 2nd, 2014 at 13:25 | #16

    Hi Alan – Have you finished the rewrite? Does the download link on this page point to this latest version?

  16. xjshiya
    July 9th, 2014 at 21:38 | #17

    Hello,

    What if I want to upload those excel data to an “existing table” in my MySQL database? Can we rename the sheet name? Thanks.

  17. July 9th, 2014 at 22:28 | #18

    @xjshiya.. you can rename sheets in excel to whatever you like and that will be the table name to be uploaded to. If you uncheck the drop option, then the table with same name as sheetname will be appended to. Of course the field names are expected to match.

Comment pages
1 2 3 4 1150
  1. September 3rd, 2013 at 09:10 | #1
If you want a pic to show with your comment, get a gravatar!