Why Excel Online Is Missing Get Data Import Options
Question details
The user wants to access Excel data-import options that are not visible in Excel for the web.

- Product
- Microsoft Excel for the web
- Device & OS
- Chromebook (ChromeOS)
- Scenario
- The user is working in Microsoft 365 Online and wants to import data using Get Data.
- Observed behavior
- Excel for the web shows limited import options, such as Get Data from Picture, rather than all the options available in desktop Excel.
Identify the data source you want to import and check the options available under the Data tab in Excel for the web. If your source is not supported there, arrange access to a supported Windows or Mac computer with desktop Excel.
Use desktop Excel to import data with Get Data
Use this option when the connector or Power Query feature you need is unavailable in Excel for the web.
Excel for the web does not include every desktop data-import feature. Windows desktop Excel generally offers the broadest set of Power Query connectors; availability can also vary by Excel version and subscription.
On a Windows or Mac computer with desktop Excel installed, open Excel and select File > Open to open your workbook.
Select the Data tab, then choose Get Data or the available import command for your source. Select the file, database, or other source and provide access details if prompted.
Use the Navigator or Power Query Editor, if offered, to select and transform the data. Choose Load or Close & Load to place the results in the workbook.
Select File > Save and save the workbook to OneDrive or SharePoint. On your Chromebook, open the saved workbook in Excel for the web to view the imported data.

Work with Excel files in WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel workbooks and continue working with your data, though WPS does not add missing Get Data options to Excel Online.

Frequently Asked Questions
Why can I only see Get Data from Picture in Excel Online?
Excel for the web has a different set of import features from desktop Excel, and available options can vary. Check the Data tab for supported sources; if the connector you need is missing, use desktop Excel on a supported computer.
Can I install desktop Excel directly on a Chromebook?
The Windows and Mac desktop versions of Excel are not native ChromeOS applications. To use their desktop import tools, open the workbook on a supported Windows or Mac computer.
Can I view data imported in desktop Excel on my Chromebook?
Yes. After loading the data into a worksheet, save the workbook to OneDrive or SharePoint and open it in Excel for the web. Browser-based query editing and refresh may be limited.
Does Excel for Mac have the same Get Data options as Excel for Windows?
Not necessarily. Connectors and Power Query features vary by platform and Excel version. Check the Data tab in your installed version for the source you need.




