Querying Data With QUERY

Google Sheets has one function that feels like a tiny database language: QUERY. It lets you select, filter, and summarize data using a syntax very close to SQL.

Instead of stacking FILTER, SORT, and SUMIF together, you write one readable instruction. For example, show me only the East region rows, sorted by sales becomes a single formula.

QUERY is unique to Google Sheets. Excel does not have it, so this whole lesson is Sheets-only.

QUERY takes three parts:

• data the range to read, like A1:D100
• query a text string of instructions, in quotes
• headers an optional number telling QUERY how many header rows there are

The query string is where the magic lives. It always goes inside double quotes.

The SELECT clause chooses which columns to return. Inside QUERY you refer to columns by their sheet letters (A, B, C), not by header names.

Use SELECT * to return every column, or list specific ones to keep only what you need. The order you list them in is the order they appear in the result.

Imagine a sales sheet in A1:D7 with headers Region, Rep, Product, Sales:

• A: Region (East, West)
• B: Rep (Ann, Bo, Cy)
• C: Product (Pens, Paper)
• D: Sales (numbers)

We will use this dataset for the rest of the lesson. Picture it whenever you see a QUERY formula below.

The WHERE clause keeps only rows that pass a test. Compare a column to a value using operators like =, >, <, and >=.

Text values go in single quotes inside the query string, because the whole query is already wrapped in double quotes.

Number filters do not need quotes. To see only the high-value sales, compare column D directly to a number.

This returns just the rows where Sales is greater than 500, keeping your report focused on the important deals.

Use AND and OR to combine tests, just like in SQL.

• AND requires both conditions to be true
• OR needs at least one to be true

This example keeps East-region rows that also broke 300 in sales.

Add LIMIT to cap how many rows come back. This is handy for top-N previews or for keeping a dashboard tidy.

Here we ask for the first 3 matching rows only. Combine it with sorting later to build a real top-3 list.

This trips up everyone at first. The entire query is one Sheets text string, so it uses double quotes. Any text you compare against must therefore use single quotes inside it.

Writing WHERE A = "East" breaks the formula because the inner double quote ends the string early. Always use WHERE A = 'East'.

You can make a query interactive by pulling a value from a cell. Because the cell value lives outside the quotes, you concatenate it with the & operator.

If cell F1 holds a region name, this formula filters by whatever the user typed there.

The third argument tells QUERY how many header rows your data has. Pass 1 when the first row holds labels like Region and Sales.

If you omit it, QUERY guesses, and it sometimes guesses wrong, mixing a header into your results or treating numbers as text. Stating 1 explicitly keeps results predictable.

Test your understanding of QUERY basics.

You learned the heart of Google Sheets QUERY:

• QUERY(data, query, headers) is the structure
• SELECT picks columns by letter; * means all
• WHERE filters rows, combined with AND and OR
• Text uses single quotes; numbers use none
• & injects cell values for interactive filters

Next you will sort and group those results into summaries.