CODEWITHSUNDEEP
excelazurecsvazure-data-factory
db_noob
db_noob

Reputation: 135

How to convert excel file to csv in azure data factory

Hi I'm looking for some help here. I am new to Azure Data Factory and I need to convert some Excel files to csv, how can I do this?

Upvotes: 2

Views: 8913

Answers (2)

Cribber
Cribber

Reputation: 2913

As of 2022 .xlsx and .xls files are supported as source but not as sink.

This means that we can use a copy activity in Azure Synapse / Azure Data Factory to extract the data from a specific sheet of the xlsx file (=source) and copy it to a csv file (=sink).

Upvotes: 3

Jay Gong
Jay Gong

Reputation: 23782

As i know,Excel file is not supported by ADF so far,only these formats are supported.

So,you could try some workarounds to process excel files in ADF:

1.Use Databricks Activity to load excel files and convert into csv files,please refer to this case:How to construct Dataframe from a Excel (xls,xlsx) file in Scala Spark?

2.Use Azure Function Activity to convert excel files into csv files,you could choose development language to implement that. Then output the csv files into specific path and use them in the next steps.

3.Try Custom Activity which is actually tasks(for example,execute a Powershell Script) running on the Azure Batch Node.This approach is more flexible and easy to operate.

Upvotes: 2

Related Questions