[FIXED] How to convert excel file to csv in azure data factory

Issue

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?

Solution

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.

Answered By - Jay Gong

Answer Checked By - Katrina (PHPFixing Volunteer)