
New Member

February 27, 2020

Hi,
I'm using excel for Mac 15.23.* I have hundreds of .txt files that are serving as web queries to bring data into excel.
Currently, I'm executing each query individually (Data > Get External Data > Run Saved Query....) then repeating with the next query, and the next one, and the next one....
Obviously, this procedure is relatively time consuming and I'm wondering if there is a way to execute MANY or even ALL of my queries at once instead of doing them individually as described.
Appreciate the help.


October 5, 2010

Hi,
I don't know the exact format of your text files but you could merge them all from Terminal then just import 1 file?
Place all the text files in the same folder and create a sub-folder called merge. Open Terminal and navigate to the folder with all your text files. For example if your username is BM and you created a folder called Files on your Desktop you'd type
cd /Users/BM/Desktop/Files
Then type the command
cat *.txt >merge/merge.txt
Regards
Phil
1 Guest(s)
