Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,661 questions
please refer the below MSFT doc:
It provides step by step details for the same
How to copy an Excel file from SharePoint to Azure Blob Storage using Copy Activity in Azure Data Factory?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 87%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVG%3C/text%3E%3C/svg%3E)
VIGNESH G
0
Reputation points
What are the steps to configure the sink in Azure Data Factory to copy an Excel file from SharePoint to Azure Blob Storage while retaining its format or treating it as binary?
Azure Data Factory
1 answer
Sort by: Most helpful
-
Nandan Hegde 36,156 Reputation points MVP Volunteer Moderator2025-07-12T15:50:18.0733333+00:00 -
VIGNESH G 0 Reputation points
2025-07-12T16:09:31.5133333+00:00 Thank you for the information. However, my issue is that Azure Data Factory does not support writing output files in Excel (.xlsx) format. Is there any other way to generate or handle Excel files in Azure Blob Storage as part of this process?
-
Nandan Hegde 36,156 Reputation points MVP Volunteer Moderator
2025-07-12T16:32:01.6133333+00:00 There is a binary file format pattern which you can select which allows you to copy any file type as is from source to sink excel included
-
Nandan Hegde 36,156 Reputation points MVP Volunteer Moderator
2025-07-12T16:35:59.2733333+00:00 -
VIGNESH G 0 Reputation points
2025-07-13T07:26:24.2333333+00:00 Thanks, @Nandan Hegde . Your input helped me resolve the issue.
Sign in to comment -