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

小锤 王 6 Reputation points
2022-05-27T08:47:23.373+00:00

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

206108-%E6%88%AA%E5%B1%8F2022-05-27-164411.png

Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
457 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,882 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,526 Reputation points
    2022-05-30T03:30:18.393+00:00

    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.
    206479-72.jpg

    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.

    0 comments
  2. Suat M. Ozgur 0 Reputation points
    2023-05-01T15:07:18.1566667+00:00

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