Working with remote and in-office colleagues? Learn how to thrive in hybrid work environments.

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""

  1. In Sheets, open a spreadsheet.
  2. In an empty cell, type =QUERY.
  3. 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.
  4. Press Enter.

Related topics

Was this helpful?
How can we improve it?
Clear search
Close search
Google apps
Main menu
Search Help Center