How to import an excel file in to a MySQL database

mysql excel
Fero picture Fero · Aug 21, 2009 · Viewed 423.8k times · Source

Can any one explain how to import a Microsoft Excel file in to a MySQL database?

For example, my Excel table looks like this:

Country   |   Amount   |   Qty
----------------------------------
America   |   93       |   0.60

Greece    |   9377     |   0.80

Australia |   9375     |   0.80

Answer

d4nt picture d4nt · Sep 22, 2014

There's a simple online tool that can do this called sqlizer.io.

Screenshot from sqlizer.com

You upload an XLSX file to it, enter a sheet name and cell range, and it will generate a CREATE TABLE statement and a bunch of INSERT statements to import all your data into a MySQL database.

(Disclaimer: I help run SQLizer)

Related questions

How to save MySQL query output to excel or .txt file?

How do you save output of a MySQL query to a MS Excel sheet? Even if it's only possible to store the data in a .txt file, it will be okay.

Read More
Export MySQL data to Excel in PHP

I'm trying to get my MySQL data to Excel file, but I'm having problems with Excel cells. All my text goes to one cell, I would like to have each row value in separate Excel cell. Here is my code: $…

Read More
Exporting results of a Mysql query to excel?

My requirement is to store the entire results of the query SELECT * FROM document WHERE documentid IN (SELECT * FROM TaskResult WHERE taskResult = 2429) to an Excel file.

Read More