Excel as a source in ADF

Question

Hello,

Can we connect directly excel file from a system as a source to ADF without using any blob storage linked services?

Regards.

Answer 1

Hello @Punit Parmar ,

Welcome to the Microsoft Q&A platform.

Azure Data Factory supports both ".xls" and ".xlsx".

Excel format is supported for the following connectors: Amazon S3, Azure Blob, Azure Data Lake Storage Gen1, Azure Data Lake Storage Gen2, Azure File Storage, File System, FTP, Google Cloud Storage, HDFS, HTTP, and SFTP. It is supported as the source but not a sink.

Note: ".xls" format is not supported while using HTTP.

Reference: Excel format in Azure Data Factory

In case if your file is located on the local machine, you can use File System connector.

Hope this helps. Do let us know if you any further queries.

------------

• Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
• Want a reminder to come back and check responses? Here is how to subscribe to a notification.

Answer 2

You can create Dataset that points to Excel by using Linked service of type File system. To connect to local file system, you have to install self hosted IR in local machine.

Refer -
https://caiomsouza.medium.com/load-local-files-to-azure-blob-storage-using-azure-data-factory-e9d0d9e76e83
https://stackoverflow.com/questions/57056928/copy-on-prem-flat-file-to-azure-blob-using-azure-data-factory-v2

---

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav