Quickly convert MS Excel files in to MySQL tables
Xls2mysql is an online tool to convert MS Excel (.xls only) files to MySQL tables, simply browse to locate the file on your local storage, and then click on the ‘Submit Query’ button, as shown below.
Later in second step, it will extract the column names from the excel file to make the same columns in MySQL table, also it allows you to choose the datatype for the elements in particular column. It can also pickup the datatype which you have set in the excel, for example date.
Sample excel
MS Excel files to MySQL
Later simply click on the ‘Create the PHP code!’ button, and soon it will give you the code, use it to get the MySQL table, as shown below.
Code for MySQL table, converted from Excel
Xls2mysql is a nice online tool, and probably the easiest way to create MySQL tables using the MS Excel file.
Related posts:
Posted on 31st March 2010 by Manav Mishra , here to write articles about things which are somehow related to computers, internet (and at times, may be, to blogging as well). He wants to make an Identity for himself, he loves, testing new softwares and services which can really help to improve the productivity of individual. All posts by Manav Mishra | Connect with me @Twitter | Stumble | Facebook
So do i have to upload afterward, or does this plugin auto compile into my existing database
@Christian You will have to manually upload it.
Good one. Thanks for sharing.
-Sriram
Stay Updated
Popular Now
Topics
Browser Extensions
Best Guides
An impressive and easy to understand website which brings you productive applications, online tools, Windows and helps you better understand how you can use your computer, mobile and internet in a right way.