Load Thousands of Excel Data into MySQL

Teguh Arief

Sep 24, 2020

Share article to

Illustration of Excel data into MySQL.

This is probably nothing new to many people, but I spent quite some time to figure it out so I thought I’d post my notes on it. To load thousands data from Excel into MySQL is very simple in 4 easy steps. How many Columns, its position, and Column type in MySQL Table structure.

Excel Data Thousands of Excel Data

MySQL Table MySQL Table structure

  1. Align many Columns and its position in MySQL Table structure

  2. Adjust Column type in MySQL Table structure, replace letters with a number

  3. Save as Excel Data with .csv

  4. Import the .csv File into MySQL Table

Related Posts