•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Multiple folders with multiple files power query
Hey all,
I have a folder containing about 9000 files all with about 20 text files in each. As far as I could find there was no way to import all of these in a timely manner into power query.
My reason for this is so I can search the text files in the sub folders for specific strings.
If anyone could help or point me to a program that would work better I would appreciate it
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#financial modeling with spreadsheets
#Excel compatibility
#Excel alternatives
#power query
#folders
#files
#text files
#sub folders
#search
#import
#strings
#multiple folders
#multiple files
#specific strings
#program
#timely manner