ExcelETL: Extraction, Transformation, and Loading with Excel

Excel ETL is a Microsoft Excel-based ETL solution. In several of our project, we have had the need to take data received in Excel or CSV format and send this data to a data warehouse staging database. Excel ETL is a generic framework for accomplishing this task.

Several modules comprise Excel ETL

• An XML configuration file which captures the requirements of the data staging process
• An Excel add-in with which the user interacts
• A staging database generator
• A web service middle tier

These modules combined allow a user to

• Manually or automatically map Excel columns to database fields
• Validate the sheet against the constraints of the database
• Cleans and conform strings and flags
• Upload the sheet to the staging database