Forum Discussion
Wanting to pull data from multiple csv files using 'get data'
Hi,
I am not seeing a 'folder' option in get data to merge a bunch of files I have sitting in a folder. All instructions I look up online say to do this by going to data --> get data --> folder but I don't see folder option anywhere.
PQ on the Mac still has quite some shortfalls comparing to it's big brother on the PC. The missing Files from Folder connector is one of them. But, the attached link takes you to MrExcel.com (Bill Jelen's web site) where it is explained how some of the 'gaps' in PQ on the Mac can be filled.
https://www.mrexcel.com/excel-tips/power-query-debuts-for-excel-for-mac-but-with-significant-gaps/
If you prefer not to click on a link, go to his web site and search for "power query mac". The first hit will be the article in the link.
The "from Folder" option can be 'enabled' by entering a short code/command in the "Immediate Window" of the Visual Basic Editor. Now you can use the Folder.Files function in PQ for the Mac. Tested it myself and it works as shown and explained in the video.
Thank you Riny. This is what I've been using. Do you know if there's a limit to this? As in a limit of how many files or rows I can combine at once?
Hi liz123395
To my knowledge the From Folder option isn't available on Mac (yet). Import data from additional data sources using Power Query in Excel for Mac is the Blog post MSFT updates when new features are released...
Power Query editor is available on Mac though. If you have knowledge in M (Power Query language) you can achieve what you expect but will have to do (code) almost everything manually
I don't believe there is a limit.
