Power Query Problems

Restore the Get Data Tab in Excel 2013 or Microsoft 365

Maira MehtabMaira Mehtab Nov 12, 2026 870 views

Question details

The user needs to restore or locate the Get Data controls used to access Power Query in Excel 2013 or Microsoft 365.

Product
Microsoft Excel 2013 or Microsoft 365 Excel with Power Query
Device & OS
Windows desktop
Scenario
The user subscribed to Microsoft 365 and can use Power Query in Power BI Desktop but cannot find the previous Get Data tab in Excel.
Observed behavior
The Get Data tab is missing. In newer Excel versions, Power Query is integrated into the Data tab rather than displayed as a separate tab.
Before you start

Confirm whether you are using Excel 2013, Excel 2016 or later, Microsoft 365 desktop Excel, or Excel for the web. Power Query access and menu locations differ by version, and the integrated commands are available in the Windows desktop application.

Solution 1Recommended

Open Power Query from the Data tab in Microsoft 365 or newer Excel

Use this solution when Power Query is integrated into Excel 2016 or later, including Microsoft 365 desktop Excel.

In Microsoft 365 and Excel 2016 or later, Power Query is built into Excel and usually no longer appears as a separate Get Data tab. Its commands are located on the Data tab.

1
Open the Data tab

Launch the Windows desktop version of Excel and open a workbook. On the Excel ribbon, select Data.

2
Choose Get Data

In the Get & Transform Data group, select Get Data to view import sources such as From File, From Database, or From Other Sources.

3
Launch the editor

Select Data, then choose Get Data and Launch Power Query Editor if that command is available in your Excel build.

The tab may not be missing: In current Microsoft 365 versions, Power Query is integrated into the Data tab, so a separate Get Data tab is not expected.
Free Microsoft Office alternative

Use WPS Office as a Lightweight Alternative for Excel Workbooks

WPS Office provides a free, lightweight spreadsheet environment with a familiar interface and strong compatibility with Microsoft Excel files. It can help you open, edit, and migrate XLSX workbooks smoothly, although it does not restore Microsoft Excel's Power Query tab or replace Power Query-specific features.

  1. 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheets from the Start menu or applications list.
  2. 2. Open the Excel workbook: In WPS Spreadsheets, select Menu, Open, choose the XLSX file, and review the workbook contents.
  3. 3. Edit and save compatibly: Make the required spreadsheet changes, then select Menu, Save As, and choose the Excel 2007-365 Workbook (*.xlsx) format.
Open and edit Microsoft Excel XLSX workbooks with a familiar spreadsheet interfaceUse a free, lightweight Office alternative for everyday spreadsheet tasksMigrate existing Excel files without changing the standard XLSX formatWork across common Office documents with a simple, responsive interface
microsoft office alternative - wps office

Frequently Asked Questions

Why did the Get Data tab disappear after upgrading to Microsoft 365?

Microsoft 365 and Excel 2016 or later integrate Power Query into the Data tab. Select Data, then use Get Data or Launch Power Query Editor instead of looking for a separate tab.

Can I use Power Query in Excel 2013 without a separate add-in?

No. In Excel 2013, Power Query was distributed as a separate add-in. Install the version that matches your Office installation, then enable it through File, Options, Add-ins, COM Add-ins, and Go.

Where is Power Query in Excel for the web?

The full Power Query experience is associated with the Windows desktop version of Excel. If the commands are unavailable online, open the workbook in the desktop application and check Data, Get Data.

Does Power BI Desktop use the same Power Query technology?

Power BI Desktop includes its own Power Query editor, but its availability does not restore a missing Excel tab. Check the Excel version and access Power Query through Data, Get Data in supported desktop versions.

Can WPS Office restore Excel's Power Query Get Data tab?

No. WPS Office can open and edit compatible XLSX files, but the Microsoft Excel Power Query add-in and Get Data integration are Excel-specific features.