Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
Fix the QUERY error error
Excel & Google SheetsWhat QUERY error means
The QUERY function in Google Sheets accepts a SQL-like string (based on Google's Visualization API query language). A parse error means Sheets could not interpret that string — a keyword is misspelled, column labels are used instead of Col1/Col2 references, or string literals are not delimited correctly. The error message usually specifies the position in the query string where parsing failed.
Common causes
- Using column header names (e.g., SELECT Revenue) instead of positional references (SELECT Col3) when headers=1 is set — column names are only valid with named-column syntax in specific Sheets versions.
- String values in WHERE clauses are wrapped in double quotes instead of single quotes: WHERE Col2 = "East" should be WHERE Col2 = 'East'.
- A date literal is not in the correct format: dates in QUERY must be formatted as date '2024-01-15' (with the keyword date).
- The QUERY data range and the headers argument are mismatched — a headers=1 with a range that starts at row 1 causes column label confusion.
- The query string contains a line break or leading/trailing whitespace that breaks tokenization.
Example fix
Broken
=QUERY(A1:D100,"SELECT A WHERE B = \"East\"",1)Fixed
=QUERY(A1:D100,"SELECT Col1 WHERE Col2 = 'East'",1)Changed column letters to positional Col references and replaced double-quoted string literal with single quotes, which is the required syntax inside a QUERY string.
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How to fix it
- 1Use positional column references: Col1, Col2, Col3 match the first, second, third column of the data range regardless of header names.
- 2Wrap text literals in single quotes inside the query string: "SELECT Col1 WHERE Col2 = 'East'".
- 3Format date literals correctly: "SELECT Col1 WHERE Col3 > date '2024-01-01'".
- 4Set headers correctly: if your range starts with a header row, use 1 as the third argument — =QUERY(A1:D100,"SELECT A,B",1).
- 5Build the query string in a cell and reference it with & to debug: =QUERY(A1:D100,"SELECT Col1 WHERE Col2 = '"&E1&"'",1).
Stop hunting errors by hand.
Upload your spreadsheet and the Auditor flags every QUERY error and broken formula at once — or paste this one formula and get the fix explained.
Frequently asked
Can I reference column header names directly in QUERY instead of Col1, Col2?
In most cases no — use positional Col references. Header names work only in specific circumstances and are fragile. Positional references (Col1, Col2) are always reliable.
How do I filter by a cell value in QUERY without hardcoding the text?
Concatenate the cell reference into the query string: =QUERY(A1:D100,"SELECT Col1 WHERE Col2 = '"&B1&"'",1). Be careful with single quotes around the injected value.
What does 'NO_COLUMN: A' mean in a QUERY parse error?
It means QUERY cannot find column A in the data range when you use a column letter reference. Switch to Col1, Col2 notation — or if using headers=1, confirm the header row is included in the range.
More on QUERY (Google Sheets SQL)
See all →How-to
How to use QUERY to filter data
Use Google Sheets QUERY with a WHERE clause to filter rows dynamically — Excel users can use FILTER as the equivalent.
How-toHow to use QUERY to sum by group
Use Google Sheets QUERY with GROUP BY and SUM to aggregate data by category — use SUMIF for the Excel equivalent.
How-toHow to use QUERY to group by multiple columns
Use QUERY GROUP BY with multiple columns in Google Sheets to create multi-level summaries. Excel alternative uses SUMIFS with multiple criteria ranges.
How-toHow to use QUERY with WHERE, AND, OR
Filter QUERY results in Google Sheets using WHERE with AND and OR conditions. Excel users can replicate this with FILTER using * for AND and + for OR.
How-toHow to create a running total with QUERY
Build a running total in Google Sheets by combining QUERY for ordering with ARRAYFORMULA and SUMIF. Excel alternative uses a simple SUMIF with a locked anchor row.
How-toHow to combine QUERY with IMPORTRANGE
Combine QUERY and IMPORTRANGE in Google Sheets to filter and aggregate data from another spreadsheet file. There is no Excel equivalent — use Power Query to connect workbooks instead.