•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
Our take
Hey everyone, I’m reaching out for guidance on efficiently importing a large set of files into Power Query. I have a folder containing approximately 9,000 files, each with around 20 text files. Unfortunately, I haven’t found a timely method to import all these files for searching specific strings within the text. If anyone can offer insights or recommend a more effective program for this task, I would greatly appreciate your help. Thank you for your support!
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]
Read on the original site
Open the publisher's page for the full experience
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