This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(121.6, 92%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPV%3C/text%3E%3C/svg%3E)
Hi,
we have a dataflow with lots of transformations. In the end the output has to be written to Excel, not CSV.
Is it possible in some way to have Excel as output in ADF?
If ADF is not possible, are there other possibilities? For instance in somehow using Databricks?
regards
Ron
Hey,
Unfortunately excel and xml formats are not supported as a sink in ADF /synapse pipelines as of now.
You can do all transformations within ADF and have the final file as CSV and then finally use other Azure offerings like Logic app, Azure function, Databricks etc to convert the csv into excel.
Sample :
![](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(54.400000000000006, 12%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Hello,
As Nandan mentioned , it's not directly possible with ADF activities. You can go through this video to use az. Functions to convert csv to excel.
https://youtu.be/FbZx7SXo0-4?si=nR_XrEUpwphr7TXa
Please feel free to revert for questions.
thnx. I will dive into this in more detail
Hi,
If the response of Nandan Hegde is helpful, please click "Accept Answer" and upvote it. Other partners who read the forums with the same issue can get more information from the correct result.
Thank you.