This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi,
I started using excel as part of a data analytics online course and i just can't follow because some features are not where everybody is finding them like this one down here. ((( Office Home & Student 2021 )))
I have 12 months worth of data, each month in a seperate .csv file. I want to combine the files by using the "Get Data > From File > From Folder" feature on Mac. I purchased 'Office Home & Student 2021' and most explanations on the internet are for windows users. Now i found an answer by Microsoft support talking about "VBA to create new queries in Excel for Mac" Anyone knows what does it mean and HOW to do it?
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi,
I had the same problem and this seems to be a good solution: https://youtu.be/chBlyDrejHo?si=J3tNDMDrzyehykPt&t=318
It's from MrExcels YouTube channel. A tiny bit of coding in VBA to give PQ access to the folder where the files are in and that's it.
For future readers: take a look at the following article and linked videos in order to be able to use Files from Folder on Mac Excel.
Power Query Debuts for Excel for Mac but with Significant Gaps
Some of the items are in Mac Excel, not all of them. Which one do you want?
From what I can tell, Excel for Mac simply doesn't have this extremely useful (and I might say critical) feature. It doesn't seem like it should be too complicated, but it would seem that support for Macs just isn't a Microsoft priority. I've run into the same issue and for me the simplest solution was to use a Excel on a PC.
Hi
As I already said, there is no Get Data from Folder feature in Excel for Windows, either.
You might be referring to Power Query, which is available in Excel for Mac, but only if you have a subscription, and all of the functionality is available currently only in the beta channel.
That said, if you reply with the kind of data you want to import, there is probably a way to do it in the version of Excel you have. What you have not said is what is in the folder that you want to get data from.