How to use the " Get Data > From Folder " feature on Mac ( Office Home & Student 2021 ) ?

Question

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?

Answer 1

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 2

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