Copy Excel file with multiple sheets into Shaprepoint

[Nandakishore]

Hi ,

I need help to transfer the excel file and store onto a folder in sharepoint . here i would not wish to process/ recreate the data once again in sharepoint . 

Just Copy and load . 

Thanks

[alexnajm]

if the SharePoint folder is synced to your machine, you can just use a blob input tool to read in the original, followed by a blob output tool to the SharePoint folder! You just might need a formula in between to help define the output path

[Nandakishore]

hi @alexnajm ,

I need to handle this via gallery not from the local machine .

Thanks. 

[alexnajm · Accepted solution]

@Nandakishore ok that’s very important to know ahead, but the same concept remains. The only difference is that you need to make sure the same folder is synced to the server machine. 

Otherwise this may be difficult to do in Alteryx, and I might look at other options as I am unsure the SharePoint Input tools can work with blobs easily. Maybe Power Automate?

[Nandakishore]

Hi @alexnajm ,

Not sure of power automate :) .

[alexnajm]

Moving local excel file to Sharepoint Online- as a scheduling task - Microsoft Q&A