How to Fix Get Data Missing in Excel on a Chromebook
Question details
The user is unable to locate the 'Get Data' feature while attempting to import external data in Excel on a Chromebook.

- Product
- Microsoft Excel
- Device & OS
- ChromeOS
- Scenario
- Attempting to import or connect to external data sources using the standard data wizard.
- Observed behavior
- The 'Get Data' feature is completely missing from the Data tab because the device is running the web or mobile version of Excel.
Verify whether you are using the Excel Android app or Excel for the web on your Chromebook, as advanced data connection features are currently exclusive to the Windows desktop version of Excel.
Use Supported Data Import Tools in Excel for the Web
Since Chromebooks utilize Excel for the web, you must rely on web-supported methods for managing data instead of the legacy Get Data (Power Query) wizard.
Excel for the web offers a streamlined interface designed for browser use. While you cannot create new complex data connections using 'Get Data', you can still manage simple imports and refresh existing queries.
Navigate to Office.com using your Chromebook's web browser, log in with your Microsoft account, and open your target workbook.
Click on the 'Data' tab in the top ribbon to view the web-based data connection and management tools available to you.
If your workbook contains existing Power Query connections previously created on a Windows desktop, click 'Refresh All' to update the data directly from the web interface.

Access Excel via a Virtual Desktop Environment
To fully utilize the 'Get Data' tools on a Chromebook, access the full Windows desktop version of Excel through a virtual desktop or remote PC connection.
Edit Spreadsheets Locally on Your Chromebook with WPS Office
Since Excel for the web restricts advanced features on Chromebooks, WPS Office provides a robust, desktop-like experience for managing your spreadsheet data locally. It is lightweight, allows you to work offline seamlessly, and avoids the limitations of browser-only applications.

Frequently Asked Questions
Why does Excel on a Chromebook look different from Excel on Windows?
Chromebooks typically run Excel for the web or the mobile Android app. Both are streamlined versions of the software optimized for lighter devices, which means they omit certain advanced features like Power Query and legacy data import wizards found in the full Windows desktop application.
Can I install the desktop version of Excel directly on a Chromebook?
No, the full Windows desktop version of Microsoft Excel cannot be installed natively on ChromeOS. You are limited to Excel for the web, the Android app, or utilizing a remote desktop solution to access a Windows PC.
How can I run Power Query on a Chromebook?
You cannot create new Power Query connections using Excel for the web on a Chromebook. However, if a workbook with existing queries was created on a Windows PC, you can often refresh that data in Excel for the web by clicking 'Refresh All' under the Data tab.
Are there local spreadsheet apps for Chromebooks that support complex data formats?
Yes, you can install local alternatives like the WPS Office Android app or Linux version on your Chromebook. This allows you to handle local data files, large CSVs, and standard spreadsheet tasks offline without relying on web-only Microsoft applications.




