CODEWITHSUNDEEP
mysqlexcelimport
Vincenzo Nerone
Vincenzo Nerone

Reputation: 1

Importing Excel files to MySQL

I need to import an Excel file to MySQL but I can't find an appropriate way to do it. It has like 20 columns and 80k rows. Could someone help me please? I'm trying to build a portfolio project on it... Thanks!

Upvotes: 0

Views: 1293

Answers (1)

Deian
Deian

Reputation: 1374

Save the excel file as CSV and then import it into mysql.

Example: https://phoenixnap.com/kb/import-csv-file-into-mysql#:~:text=1%20Import%20CSV%20File%20Using%20Command%20Line.%202,4%20Step%203%3A%20Import%20CSV%20into%20MySQL%20Table.

Upvotes: 1

Related Questions