Will Google Sheets Get Power Query? What to Use Instead

No—Google Sheets does not currently have a built-in version of Microsoft Power Query, and Google has not announced a native Power Query integration. You can still clean and combine data in Sheets, but the best option depends on whether you need a simple spreadsheet formula, a scheduled import, or a repeatable data-preparation workflow.

Why Google Sheets does not have Power Query

Power Query is Microsoft’s data-import and transformation technology. It is built into Excel and is also used in Power BI. Google Sheets is a separate cloud spreadsheet with its own import tools, functions, connectors, and scripting options. The products overlap in what they help people do—bring data into a useful shape—but they do not share the same query engine.

That distinction matters when you search for Power Query in Google Sheets. There is no native Power Query editor, no Google Sheets menu that opens Power Query, and no built-in way to refresh an Excel Power Query pipeline as a Sheets query. Google could add a comparable feature in the future, but there is no announced release or date to rely on. For planning purposes, treat Power Query as an Excel or Power BI feature and choose a Sheets-compatible method if the finished file must live in Google Sheets.

What Power Query does in Excel

Power Query is more than a command for importing a CSV. It lets you create a sequence of repeatable steps that retrieves data, transforms it, and loads the result into a worksheet or data model. Typical transformations include removing columns, filtering rows, changing data types, splitting text, joining tables, and combining files with the same structure.

In Excel for Microsoft 365 on Windows, Power Query is available through the Data > Get Data area of the ribbon, often presented as Get & Transform Data. A query can keep its steps so that a later refresh applies them again to updated source data. For example, a monthly report might combine all sales CSV files in a folder, discard test transactions, standardize date and currency columns, and group the remaining records by region.

This repeatability is the key difference between Power Query and a one-time copy-and-paste job. It is also why a workbook with Power Query is not simply a spreadsheet containing a formula that Google Sheets can translate. The workbook may depend on query definitions, source credentials, and refresh behavior that Sheets does not run.

Google Sheets tools that cover some of the same work

Sheets has several ways to bring in or reshape data, but each is suited to a different job. They do not combine into one universal Power Query-style editor.

Importing files: Use File > Import to bring in supported files such as CSV data or another spreadsheet. This is useful for a one-time load; it is not automatically a reusable folder-combine pipeline.
Spreadsheet functions: Functions such as QUERY, FILTER, and IMPORTRANGE can select, reshape, or reference data. QUERY uses a query-language syntax over a range, but it is not Power Query and does not provide the same broad set of data-source connectors or transformation steps.
Connected Sheets: In eligible Google Workspace environments, Connected Sheets can connect to BigQuery data and analyze it from Sheets. It is designed for working with BigQuery, not as a general replacement for importing any folder, database, or web source through Power Query.
Apps Script: A script can call services, process rows, and run on a schedule or in response to an event. This offers flexibility, but someone must create and maintain the code, permissions, and error handling.
Extensions and external services: Add-ons and third-party data tools may connect to particular services. Their features, prices, permissions, and refresh limits differ, so check those details before choosing one.

For example, if a team has a small, clean table in another Google Sheet, IMPORTRANGE may be enough to reference it. If the source is a large BigQuery dataset, Connected Sheets may be more appropriate. If the task is to combine dozens of changing files from a shared drive, a dedicated connector or a separate data-preparation service may be a better fit than a long chain of cell formulas.

Can Google Sheets open an Excel file that uses Power Query?

You may be able to upload or open an Excel workbook in Google Sheets, but that does not make its Power Query process run in Sheets. Importing spreadsheet data and formulas is different from importing the process that originally produced that data. Power Query connections, refresh settings, and other Excel-specific features may not be preserved or usable after conversion.

If you receive a workbook that depends on Power Query, keep an original copy and open it in a compatible version of Excel to refresh its queries. You can then export or copy the resulting table into Sheets if the rest of the team needs to collaborate there. Check the converted copy rather than assuming it is equivalent: compare row counts, totals, dates, and any formulas or formatting the report relies on.

A practical arrangement is to use Excel for the data-preparation stage and publish a clean output table for Sheets users. That can work when the transformation is stable and refreshes are handled by someone with access to the source. It is less suitable when Sheets users need to change the query steps themselves or when the process must refresh automatically without an Excel environment.

