Jump to content


This topic is now archived and is closed to further replies.


Excel to MySQL Database

Recommended Posts


I couldnt find a script/program anywhere to convert my .xls of 100ish users into a MySQL format to upload to my SQL database.

I wrote a php script that will take take your .xls (Im not that good with MS-Office - its just a list of usernames, names and passwords) and put it into the following format:-

INSERT INTO '[tablename]' VALUES ('your', 'xls', 'document', 'details');

I think this is the correct format if you are able to use the SQL feature of phpMyAdmin. This will loop through all your entries of your .xls file. Just make sure your .xls document is in the correct order of your database.

Would this be any good for anyone else? Or please let me know of what other people use so I can improve on my part. Im just a beginner so any comments would be appreciated.



Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.