Share via

Can Excel be a Sink in Azure Data Factory?

Poel van der, RE (Ron) 421 Reputation points
2023-11-21T09:08:26.5833333+00:00

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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,850 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,667 questions
0 comments
Accepted answer
  1. Nandan Hegde 29,916 Reputation points MVP
    2023-11-21T09:22:06.72+00:00

    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 :

    https://social.msdn.microsoft.com/Forums/en-US/a08b6d3a-f492-4f26-9309-e172553e9fdf/convert-csv-to-excel-in-azure-blob-storage?forum=azurelogicapps

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Poel van der, RE (Ron) 421 Reputation points
    2023-11-21T17:12:08.04+00:00

    thnx. I will dive into this in more detail