Import CSV Files into MySQL in 5 Easy Steps

How to import csv files into MySQL Workbench

·

1 min read

Step 1: Open Table data import wizard

Make sure you are in the schema you want to import the table to.

Right-click on the schema name and select Table Data Import Wizard.

Step 2: Select the file to import

With the Table data import wizard opened, browse to where your CSV file is located then select it and click next.

Step 3: Select Destination

Select the destination of your table. You can rename the table if you like, Or use an existing table. Select drop table if exists to avoid errors and click next.

Step 4: CSV configuration

Configure import settings, you can change the data type of any field using the drop-down arrow in the field type then click next.

Step 5: Import data

Click next again for the importation to start

The time it takes depends on the size of your dataset.

The message log shows what's happening under the hood. Check for any error messages on it.

Once the importation is complete, as shown below click next and complete the process.