site site-navbranch.xsl site

Skip to main content.

Looking for PowerPoint and/or Google Analytics solutions? Please follow the above links to

section no_callout.xsl no_callout

page static_html.xsl exceletl

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