Add Excel as source
Add excel file as source.
Thank you for your feedback. We are evaluating this ask and will keep everyone posted on future plan for this.
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
Mauricio Coria commented
YES! Please allow Data Gateway to access on-prem Excel sources, or allow a connection to Sharepoint/OneDrive hosted Excel sources. The linked server approach is not reasonable - effectively two layers of gateway to keep track of.