Office for Mac Issues

Check Excel for Mac PivotTables and Get & Transform Availability

Bushra ParveenBushra Parveen Nov 13, 2026 868 views

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.

Excel for Mac PivotTables and Get & Transform Availability
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 you start

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.

Solution 1Recommended

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.

1
Open Excel for Mac and go to updates

In Excel, click Help > Check for Updates. If you installed from the Mac App Store, open the App Store and select Updates instead.

2
Install pending Microsoft Office updates

Follow the Microsoft AutoUpdate prompts to download and install all available updates, then restart Excel.

3
Verify Get & Transform in the Data tab

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.

Update checked: After updating, Power Query menu items can still differ from Windows because Microsoft releases Mac features gradually.
Free Microsoft Office alternative

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. 1. Download WPS Office for Mac: Go to the official WPS Office website and download the free macOS version.
  2. 2. Install and open WPS Spreadsheets: Install the app, launch WPS Office, and click Spreadsheets to start a workbook.
  3. 3. Open your Excel workbook: Use File > Open to select an existing .xlsx workbook from your Mac.
  4. 4. Review PivotTable and data tools: Use the Insert > PivotTable and Data tools in WPS Spreadsheets to continue your analysis.
WPS Spreadsheets opens and saves .xlsx workbooks while preserving PivotTables and formulasFree Office suite for Mac with a familiar ribbon interfaceLightweight and easy-to-use alternative for everyday spreadsheet tasksIncludes data import and pivot reporting tools for Excel-compatible workflowsCompatible with Microsoft Excel files for seamless migration from Excel for Mac
microsoft office alternative - wps office

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.