This tutorial shows how to split a large CSV file into multiple Excel worksheets in Advanced ETL Processor. Use it when one CSV file needs to become a workbook with separate sheets instead of one very long worksheet having a bad day.
What You Will Learn
- Read a large CSV source file.
- Split rows into separate Excel worksheets.
- Use Excel Writer settings for sheet-based output.
- Avoid manual workbook splitting when the source file changes.
Before You Start
Use a test repository or safe sample data while following the tutorial. Production jobs are a poor place to experiment.
Excel Writer Docs
This tutorial writes rows from one large CSV file into multiple Excel worksheets. In practice, this is useful when the source file is too large or too mixed for one worksheet to stay readable.
The supporting Excel Writer documentation covers working with Excel sheets, creating a new Excel file, adding data into an existing Excel file, cell formatting, and Excel Writer notes.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.