Converting Your Excel Worksheet into a Working MySQL Database
Microsoft Excel is the world’s most popular and common spreadsheet office applications software. It is used to store and manipulate data in engineering, IT and business sectors. Thanks in part to the popularity of the Internet and certain kinds of web sites, many business owners find that they need to convert their Excel spreadsheets into proper MySQL databases. This article will show you how to do this, without forcing you to purchase additional software.
Background and importance
Business owners often define their data using MS Excel because it is common and easy to manipulate. When they want to convert their MS Excel workbook into a working MySQL database, however, problems arise. For a database to be used in a dynamically-driven website, as is frequently done today, it needs to be in a MySQL file extension; otherwise, it will not work. MySQL is the most popular open source database and commonly used in conjunction with the PHP scripting language to command website operations, as in E-commerce websites.
An important database in Excel that can be exported into MySQL can be anything a website owner or developer can think of, from a price list database to customer information to contact information; virtually anything you find important enough to store in MS Excel also means it’s important to put it in a MySQL database.
When you are a beginner or unfamiliar with MySQL, if you do a search in Google for “Convert MS Excel to MySQL” you will find that the top search results are for programs or software for sale. This means it will cost you to convert. The objective of this tutorial is to teach you the basics of how to convert or export a database in MS Excel into a working MySQL database without ever spending any money out of your pocket.
Let us discuss the database basics.
Virtual Server users option
- ask your Virtual Server administrator to create blank database for
- run Excel-to-MySQL and select this database as the conversion
- click "Yes" when you will be asked if you'd like to overwrite
existing MySQL database
How to Use:
MS Excel to MySQL Converter
Free to try
Upcoming Open Source Release
Convert only two columns from XLSX to MySQL
"c:\Program Files\Advanced XLS Converter\xlscnv.exe" sample.xlsx sample.sql /COLUMNS:NAME,STREET /MYSQL
Convert folder with XLS files to MS SQL
"c:\Program Files\Advanced XLS Converter\xlscnv.exe" d:\base\*.xls d:\out\ /MSSQL /TOSQL
MySQL for Excel now provides a way to edit a MySQL table's data directly within Excel using a new worksheet as a canvas to update existing data, insert new rows and delete existing ones in a very friendly and intuitive way. Changes are pushed back to the MySQL Server as a transaction batch with the click of a button, or can be pushed as soon as they are done with no further clicks if users prefer it. This is a powerful feature since Excel is a natural user interface to operate with data, and these changes can be reflected in the database immediately.
Learn more »