Open links in new tab
  1. Google Support
    https://support.google.com › docs › answer

    QUERY function - Google Docs Editors Help

    Google Sheets - QUERY from Another Sheet, IMPORTRANGE, Use Multiple Tabs, Subquery Examples Tutorial
    24:51
    Google Sheets - QUERY from Another Sheet, IMPORTRANGE, Use Multiple Tabs, Subquery Examples Tutorial
    YouTubeLearn Google Sheets & Excel Spreadsheets469.3K viewsMar 30, 2018
    What is a query_string in Google Sheets?
    A query_string in Google Sheets contains nothing but a query, similar to a SQL query. It consists of one or more clauses and can include optional aggregate functions and/or arithmetic operations. A clause filters the given data.
    spreadsheetpoint.com
    Google Sheets QUERY Guide: 10 Easy Examples - Spreadsheet Point
    Spreadsheet Point
    Overview

    Runs a Google Visualization API Query Language query across data.
    Sample Usage
    QUERY(A2:E6,"select avg(A) pivot B")

    Google Support
    Google Sheets QUERY Function: Complete Guide with Examples
    GeeksForGeeks
    Examples

    Note: Each example is in its own tab. Sample data
    Select & where
    Returns rows that match the specified condition using Select and Where clauses.

    Google Support
  1. 123

    1. Open your Google Sheets document.

    2. Select the cell where you want the query results to appear.

    3. Enter the QUERY formula in the format: =QUERY(data, query, [headers]) data: Specify the range of cells containing your data (e.g., A1:D10). query: Write your query in SQL-like syntax (e.g., "SELECT A, B WHERE C > 10"). headers: Optionally specify the number of header rows (use 1 if your data has a single header row).

    4. Press Enter to execute the query.

    Example Queries:

    • To select specific columns: =QUERY(A1:D10, "SELECT A, C", 1)

    • To filter rows: =QUERY(A1:D10, "SELECT A, B WHERE C > 50", 1)

    • To sort data: =QUERY(A1:D10, "SELECT A, B ORDER BY C DESC", 1)

    • To group and aggregate data: =QUERY(A1:D10, "SELECT A, SUM(C) GROUP BY A", 1)

    Learn more:
    1 -support.google.com2 -spreadsheetpoint.com3 -howtogeek.com
    Feedback
  2. Spreadsheet Point
    https://spreadsheetpoint.com › formulas › google-sheet…

    Google Sheets QUERY Guide: 10 Easy Examples

    3 days ago · Learn how to use the QUERY function in Google Sheets to apply SQL-style queries to a data table. See 10 easy examples of filtering, extracting, …

  3. People also ask
    Feedback
  4. GeeksForGeeks
    https://www.geeksforgeeks.org › google-sheets › google-s…

    Google Sheets QUERY Function: Complete Guide with …

    Oct 10, 2025 · The QUERY function in Google Sheets is a powerful tool that allows you to filter, sort, and analyze large datasets with ease. It uses SQL-like syntax to …

  5. Ben Collins
    https://www.benlcollins.com › spreadsheets › google-sheets-query-sql

    Google Sheets Query function: The Most Powerful Function in Google …

      1. If you want to follow along and have the same data and see all of the formula …
      2. Ensure you have the whole table selected (Pro-tip: click somewhere in your table and …
      3. Go to the menu: Data > Named ranges… and click this menu. A new pane will show in …
      4. In the first input box, enter the word “countries”, as shown in the image below. This …
      5. In Google sheets we use the Google Sheets QUERY function and write our pseudo …
      See full list on benlcollins.com
  6. Rows
    https://rows.com › blog › post › google-sheets-query-function

    How to use the Google Sheets QUERY function [2025] - Rows

    Jul 15, 2024 · In this article, you'll learn all you need to know about using the QUERY function in Google Sheets. You'll also learn what the QUERY function is, examples of QUERY commands, and much more. …

  7. Statology
    https://www.statology.org › how-to-use-the-query-function …

    How to Use the QUERY Function in Google Sheets …

    Aug 18, 2024 · What is the QUERY Function? The QUERY function in Google Sheets enables you to run SQL-like queries on your dataset. It allows you to filter, sort, …

  8. Sheets Help
    https://sheetshelp.com › query

    QUERY Function - Google Sheets - Sheets Help

    Nov 9, 2021 · Go to this spreadsheet for examples of the QUERY function shown above that you can study and use anywhere you would like. query – The query …

  9. ProG-Cafe
    https://programming-cafe.com › en › google-workspace-e…

    QUERY Function: Query Syntax and Examples in Google …

    Dec 20, 2024 · The QUERY function in Google Sheets is a powerful tool for filtering, sorting, and aggregating data flexibly within a spreadsheet. This article provides …

  10. Sheets-Pratique.com
    https://sheets-pratique.com › en › query

    Google Sheets: QUERY Function

    Complete course on the use and possibilities offered by the QUERY function in Google Sheets, which allows you to run queries similar to SQL.

  11. Coupler.io Blog
    https://blog.coupler.io › google-sheets-query-function

    Google Sheets QUERY Function Tutorial 2025

    Feb 23, 2025 · Learn how to use the QUERY function in Google Sheets to retrieve and manipulate data from various sources. Find examples of SELECT, WHERE, …