Log In
Register
Home
New Member
February 27, 2020
Offline
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.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Why not Get Data>From File> From Folder?
Just put all text files in that folder and you will get data from all in a single query.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
ops, sorry, it's a mac...
Power Query is not available in that mac version
October 5, 2010
Offline
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)
