This tutorial shows how to convert Excel files into other formats in Advanced ETL Processor. Use it when Excel is the source, but the next system wants CSV, XML, QVD, SQL scripts, or something equally fussy.
What You Will Learn
- Read data from Excel sheets, tables, or ranges.
- Choose the right output format for the next system.
- Convert Excel data without opening the workbook manually.
- Avoid format surprises before the workflow reaches production.
Before You Start
Use a test repository or safe sample data while following the tutorial. Production jobs are a poor place to experiment.
Excel Conversion Docs
This tutorial uses the Excel Reader to extract workbook data before writing it into another format. In practice, start by checking whether the source data is in a sheet, table, or named range. Excel likes to hide structure in plain sight.
The supporting Excel Reader documentation covers reader properties, the ignore format option, and working with Excel tables and ranges.
Related conversion pages cover Excel to CSV, Excel to XML, Excel to QVD, Excel to Tableau Hyper, and Excel to SQL insert script.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.