How to export excel data into Mysql tables

Question

How can we export Excel data into Mysql table. Is there any plugIn in excel for converting data into mysql table or in any other methods?

convert your excel into csv file then use phpmyadmin import options, your csv file should have equal number of columns as in table — Afsar, Jan 28 '16 at 10:54
Possible duplicate of [How to import an excel file in to a MySQL database](http://stackoverflow.com/questions/1310166/how-to-import-an-excel-file-in-to-a-mysql-database) — RyanfaeScotland, Jan 28 '16 at 11:20

score 1 · Answer 1 · answered Jan 28 '16 at 10:57

1

You can read and write by this. and also store data to your sqlite database table from .xls files cell.

answered Jan 28 '16 at 10:57

Vishal Patoliya ツ

3,170
4
24
45

score 0 · Answer 2 · answered Jan 28 '16 at 11:01

0

You need to save your data in CSV format(comma separated values) format in a file then you can use LOAD DATA command to load the data from file to table

Example -

LOAD DATA INFILE 'path_of_file' INTO TABLE 'name_of_table'

more information on load data can be found in MySQL manuals available online

answered Jan 28 '16 at 11:01

Ankit Tripathi

405
4
13

Over your MySQL workbench console or query execution client – Ankit Tripathi Jan 28 '16 at 11:13

score 0 · Accepted Answer · edited May 23 '17 at 12:04

0

Convert your Excel to CSV first then import in phpmyadmin. The number of columns in csv should be equal to number of columns in table, If you have auto increment for first column then leave first column of CSV blank.

IF you dont use phpmyadmin this or this will help you out with import.

edited May 23 '17 at 12:04

Community

1
1

answered Jan 28 '16 at 11:12

Afsar

3,104
2
25
35

Is there any direct plug in for exporting excel into mysql table? – Bibin Jose Jan 28 '16 at 11:16
what are you on , Mac or PC ? – Afsar Jan 28 '16 at 11:17
Windows machine, /i mean any plugin in excel for doing that? – Bibin Jose Jan 28 '16 at 11:17
There are many , it depends on how you want to use it , see attached links it have lot of other info which may help you – Afsar Jan 28 '16 at 11:21
This is helpful for me. – Bibin Jose Jan 28 '16 at 11:23

score 0 · Answer 4 · answered Jan 28 '16 at 11:20

In case you convert Excel into CSV, then there is a way for bulk export:

query = "LOAD DATA INFILE '"+"\\FileName.csv"+"' INTO TABLE Table_Name  FIELDS TERMINATED BY ',' (Column_Name,....)";

Make sure, you match the table columns with the file(.csv) columns, to avoid error.

How to export excel data into Mysql tables

4 Answers4