Google Sheets QUERY Function: What It Is and How to Use It
QUERY function in Google Sheets lets you filter, sort, and manipulate data using a simple query language similar to SQL. It helps you extract specific information from a range of cells by writing easy-to-understand commands inside the function.How It Works
The QUERY function works like a smart filter for your spreadsheet data. Imagine you have a big table of information, like a list of sales or contacts, and you want to see only certain rows or columns that meet your needs. Instead of manually sorting or filtering, you write a query that tells Google Sheets exactly what to show.
It uses a language similar to SQL, which is a way to ask questions about data. For example, you can ask for all rows where sales are above a certain number, or only show the names and dates from your table. The function then returns a new table with just the data you asked for.
This makes it easy to analyze and organize data without changing the original table. You just write your query once, and it updates automatically if your data changes.
Example
This example shows how to use QUERY to get all rows where the sales amount is greater than 1000 from a table with columns Date, Product, and Sales.
=QUERY(A1:C6, "SELECT A, B, C WHERE C > 1000", 1)
When to Use
Use the QUERY function when you want to quickly filter, sort, or summarize data without manually changing your spreadsheet. It's perfect for reports, dashboards, or anytime you need to extract specific information from large tables.
For example, you can use it to:
- Show only sales above a certain amount
- List customers from a specific city
- Sort data by date or name
- Calculate sums or averages with conditions
Key Points
- QUERY uses a simple SQL-like language to filter and sort data.
- It returns a new table without changing your original data.
- You can select specific columns and apply conditions easily.
- It updates automatically when your source data changes.