Advanced ETL Processor can load Excel worksheet, table, or named-range data into MySQL by combining an Excel Reader with a MySQL Writer. This tutorial shows the basic flow: read the spreadsheet, map the fields, configure the MySQL target, and run the import.
What You Will Learn
- Configure an Excel Reader for a worksheet, table, or data range.
- Check Excel Reader properties before mapping fields.
- Configure the MySQL Writer target connection.
- Load the mapped Excel rows into a MySQL table.
Before You Start
Use a small workbook and a test MySQL table first. Excel files hide problems well: mixed formats, blank rows, and accidental headers are all easier to fix before the import is automated.
Excel To MySQL Docs
The Excel Reader documentation explains how Advanced ETL Processor reads data from an entire sheet, Excel table, or data range.
Review Excel Reader properties before mapping fields. The Ignore format option can help when spreadsheet formatting gets in the way, though not every format is supported.
If the workbook uses named ranges or formatted tables, check Working with Excel Tables and Ranges.
The MySQL/MariaDB Writer documentation covers the target setup. Its Writer properties include direct, SSL, and SSH connection options.
For a product-focused route, see Excel to MySQL import automation.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.