CSV File Bulk Data Importer to MySQL Database - n8n Workflow

Data Engineers and Analysts needing fast ETL solutions.
Users running self-hosted n8n instances requiring local file system access.
Developers looking for reliable n8n templates for database synchronization.
Anyone seeking efficient methods to use an n8n node for high-volume database operations.

Data migration and ingestion remain core challenges for system administrators. This reliable n8n workflow solves the problem of integrating large, local CSV files into a relational database quickly and efficiently. By combining the file reading capability of a dedicated n8n node with the powerful transformation features of the Spreadsheet File node, the data is perfectly structured before hitting the MySQL database.

This particular n8n workflow is designed for speed and reliability, making it one of the most useful n8n templates for scheduled or manual data imports. It ensures structured data integrity when interacting with your database backend.

This n8n workflow executes a streamlined four-step data pipeline:

1. Initiation: The process begins with the Manual Trigger n8n trigger, allowing the user to initiate the import manually whenever new CSV data is ready.


2. Extraction (Read File): The Read From File n8n node accesses the CSV file located on the local n8n server’s filesystem (/home/node/.n8n/concerts-2023.csv), extracting the binary content.


3. Transformation (Parse CSV): The data is immediately passed to the Convert To Spreadsheet n8n node. This crucial step parses the binary file into structured JSON items, preparing the data fields for SQL insertion.


4. Loading (MySQL Insert): Finally, the Insert into MySQL n8n node executes a bulk insert operation. It takes the structured JSON items and maps them directly into the target database table (concerts2023csv), completing the entire n8n workflow.

To deploy and utilize this efficient n8n workflow, follow these steps:

1. Import: Copy the n8n workflow JSON and paste it into your n8n editor via the 'New' menu -> 'Import from JSON'.


2. MySQL Credential Setup: Open the 'Insert into MySQL' n8n node and configure your required MySQL credentials, referencing the stored credential ID (e.g., 'MySQL n8n articles').


3. Local File Preparation: Ensure that the CSV file you wish to import (e.g., concerts-2023.csv) is placed in the specific location defined in the 'Read From File' n8n node (/home/node/.n8n/concerts-2023.csv). Note: This path assumes a self-hosted n8n environment setup.


4. Execution: Click the 'Execute Workflow' button on the Manual Trigger n8n trigger to run the process and verify that data has been successfully imported into your MySQL table.

On clicking 'execute' (Manual Trigger n8n trigger): Serves as the starting point for the n8n workflow, executing the import on demand.
Read From File (Read Binary File n8n node): Essential for accessing data stored locally on the n8n server. Key configuration: File path set to /home/node/.n8n/concerts-2023.csv.
Convert To Spreadsheet (Spreadsheet File n8n node): Responsible for turning the raw binary file content into usable, structured data items (JSON format). Configuration ensures raw data is read as strings for reliable type handling.
Insert into MySQL (MySQL n8n node): The final action n8n node. It is configured to perform an insert operation into the table concerts2023csv, mapping specific columns: Date, Band, ConcertName, Country, City, Location, LocationAddress. Requires valid MySQL credentials to function.