Google Sheets QUERY builder

Pick your columns and conditions; get the formula. QUERY's syntax is unmemorable rather than hard — the clause order is fixed, the column references change depending on where your data came from, and every value type quotes differently. This gets all three right.

Your data Range

The range holding your data, including the header row.

Column headings (optional)

Paste your header row and the pickers below use your own names.

Header rows

Usually 1. Leave blank to let QUERY guess — it guesses badly on mixed columns.

Column references

Show these columns

A B C D

Tick none to select every column.

Keep only rows where…

Dates must be yyyy-mm-dd. Choosing “a cell” concatenates the reference correctly — that one trips up nearly everybody.

Summarise (optional)

Group by

A B C D

Summarising needs a group — one row per value of whatever you tick.

Sort and limit (optional)

Limit Skip

Fill in the range and hit Build.

You'll get a formula like this, plus a plain-English reading of it and a warning for each thing that usually goes wrong:

=QUERY(A1:E200,
  "select A, B, D where D > 1000", 1)

Nothing is sent anywhere — the formula is composed in your browser.

More on QUERY

The QUERY reference page has a worked example captured from a real sheet, plus the gotchas that cause most of the trouble.