Check Excel for Mac PivotTables and Get & Transform Availability
Question details
User needs to confirm Excel for Mac support for PivotTables, external workbook data import, and Get & Transform/Power Query features, including how to handle missing or incomplete functionality.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- The user is working in Excel on macOS and needs to compare feature availability with Windows, especially for PivotTables and Power Query.
- Observed behavior
- Excel for Mac supports PivotTables and newer versions include Get & Transform, but the user interface and feature availability may differ from Windows and older releases can lack complete functionality.
Before checking features, confirm your Excel for Mac version and install all pending Microsoft Office updates so the current Power Query and PivotTable options are available.
Install the latest Excel for Mac updates and verify Power Query availability
Use this first to ensure the current Get & Transform features for your macOS version are available and correctly reported.
Feature availability in Excel for Mac changes with Microsoft 365 updates. Keeping Excel current is the fastest way to get the latest Power Query connectors and fixes.
In Excel, click Help > Check for Updates. If you installed from the Mac App Store, open the App Store and select Updates instead.
Follow the Microsoft AutoUpdate prompts to download and install all available updates, then restart Excel.
Open a workbook, select the Data tab, and look for Get Data (Power Query) to see the available import and transform options on your Mac.
Import external workbook data into an Excel for Mac PivotTable
Use this when you need to build a PivotTable from another Excel workbook on macOS.
Submit feedback for missing Excel for Mac Get & Transform features
Use this when a Power Query feature from Windows is not available or incomplete in Excel for Mac.
Use WPS Office as a Free Microsoft Office Alternative on Mac
If Excel for Mac lacks the PivotTable or Get & Transform capabilities you need, WPS Office offers a free, lightweight Office alternative for macOS with WPS Spreadsheets, familiar formatting, and strong Microsoft Excel file compatibility.
- 1. Download WPS Office for Mac: Go to the official WPS Office website and download the free macOS version.
- 2. Install and open WPS Spreadsheets: Install the app, launch WPS Office, and click Spreadsheets to start a workbook.
- 3. Open your Excel workbook: Use File > Open to select an existing .xlsx workbook from your Mac.
- 4. Review PivotTable and data tools: Use the Insert > PivotTable and Data tools in WPS Spreadsheets to continue your analysis.

Frequently Asked Questions
Is Get & Transform (Power Query) available in Excel for Mac?
Yes, newer Excel for Mac versions include Get & Transform through Power Query, but the interface and available connectors can differ from Windows. Install the latest updates and check the Data > Get Data menu.
Can I import an external Excel workbook into a PivotTable on Mac?
Yes. Open Excel for Mac, go to Data > Get Data (Power Query), choose From File > From Workbook, select the external file, and then load it into a PivotTable or Data Model.
Which PivotTable features are supported in Excel for Mac?
PivotTables, slicers, PivotCharts, query tables, conditional formatting, and calculated fields are generally supported. Specific capabilities may vary by Excel version and update channel.
How do I update Excel for Mac to get the latest Power Query features?
Open Excel and click Help > Check for Updates. If you installed Excel from the Mac App Store, open the App Store and install pending updates from the Updates tab.
Where can I request a missing Excel for Mac Get & Transform feature?
Use the Excel for Mac feedback forum by going to Help > Feedback in Excel, then search for an existing request or create a new one describing the missing feature.




