Importing data from local files using Power Query is now generally available in Excel for Microsoft 365 for Mac version 16.57 (22011100) or later.
We are excited to announce a new update to Power Query (PQ) in Excel for Mac – the ability to import data from local files. We’ve received many requests for this feature after the introduction of PQ query refresh. Now you can import data from local files including Excel workbooks and text & CSV files.
This new functionality is available to Beta channel users running version 16.50 (build 21050400) or later. See this support article to check which version you’re using.
Importing data from local files
You can now import data from local Excel workbooks or text & CSV files.
Click Get Data (Power Query) on the Data tab
Select Excel workbook or Text/CSV in the Choose data source dialog box
Click Browse to select the local file
Select the data you want to import and click the Load button