Share via

Can ADF read an excel file which is placed in a SharePoint portal and sink it in as CSV format

Tirunagari, Sravan 0 Reputation points
2023-01-16T06:27:47.76+00:00

I have been trying to get an excel file .xlsx file from SharePoint and replace it has a csv format can this be achievable. In the first instance can i load the xlsx file from SharePoint through http connector.

I have been following and trying from the MS Doc: [https://learn.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list?tabs=data-factory#copy-file-from-sharepoint-online.

please let me know if there are any solutions.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,644 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 36,151 Reputation points MVP Volunteer Moderator
    2023-01-16T06:39:47.53+00:00

    Hey,

    You can do the following:

    1. 1st copy the excel file as is from sharepoint into blob (binary dataset)
    2. Then use copy activity again with blob as source and sink and convert the excel into CSV
    1 person found this answer helpful.
    0 comments
  2. ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator
    2023-01-23T06:29:29.79+00:00

    Hi @Tirunagari, Sravan,

    Thank you for posting query in Microsoft Q&A Platform.

    You need to make API call to get file copied to your destination first and then use another copy activity to take that copied file and load it as excel.

    Below official documentation has steps to copy file from SharePoint Online. Kindly follow same.

    copy file from sharepoint online

    Hope this helps. Please let me know if any further queries.

    Please consider hitting Accept Answer and Yes. Accepted answers help community as well.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.