Azure Data Factory Supports Excel Files

Excel format in Azure Data Factory. A welcome addition to ADF!

When adding an ADF DataSet:

I am convinced they got tired of me saying, “Well, you’ll need SSIS if you want to read Excel…” Probably not, though. Either way… score! :{>

Need Help Migrating to Azure?

Enterprise Data & Analytics specializes in helping enterprises modernize their data engineering by lifting and shifting SSIS from on-premises to the cloud. Our experienced engineers grok enterprises of all sizes. We’ve done the hard work for large and challenging data engineering enterprises. We’ve earned our blood-, sweat-, and tear-stained t-shirts. Reach out. We can help.

Enterprise Data & Analytics

Andy Leonard

andyleonard.blog

Christian, husband, dad, grandpa, Data Philosopher, Data Engineer, SSIS and Biml guy. I was cloud before cloud was cool. :{>

4 thoughts on “Azure Data Factory Supports Excel Files

  1. Andy, were you able to use that Excel file as a source in ADF? I managed to get my files created and linked. I can preview them, but can’t seem to select them as a source in my ADF. It’s great that there’s an option, but not sure how to actually _use_ it now.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.