Forum Discussion
Extract Excel and PDF Files (Convert To Excel if Possible) for 100+ Individual Folders
Hi, Is it possible to achieve the subject above via Powe Query or Power Bi or Excel? If so, what's the best course of action? //NT
Hi,
The files either excel or pdf are located in subfolders as shown but since I'm working on 100+ Job Nos. I need to open 100 Main Folders and then go to their respective subfolders which will be tedious if done manually.
All files are stored in sharepoint.
You may try Sharepoint Folder connector. Once connecting to a SharePoint site, you will see all files on that site. Then filter files by [Extension] column and [Folder Path] column to find the files that have the same file type and need to be combined.