Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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
Need Help
PhilipTreacy's avatar
PhilipTreacy
Super User
2 years ago

Anonymous 

 

Is it possible?  Yes.  How to do it?  Well, depends on a lot of things and you haven't provided any details.

 

Are the folders on a PC, Sharepoint, somewhere else?  Are the file contents structured the same - obviously the PDF and Excel files are different.

 

Regards

 

Phil

Anonymous's avatar
Anonymous
Not applicable
2 years ago

 

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. 

 

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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. 

    Power Query SharePoint folder connector