Trouble trying to read csv or Excel files from locally-hosted Sharepoint site

I am attempting to read either a csv or an Excel file from a locally-hosted Sharepoint site (2013) and I have tried all the methods I can find in the Community. I do not have admin rights to the SharePoint site.

One suggestion (I can't find it anymore - the solution was from @LordNeilLord) I saw was to input the file name with a text input tool, use a download tool with a dynamic input tool to get the file information -- this one I've gotten the furthest with, but when I run it, I end up with gobbleygook that is the same whether I enter my credentials into the download tool or not, whether I reference the csv or the Excel file.

For reference, I am able to connect to the Sharepoint site with the Sharepoint List Input tool and get a list of files.

Can anyone identify what I am doing wrong here that I'm ending up with a garbage file rather than the content of the Excel/csv file? Any strategies for reading from an Excel or csv file?

TIA

Sharepoint

Accepted answers

LordNeilLord

Hey @myastarling

You should be able to connect to it using the standard input tool...you just need to specify the site as a file path...like so:

\\yoursharepoint.com@ssl\davWWWRoot\sites\yoursite\Filepath to your files

If you're unsure about where to navigate to...if you go to SP in Internet explorer then one of the options in the menu is to open file in explorer....do this then you get the file path

All comments

LordNeilLord

Hey @myastarling

You should be able to connect to it using the standard input tool...you just need to specify the site as a file path...like so:

\\yoursharepoint.com@ssl\davWWWRoot\sites\yoursite\Filepath to your files

If you're unsure about where to navigate to...if you go to SP in Internet explorer then one of the options in the menu is to open file in explorer....do this then you get the file path

LordNeilLord

Also, I don't remember that post to use the download tool....I must have been drunk at the time.

If you find it again let me know, I'd love to see it

myastarling

O...M...G... it worked! this is amaaaaaazing!!! The only thing that got me for a bit was a stupid error on my part where I forgot to specify the sheet name, but it's all working beautifully now.

You have made my month and I owe you several beers! Thank you!!! 😄

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703