CX Optimization Agency Message Testing Blog Search Start 7-day trial for $1 Upskilling Playbooks Teams Community Find a job Resources Help

Import and export data using CSV file in MySQL workbench

Use case

Minimize tedious custom scripting tasks.

Upgrade for unlimited access to thousands of playbooks on increasing traffic, improving ROAS and more.

Start 7-day trial for $1

1. Check that the table column and CSV file column data types match before importing the CSV file.

The import wizard will not work correctly if the data types do not match.

Join the discussion on how to complete this step.

2. Navigate to Schemas, expand Tables, right-click the table to import the date into, and click Table Data Import Wizard.

Join the discussion on how to complete this step.

3. Enter the file path to or browse for the CSV file to import it into the current table.

Join the discussion on how to complete this step.

4. Check the configuration settings to make sure the data types are correct and both the CSV file and table column data match, click Next, and check for the green ticks next to Prepare Import and Import data file in the Table Data Import wizard to ensure the import worked.

Join the discussion on how to complete this step.

5. Create a new CSV file with defined table columns, or use an existing file, navigate to Schemas, right click Tables, and click Table Data Import Wizard if you want to create new tables directly from CSV files to save time.

The only difference between importing data into a table and creating a new table is clicking Create New Table and ticking the Drop table if exists in the Table Data Import wizard.

Join the discussion on how to complete this step.

Current Playbook:

Import and export data using CSV file in MySQL workbench

Oct 24, 2021

0 votes

Request a playbook

Get unlimited access

Thousands of playbooks on increasing traffic, improving ROAS and more.

Start 7-day trial for $1