Excel: Power Query - How to Import the Most Recent File From a SharePoint Folder

In this video I show how to use Power Query in Excel to import data from a single file stored in a SharePoint folder. The data is imported from the file with the most recent Modified Date. Great for weekly or monthly reporting where the filename is different and you can't or don't want to rename it.

✅ Want more FREE training?

🙋‍♂️ Let's connect on social

#excel #sharepoint #powerquery #latestfile

[MikeThomas]

I don't want to waste anyone's time so before watching the video check that your version of Excel has From SharePoint Folder on the Get Data menu

[pandamonium]

Morning Mike as always, very useful information 🐼🐼👍

[kkravch]

Nice explanation. Thanks. I suggest you make your fonts bigger so people with smaller screens can see better.

[ianrobertson]

Hi Mike. Does this update a newer file, but only the contents have changed (monthly stock updates) Sold, Bought, & revised Book costs.

[annakorbacz]

Hi Mike, thank you for this video, very helpful! What is the best practice for saving old data transferred to Excel (before you update with new week’s data)? Just copy and paste to a new worksheet or is there a better way?

[RonDavidowicz]

One problem, not all versions of Excel have Sharepoint Folder as an option in the Get Data list.