Does Google Sheets Have Power Query? What to Use Instead

No. Google Sheets does not include Power Query, Microsoft Excel’s built-in tool for importing, cleaning, combining, and refreshing data. Sheets does offer formulas, cleanup commands, connectors, and Apps Script that can cover parts of the same work, but the best substitute depends on how much data you have and how repeatable the process needs to be.

What Power Query Does

Power Query is Excel’s data-import and transformation environment, called Get & Transform Data in Excel for Microsoft 365 on Windows. It can connect to files, databases, and other sources; apply a sequence of repeatable steps to shape the data; combine tables; and load the result into a worksheet or data model. When the source changes, a user can refresh the query rather than redo every cleaning step by hand.

A key difference is that a Power Query workflow stores its transformation steps as a query. For instance, it can import monthly sales files from a folder, remove unwanted columns, standardize dates, append the files, and refresh the combined output next month. That repeatable, multi-step ETL process—extract, transform, and load—is what people usually mean when they ask for Power Query in Sheets. A formula that displays imported data is useful, but it is not automatically the same kind of managed query pipeline.

What Google Sheets Can Do Instead

Sheets has several useful tools for bringing in and shaping data, although they are separate features rather than one all-purpose Power Query interface. In a browser, the relevant options include:

Import functions: Functions such as IMPORTRANGE, IMPORTDATA, IMPORTHTML, and IMPORTXML can bring in data from another spreadsheet, a CSV or TSV URL, or supported web content.
QUERY and other formulas: QUERY can filter, group, sort, and select data in a range using Google’s query-language syntax. FILTER, SORT, and ARRAYFORMULA can also support formula-driven transformations.
Data cleanup commands: Data > Data cleanup includes options such as removing duplicates and trimming whitespace. These are useful for hands-on cleanup, but they do not record a complete refreshable import process like a Power Query query.
Connected Sheets: Eligible Google Workspace users can connect Sheets to BigQuery data, subject to account, permissions, and administrator settings.
Apps Script: Scripts can automate imports and transformations, but they require someone to write, authorize, and maintain code.

These tools can be combined. A small team might use IMPORTRANGE to collect a few columns from another workbook, then use formulas to filter the rows for a report. A more technical team might use BigQuery for storage and analysis, with Connected Sheets providing a spreadsheet interface. Neither example means that Sheets has Power Query built in.

How to Handle a Simple Repeatable Import

For a small, regularly updated source, start by checking whether the source can be shared as a Google Sheet or published as a stable CSV. Then decide whether you need a live-linked view or a one-time imported copy. A linked formula can update from its source, but it depends on access and source availability; a copied import gives you a snapshot that you can clean independently.

Choose a stable source. A CSV URL or a spreadsheet with a predictable tab and column layout is easier to work with than a web page that changes its structure.
Bring the data into a separate raw-data tab. Keeping the imported content separate from your report makes it easier to identify whether a problem comes from the source, the import, or your analysis.
Check the result before relying on it. Confirm the headers, date formats, row count, blank values, and whether the source has added or renamed columns.
Apply cleanup and analysis separately. Use formulas or the Data cleanup menu on a working tab, rather than manually editing the only copy of the incoming data.
Document the refresh process. Note the source, required permissions, and any manual steps so another editor can maintain the spreadsheet.

For example, a small shop could import a monthly CSV of orders, keep the original columns untouched on a raw tab, and use a separate report tab to group orders by product or month. If the CSV changes its header names or the source link expires, the report may need adjustment. This is manageable for a modest workflow, but it becomes fragile when dozens of files, complex joins, or strict refresh schedules are involved.

Where Sheets Falls Short of Power Query

Sheets formulas generally recalculate within a spreadsheet, but they do not provide Power Query’s unified editor for building and managing a long series of import steps. Cleaning data by hand through menu commands can be quick once, yet it is not the same as saving a transformation recipe that can be replayed against new source files. Formula-based workflows can be repeatable, but they may be harder to understand when many tabs depend on one another.

There are practical limits, too. Imports from websites can fail when a site blocks automated requests, changes its page structure, requires a login, or serves data in a format an import function cannot read. IMPORTRANGE needs access to the source spreadsheet, and large or complicated formula chains can make a workbook slower or harder to maintain. Apps Script can automate more, but scripts have authorization requirements and service quotas; they also need someone capable of debugging them.

These limitations matter most when the process is business-critical. If a report must refresh reliably on a schedule, combine many changing files, preserve a clear audit trail, or process data beyond a spreadsheet’s comfortable scale, a collection of formulas may not be a dependable substitute for a dedicated data pipeline.

