Fix Missing Get and Transform (Power Query) in Excel for the Web
Question details
Users are unable to locate or use the Get Data (Power Query / Get and Transform) functionality in Excel for the Web to import data from external sources.
- Product
- Microsoft Excel for the Web
- Device & OS
- not provided
- Scenario
- Attempting to import and transform data, such as extracting tables from PDF files, while working in the web browser version of Excel.
- Observed behavior
- The Get Data or Get and Transform feature is completely missing from the Data tab, preventing the user from completing data import tasks.
Verify your Microsoft 365 subscription tier, as advanced data import and transformation features in the web version are restricted or unavailable on certain plans.
Use the Desktop Application and Update Office
Since Power Query is heavily restricted in the web version, opening your workbook in the fully updated desktop application is the most reliable way to access Get and Transform.
The Excel desktop application contains the full suite of Power Query connectors, including the ability to import data from PDF files.
Ensuring your desktop software is fully up to date guarantees you have the latest feature rollouts and bug fixes.
While viewing your spreadsheet in Excel for the Web, click on the 'Editing' or 'Viewing' dropdown menu at the top of the ribbon, and select 'Open in Desktop App'.
Once the desktop Excel application opens, click on 'File' in the top-left corner, and select 'Account' from the bottom of the left-hand menu.
Click on the 'Update Options' button next to Office Updates, and choose 'Update Now'. Allow any pending updates to install completely.
Navigate to the 'Data' tab on the ribbon and click 'Get Data' to access the full Get and Transform capabilities.
Submit Feedback for Missing Web Features
If you are strictly limited to using a Chromebook or web browser, you should submit feedback to Microsoft so they can investigate the missing feature for your account.
Switch to WPS Office for Seamless Data Management
If missing features in web-based spreadsheets are slowing down your workflow, WPS Office provides a robust, fully-featured desktop alternative. It handles local files smoothly, offers excellent Microsoft format compatibility, and includes built-in tools like PDF to Excel conversion.
- 1. Download and Install: Visit the official WPS Office website and download the free desktop application for your operating system.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheet and easily open your existing .xlsx files without losing any formatting.
- 3. Extract PDF Data: Use the built-in PDF tools under the 'Tools' tab to seamlessly convert PDF tables directly into editable spreadsheets.
Frequently Asked Questions
Why is Power Query not available in my Excel for the Web?
Power Query functionality (Get Data) is not universally available across all Microsoft 365 web plans. Its availability depends heavily on your specific enterprise or personal subscription tier and Microsoft's gradual feature rollout schedule.
Can I import PDF data into Excel for the Web without Get Data?
Directly extracting data from PDF files is generally unsupported in the web interface without the Get Data feature. You will either need to open the file in the desktop version of Excel or use a dedicated PDF-to-Excel conversion tool.
Does updating the Excel desktop app add more Get Data connectors?
Yes. Microsoft frequently updates its list of Power Query connectors. Navigating to File > Account > Update Options and installing the latest Office updates ensures you have the most recent data import tools available.
