Add Excel as source
Add excel file as source.
We have the same problem: Excel as input format with multiple tabs.
The suggested workaround by MaFishHH ("use wrangling data flow") has the same limitation, only csv is supported as data set format.
Don't forget to add Excel as a TARGET too !
Hey guys, you could check if the ADF feature "data flows" --> "wrangling data flow" is fine for you. This is a PowerQuery engine, this should also allow reading Excel files. You can add this data flow into your pipeline by the "data flow" activity.
Ronny Hagen commented
Any news on this topic?
Why to again use conversion service like Azure App logic or SSIS package for conversion?
Both are Microsoft product and It is not yet in production? why ?
How can they miss supporting Excel as a source in ADF? Hope they add support ASAP!!!
Vimal Amaldas commented
Excel is an important data source, please consider adding a copy activity for excel.
A few of our clients have a bunch of XLS and XLSX files that are generated automatically by their system on a schedule, some files contains multiple sheets, and they cannot generate the files in another format, and cannot move/host/integrate the data to another system. It would reduce the complexity of our integration projects if we did not have to convert the files to a supported data type (CSV) first or use SSIS to do the integration. Are there any other work arounds we should be exploring? Thanks team.
please allow for excel !
yes please !It will be really helpful to read excel files into ADF.
Yes, It will be very helpful
Suraj Singh commented
Hello Everyone ,
Do we have option to convert file format from .txt, .xlsx to .csv while doing copy activity?
I know this can be achive via custom acivity and c# code but it will increase our complexity. This is a PaaS service , please impement this feature in adf v3 version it will help us to solve most of the usecases.
Please let me know if you have alernative solutions
Yes, Please look into this ask and it is kind of blocker for most of the migration projects where entire data processing is depend on excel source files.
We do have options with custom dot net activity but has lot complexities and using SSIS IR with adfv2 is not a fully PAAS service and many small-medium scale migration ask are for 100% PaaS service.
Please consider and if it is available then please share the details.
Rob Hall commented
Please look at this, it would be a massive help for us.
yes excel source is one of the major data source
Manish Pradhan commented
Please let us know if there is plan in the future for this. Currently the best option to do this seems to be using SSIS IR in ADF V2 and calling SSIS package to read the Excel source. Our client wanted to go completely with ADF without SSIS IR. However we proposed SSIS IR for reading excel as we didnt want to go for a custom activity to read excel due to the time limit. This is a much wanted feature.
i had to propose talend as data integration since azure data factory does not support excel. please add the facility.
Please consider this feature ASAP as most of the customer is looking for this.
Claudia Marroquin commented
Highly important, EXCEL is today the most common data source.
Cibelle Castro commented