Excel as a source in ADF

Punit Parmar 21 Reputation points
2021-01-21T09:33:03.497+00:00

Hello,

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

Regards.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,725 questions
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 79,376 Reputation points Microsoft Employee
    2021-01-21T10:06:16.27+00:00

    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.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Vaibhav Chaudhari 38,646 Reputation points
    2021-01-21T10:16:01.753+00:00

    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

    0 comments No comments