SharePoint and OneDrive for Business are the services used by many companies for storing and sharing files. You’ll often find CSV files and Excel files stored in the Libraries in these services.
So what happens when you need to import the content from one of these files into an Excel file?
Most people do it using the From SharePoint Folder option under Get Data. The problem with doing it that way is, compared to the method shown in the video (below), there are more steps.
You can’t specify the folder that contains the file (you have to specify the “root URL” of the SharePoint site) resulting in potentially hundreds or thousands of files being returned in the Query in Excel, which means you have to add a “filter step” to the Query.
Check out the 2-minute video below for a much simpler way to import data from a single file stored in a SharePoint Online Library or in OneDrive for Business.