How to Fix Missing Get External Data or Get Data in Excel
Question details
The user is unable to find the 'Get Data' or 'Get External Data' buttons on the Excel ribbon to import external information.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to import external data sources or utilize Power Query tools within an Excel spreadsheet.
- Observed behavior
- The 'Get Data' and 'Get & Transform' options are completely missing from the Data tab, which typically occurs when accessing the web-based version of Excel instead of the desktop client.
Verify whether you are currently editing your spreadsheet in a web browser (Excel for the web) or using the fully installed Excel desktop application.
Install and Switch to the Microsoft 365 Desktop Application
Excel for the web is a lightweight version and does not support advanced data import features. You must install and use the desktop application to access 'Get Data'.
The 'Get Data' and 'Get & Transform' (Power Query) features require the processing capabilities of the Excel desktop client. These features are intentionally omitted from Excel for the web to ensure the browser version runs smoothly.
To resolve this, you need to download the full Microsoft 365 application suite to your computer.
Open your web browser and navigate to office.com, then log in using your Microsoft account credentials.
On the Microsoft 365 homepage, look for the 'Install apps' button located near the top right corner of the dashboard.
Click 'Install apps' and follow the on-screen instructions to download the setup file. Run the downloaded installer to install the desktop applications on your computer.
Launch the newly installed Excel desktop application, click on the 'Data' tab in the ribbon, and you will now see the 'Get Data' feature available.

Easily Import External Data with WPS Spreadsheets
If you cannot install the Microsoft Excel desktop app due to subscription limitations, try WPS Office. WPS Spreadsheets is a robust, free desktop application that provides powerful built-in tools to import data from text files, CSVs, and other external sources.
- 1. Install WPS Office: Download and install the free WPS Office suite from the official WPS website.
- 2. Launch Spreadsheets: Open WPS Spreadsheets and create a new blank workbook or open your existing file.
- 3. Navigate to the Data Tab: Click on the 'Data' tab located on the top ribbon interface.
- 4. Select Import Data: Click the 'Import Data' button to choose your external data source type.
- 5. Complete the Import: Follow the straightforward import wizard to format and load your external data directly into the spreadsheet.

Frequently Asked Questions
Why is the 'Get Data' button grayed out in my Excel desktop app?
If you are using the desktop app and the 'Get Data' option is grayed out, you might be actively editing a cell or viewing a protected sheet. Press the Esc key to exit cell editing mode, or go to the Review tab to unprotect the worksheet.
Does Excel for Mac have the 'Get Data' feature?
Yes, recent versions of Excel for Mac support Power Query and the 'Get Data' feature. You can find it under the Data tab, though the list of available external data connectors may be more limited compared to the Windows version.
What if my Microsoft 365 plan does not include desktop apps?
If you are subscribed to a web-only plan like Microsoft 365 Basic, you will not have the option to install the desktop apps. You would need to upgrade your subscription or switch to a free desktop alternative like WPS Office to handle data imports.




