Excel: Get Data From a File Stored in a SharePoint Folder

Importing data into Excel from a CSV or Excel file stored in a SharePoint Library or OneDrive for Business is a common task and there's more than one way to do it. Most people do it using the From SharePoint Folder option under Get Data however the method I’m going to show you in this video is much quicker.

✅ Want more FREE training?

🙋‍♂️ Let's connect on social

#excel #sharepoint #import

[avishek]

Awesome.. sweet and simple. Thank you Mike!

[Zaporemmm]

Finally a clear and concise explanation! Who could have known that you need to get a link (path) from such a place...

[catarina_carapeta]

AWE-SOME!! Thank you! That's much easier!!

[zwpmvxw]

Thanks! I’ve been looking for an easier way to do this. Your explanation was straightforward and easy to understand!

[EyeOnTheTV]

WHOA . My expectation was very low but this was actually very help and clear and concise. And most importantly it worked!!

[jugalbalaji]

Thank you so much, was trying to open a sharepoint workbook using VBA, and getting the path like this worked finally. The link from the SHARE option does not work at all.

[BluemanacrabREAL]

The connection is deleted in .csv format when the file is closed. Is there a way around this?

[udaykiranmaddi]

Can you help on how to achieve this with excel on mac and xlsx on sharepoint?

[mtwviin]

is there any way that I can get data from another SharePoint (EXCLE file ) and to transferee this data to another file on another file that placed in SharePoint also, (not in the computer desktop)

[rowieforms]

Cool Mike, but what if the file itself is getting replaced (with a different filename), an I want pick up the file in the folder itself? possible?

[enricbasketball]

I have the access denies because of my credentials...but is the same account... am I missing something in my sharepoint folder to give acces to "me"?

[AmlanMannagcad]

Now what to do if there are data from multiple files in sharepoint and you need to merge those datas into one excel folder.