Import CSV into MySQL

My SqlRead Binary FileSpreadsheet File

Nodes 4

Complexity Intermediate

Category Engineering

n8n popularity 13,484 views in n8n library

This workflow demonstrates how CSV file can be automatically imported into existing MySQL database. Before running the workflow please make sure you have a file on the server: /home/node/.n8n/concerts-2023.csv And the content of the file is the following: Date,Band,ConcertName,Country,City,Location,LocationAddress, 2023-05-28,Ozzy Osbourne,No More Tours 2 - Special Guest: Judas Priest,Germany,Berlin,Mercedes-Benz Arena Berlin,"Mercedes-Platz 1, 10243 Berlin-Friedrichshain", 2023-05-08,Elton John,Farewell Yellow Brick Road Tour 2023,Germany,Berlin,Mercedes-Benz Arena Berlin,"Mercedes-Platz 1, 10243 Berlin-Friedrichshain", 2023-05-26,Hans Zimmer Live,Europe Tour 2023,Germany,Berlin,Mercedes-Benz Arena Berlin,"Mercedes-Platz 1, 10243 Berlin-Friedrichshain", 2023-07-07,Depeche Mode,Memento Mori World Tour 2023,Germany,Berlin,Olympiastadion Berlin,"Olympischer Platz 3, 14053 Berlin-Charlottenburg", The detailed process is explained in the tutorial https://blog.n8n.io/import-csv-into

Apps and nodes included

My Sql
Manual Trigger
Read Binary File
Spreadsheet File

Step-by-Step Implementation Guide

Importar CSV a MySQL

Este workflow demuestra cómo importar automáticamente un archivo CSV a una base de datos MySQL existente.

Nodos Utilizados

MySQL: Conecta y escribe datos en una base de datos MySQL.

Pasos de Configuración

Paso 1: Configura la conexión a tu base de datos MySQL.
Paso 2: Asegúrate de tener un archivo CSV accesible en el servidor n8n.
Paso 3: Ajusta la configuración del nodo MySQL para especificar la tabla y la estructura de las columnas.

⚡ Open and edit in Scriflow ← Browse all n8n templates

Scriflow builds and adapts n8n workflows with AI. Open this template in the editor to get the import-ready JSON.