Formula guide · Google Sheets · Updated May 13, 2026
Google Sheets QUERY Parse Error
Fix QUERY parse errors caused by quotes, dates, column names, or invalid clause order.
Quick Answer
A QUERY parse error usually means the query string has broken quotes, a wrong column reference, or clauses in the wrong order.
Copyable Formula
=QUERY(A1:D100,"select A, D where C = 'Paid' order by D desc",1)Syntax
=QUERY(A1:D100,"select A, D where C = 'Paid'",1)Google Sheets
Worked Example
| Cause | Fix |
|---|---|
| Broken quotes | Use single quotes inside the query |
| Wrong column | Use range-relative column letters |
| Bad date | Use date 'yyyy-mm-dd' |
Result: A valid query string returns the filtered rows instead of a parse error.
Steps
- Check every quote inside the query string.
- Confirm selected columns exist inside the selected range.
- Put clauses in the right order: select, where, group by, order by, label.
- Use date literals for date comparisons.
Common Mistakes
- Using worksheet column letters that are outside the selected range.
- Typing double quotes inside the query string without escaping them.
- Using local date formats inside QUERY.
Excel vs Google Sheets Notes
This page is focused on Google Sheets. Excel may require a different function, pivot table, or Power Query workflow.
Editorial check: This guide was last updated May 13, 2026. Formula behavior can vary by Excel version, Google Sheets rollout, and spreadsheet locale.