Import CSV into MySQL
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Read Binary File. 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 4 nodes and runs manually, when you click “Execute workflow”. Along the way it connects MySQL.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Read From File (Read Binary File): uses Read Binary File
- Convert To Spreadsheet (Spreadsheet File): reads or writes a spreadsheet file (legacy node)
- Insert into MySQL (MySQL): uses MySQL
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Read Binary File in Read From File: replace with Read/Write Files from Disk.
- Also check Spreadsheet File: Convert to File / Extract from File.
| Removed in 3.0 | Replace with |
|---|---|
| Read Binary File Read From File | Read/Write Files from Disk |
Nodes used (4)
- Manual Trigger
n8n-nodes-base.manualTrigger - Read Binary File
n8n-nodes-base.readBinaryFile - Spreadsheet File
n8n-nodes-base.spreadsheetFile - MySQL
n8n-nodes-base.mySql
From the author
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:…