Connected Sheets and BigQuery

Connected Sheets is Google’s closest built-in option for analyzing data stored in BigQuery from within Sheets. Where it is available and authorized, a user can use the Sheets interface to work with BigQuery data without treating the spreadsheet as the permanent home for a large dataset. The menu path is Data > Data connectors > Connect to BigQuery. What appears and what actions are permitted depend on the Google account, Workspace edition, project permissions, and administrator policies.

This is not Power Query under another name. BigQuery remains the data platform, and the connection is designed for analysis of that data from Sheets. It is most relevant when an organization already uses BigQuery or expects data volumes and access controls that exceed a typical shared spreadsheet. A personal Sheets user working with a few CSVs may not have access to it or need it.

Choosing the Right Alternative

The right choice depends on the source, amount of data, refresh needs, and who will maintain the workflow. Consider these practical distinctions:

Occasional, small imports: Use an import function or paste a clean snapshot, then use formulas or Data cleanup for basic preparation.
Data already in another Google Sheet: IMPORTRANGE can be convenient when the source owner can grant the required access and the imported content is not too large or complex.
BigQuery data: Look at Connected Sheets if your account and permissions support it; keep the underlying data in BigQuery when that is the intended system of record.
Custom automation: Apps Script may fit when the task is well defined and someone can own the code, permissions, and maintenance.
Many files or elaborate transformations: Consider Excel Power Query, a database, or an ETL/data-integration service rather than building an increasingly complicated spreadsheet.

Before choosing, ask how often the source changes, whether the transformation needs to be reviewed, how many people will use the result, and what happens if an update fails. A one-off cleanup and a daily operational pipeline are different problems, even if both begin with a spreadsheet.

Google Sheets Versus Excel Power Query

Excel for Microsoft 365 on Windows includes Power Query through the Data tab’s Get & Transform Data tools. Excel for Mac also has Power Query capabilities, but available connectors and functionality can differ by Excel version; check Microsoft’s current support information if a particular connector is essential. In either case, Power Query is an Excel feature, not a Google Sheets feature.

Sheets may be preferable when people need to collaborate in a browser, share live spreadsheets, and use Google Workspace. Excel with Power Query is often a more direct fit when the core requirement is a repeatable sequence of imports and transformations from files or supported sources. You can upload or convert an Excel workbook in Google Sheets, but Sheets does not run an Excel Power Query workflow as if it were a native Sheets feature. If a workbook depends on queries, keep the original Excel file and verify what survives any conversion before relying on the Sheets copy.

Cost, Permissions, and Data Safety

Basic Google Sheets features are available through Google accounts, while Workspace plans, administrator controls, and connected services can affect which capabilities an organization can use. BigQuery itself can involve Google Cloud costs, depending on how it is configured and used. Do not assume that connecting a spreadsheet to a data service makes the service free or that every account has the same connector options; confirm the applicable plan, permissions, and billing arrangements with the account administrator.

Pay attention to sharing when using IMPORTRANGE. The first connection requires authorization, and granting access can allow editors of the destination spreadsheet to use that connection to retrieve data from the source. Avoid connecting sensitive source data to a broadly shared destination unless its editors should be able to see that information. Review sharing on both spreadsheets, limit access to what is needed, and avoid publishing private information through a web import or shared report.

Frequently Asked Questions

Can I use Power Query in Google Sheets?
No. Power Query is an Excel feature. Sheets has separate import, formula, connector, and scripting tools that may accomplish some similar tasks, but there is no native Power Query editor in Sheets.

What is the closest Google Sheets alternative to Power Query?
There is no single equivalent. For small imports, use import functions and formulas; for BigQuery data, consider Connected Sheets; for custom repeatable tasks, Apps Script may help. The best match depends on the source and transformation.

Does Google Sheets QUERY work like Power Query?
No. QUERY can select, filter, group, and sort data in a range using its own query syntax. It does not provide Power Query’s full source-connection and step-based transformation environment.

Can Google Sheets refresh imported data automatically?
Some imports and connected data can update, but refresh behavior varies by feature and source. Do not assume an import function gives a guaranteed refresh time or that every web source will remain accessible. Check the behavior for your specific source and workflow.

Can I open an Excel file with Power Query in Sheets?
You can upload or convert an Excel workbook, but Google Sheets does not execute Excel Power Query queries. If those queries are important, keep the workbook in Excel and verify the data and features after any conversion.

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.