How Can I Easily Import an Excel File into My MySQL Database?

Importing an Excel File into a MySQL Database

Importing an Excel spreadsheet into a MySQL database is a straightforward process that can be accomplished through a range of methods. One of the most convenient and efficient approaches is utilizing the sqlizer.io online tool.

sqlizer.io

sqlizer.io simplifies the data import process by requiring only a few steps:

1. Upload XLSX File: Upload the Excel file containing the data you wish to import.
2. Enter Sheet Name and Cell Range: Specify the sheet you want to import and the cell range containing the data.
3. Generate SQL Statements: sqlizer.io will generate a CREATE TABLE statement and multiple INSERT statements to create the necessary table and import the data into it.

Once the SQL statements are generated, you can execute them in your MySQL database using a command line tool or a database management application such as MySQL Workbench.

Example

Consider the following Excel table:

| Country   |   Amount   |   Qty
----------------------------------
| America   |   93       |   0.60
| Greece    |   9377     |   0.80
| Australia |   9375     |   0.80

Using sqlizer.io, you can import this data into a MySQL database by generating the following SQL statements:

CREATE TABLE excel_data (
  Country VARCHAR(255),
  Amount INT,
  Qty FLOAT
);

INSERT INTO excel_data (Country, Amount, Qty) VALUES
('America', 93, 0.60),
('Greece', 9377, 0.80),
('Australia', 9375, 0.80);

By executing these statements, you can create the excel_data table and populate it with the data from the Excel spreadsheet.

The above is the detailed content of How Can I Easily Import an Excel File into My MySQL Database?. For more information, please follow other related articles on the PHP Chinese website!