Formula hub · Updated May 13, 2026

Google Sheets QUERY

Use Google Sheets QUERY clauses for select, where, group by, order by, labels, and pivots.

Guides in this category

How to Use QUERY in Google Sheets

Use QUERY to select, filter, group, sort, and label data with a SQL-like formula in Google Sheets.

QUERY Select Where Examples

Filter rows and choose columns in Google Sheets with QUERY select and where clauses.

QUERY Group By in Google Sheets

Group rows and summarize values in Google Sheets with QUERY group by.

Google Sheets QUERY Multiple Conditions

Use QUERY with multiple where conditions in Google Sheets using and, or, dates, and text matches.

Google Sheets QUERY Date Range

Filter Google Sheets rows by date range with QUERY and the date keyword.

IMPORTRANGE Not Working in Google Sheets

Fix IMPORTRANGE errors caused by permissions, wrong URLs, bad range names, or delayed loading.

Google Sheets QUERY Parse Error

Fix QUERY parse errors caused by quotes, dates, column names, or invalid clause order.

Google Sheets QUERY Order By

Sort QUERY results in Google Sheets with order by ascending or descending.

Google Sheets QUERY Label

Rename QUERY output columns in Google Sheets with the label clause.

QUERY with IMPORTRANGE

Combine QUERY and IMPORTRANGE to filter imported Google Sheets data.

Google Sheets QUERY Limit

Limit the number of rows returned by a Google Sheets QUERY formula.

Google Sheets QUERY Contains

Filter rows in Google Sheets QUERY when a text column contains a word or phrase.

How to choose a formula

Start from the spreadsheet task, then choose the simplest formula that gives a maintainable answer. A report that someone else must update next month often needs clarity more than cleverness.