Data Import & Export

Why Excel Online Is Missing Get Data Import Options

Adam DavisAdam Davis Nov 18, 2026 869 views

Question details

The user wants to access Excel data-import options that are not visible in Excel for the web.

Why Excel Online Is Missing Get Data Import Options
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the workbook on a supported computer

On a Windows or Mac computer with desktop Excel installed, open Excel and select File > Open to open your workbook.

2
Choose a data source

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.

3
Import and transform the data

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.

4
Save and reopen 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.

Use desktop Excel to import data with Get Data
Web refresh may be limited: A table imported in desktop Excel can be viewed in the web workbook, but editing or refreshing its query in the browser depends on the data source and available web features.
Free Microsoft Office alternative

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.

Open and edit compatible Microsoft Excel XLSX and XLS filesWork with spreadsheet tables and imported data in a familiar interfaceUse a free, lightweight office suite for everyday documentsMove compatible Office files between applications without changing your usual file formats
microsoft office alternative - wps office

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.