How to choose the right approach

Start with the source, the size of the data, and how often it changes. A quick import and a recurring, multi-source data pipeline are different requirements, even if both end with a spreadsheet.

Identify the source. Is it a CSV you download, another Sheets file, a database, a website, or many files in a folder? Confirm that the tool you choose can access it.
Decide whether refresh must be automatic. A one-time import may be simplest for a static report. A weekly or daily process needs a reliable refresh method and a plan for failed updates.
Estimate the scale. Formulas are convenient for manageable ranges, but very large datasets or repeated transformations may be more appropriate in a database or data warehouse.
Consider who maintains it. A transparent formula may suit a small team. A script or third-party connector can do more, but someone needs to understand its permissions and upkeep.
Test the final output. Compare a known sample, totals, missing values, and date or number formats before using the result in a report.

One common misconception is that choosing the QUERY function gives Sheets the equivalent of Power Query. It does not. The function is useful for querying ranges inside a spreadsheet, including selecting columns and filtering rows, but it does not by itself create a managed pipeline that connects to arbitrary sources, records a sequence of transformations, and refreshes those sources like Power Query.

Alternatives when Sheets is not enough

If you need Power Query’s exact workflow, use Excel for Microsoft 365 on Windows or Power BI for the relevant data-preparation and reporting tasks. Excel’s Mac and web experiences do not have full feature parity with Windows, so check that the specific connector and query operations you need are supported in the version your team uses. A workbook created on Windows may not be equally refreshable everywhere.

If Google Sheets is a firm requirement, consider keeping complex preparation outside the sheet. A database or cloud data warehouse can store and transform larger datasets, with Sheets used for collaborative analysis or presentation. For a BigQuery source, Connected Sheets may provide a direct route where the organization’s Workspace edition and permissions allow it. For other systems, a connector service or a small Apps Script may be appropriate, depending on the source and security requirements.

These choices have trade-offs. A script can be customized but requires code maintenance. A third-party connector can reduce development effort but may charge a subscription and request access to data. A warehouse can handle larger pipelines, but it introduces setup, access controls, and potentially usage charges. Choose based on the workflow and governance needs, not simply on which option most closely resembles Power Query’s name.

Costs, permissions, and reliability

Google Sheets itself may be available through a personal Google account, while some organizational features—including particular Workspace services or data connectors—depend on the account, edition, administrator settings, or source permissions. Third-party add-ons may have free tiers, paid plans, or usage limits. Apps Script can avoid a connector subscription in some cases, but development and ongoing support still have a cost.

Before connecting a source, check what access the integration requests and where credentials are stored. Avoid placing passwords or private API keys in visible cells. A scheduled import also needs an owner: if that person loses access, changes roles, or deletes an authorization, updates can stop. For business reporting, document the source, refresh schedule, owner, and a basic check that can reveal stale or incomplete data.

Reliability is not just whether a refresh succeeds. A source can change its column names, date format, or file location and still produce an output that looks plausible but is wrong. Keep a small validation step—for example, comparing the latest reporting period and expected row count—and investigate changes before distributing the results.

Frequently Asked Questions

Is Power Query available in Google Sheets?
No. Google Sheets does not currently include Microsoft Power Query or a native editor that runs Power Query steps. Sheets has separate import, formula, connector, and scripting options.

Is the Google Sheets QUERY function the same as Power Query?
No. QUERY works with data in a Sheets range and can select, filter, and organize that data. Power Query is a broader import-and-transformation tool that connects to sources and saves repeatable preparation steps.

Can I refresh Power Query data after converting Excel to Google Sheets?
Do not assume so. Sheets does not run the Excel query pipeline. Refresh the query in a compatible Excel environment, then transfer the prepared results if you need them in Sheets.

What is the closest Google Sheets alternative to Power Query?
There is no single equivalent. Use formulas for straightforward transformations, Connected Sheets for supported BigQuery workflows, Apps Script for custom automation, or a connector service for a supported external source.

Can Google Sheets combine multiple CSV files automatically?
Sheets can import data, but it does not provide Power Query’s general-purpose folder-combine workflow. Depending on where the files are stored and how often they change, use a script, an appropriate connector, or prepare and combine them in another data tool before loading the result.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.