Power Query excel 365 for mac : How to import data from local folders

Question

As shown in the picture , it is not possible to import and merge data in large batches from folders

Answer 1

Hi @小锤 王

Welcome to Q&A forum ~

With windows, we can add more files into a specified folder and automatically combine those using Power Query via an option get data from a folder.
But with Mac, Excel for Microsoft 365 doesn’t yet have that capability.

Other users also submit this featue, but under the blog "Import data from local files using Power Query in Excel for Mac", Microsoft team said there is no concrete timeline for this feature yet.

Thanks for your understandings.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---

Answer 2

You can find this useful. Make sure watching the video as well for the extra info: