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?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.
Answer accepted by question author
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.
Answer accepted by question author
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
You are wrong, There is a get data from Folder Feature for Windows but not on Mac.
facing the same issue, looking for a solution
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.