This tutorial shows how to extract data from very complex Excel files in Advanced ETL Processor. Use it when a workbook has awkward blocks, repeated sections, merged layouts, or sheets that are not shaped like a clean table.
What You Will Learn
- Mark and reshape useful blocks inside complex Excel files.
- Convert awkward workbook layouts into a simpler structure.
- Prepare extracted Excel data for downstream transformations.
- Decide which block transformation tools fit the workbook layout.
Before You Start
Use a test repository or safe sample data while following the tutorial. Production jobs are a poor place to experiment.
Block Transformation Docs
Block transformation is used to turn complex Excel layouts into simpler, usable data blocks before the data is loaded or exported.
The related block transformation docs include Mark Data Blocks, Custom Data Block, Combine Data Blocks, Rotate Data Block, Select Columns, Reorder Columns, Edit Columns, Split Column, Join Columns, Sort Columns, Filter Rows, Pivot Data Block, UnPivot Data Block, and Write Excel File.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.