Search for data in a sheet with QUERY

Finding specific content in large spreadsheets can be tricky. Filter, sort, sum, and verify values in your data with the QUERY function in Google Sheets.

Use the QUERY function

In Sheets, open a spreadsheet. In an empty cell, type =QUERY. In parenthesis, add the following specifications separated by a comma: Cell range, separated by a colon, to perform the query on. Specific query to perform (using Google Visualization API Query Language). (Optional) Type a digit for the number of header rows at the top of the data. Press Enter. Related topics QUERY Use BigQuery data