Tool category
Google Sheets Formula Builders
Google Sheets formula builders for QUERY, FILTER, REGEXEXTRACT, and related spreadsheet workflows.
Quick Google Sheets formulas
Copy a starting pattern or choose the matching builder.
QUERY date filter formulas
=QUERY(A1:D, "select * where A >= date '2026-01-01' and A <= date '2026-01-31'", 1) QUERY date range example
=QUERY(A1:D100, "SELECT A, B, D WHERE A >= date '2026-01-01' AND A < date '2026-02-01'", 1) QUERY formula builder
Build single-date or between-date QUERY formulas with selected columns and ORDER BY.
FILTER function examples
=FILTER(A2:D100, B2:B100="Paid") QUERY vs FILTER guide
Choose QUERY for report-shaped output or FILTER for simple row filtering.
FILTER rows by date
=IFERROR(FILTER(A2:D100, A2:A100>=F1), "No matches") FILTER with fallback
=IFERROR(FILTER(A2:D100, B2:B100="East"), "No matches") Extract URL domain
=REGEXEXTRACT(A2, "^(?:https?:\/\/)?(?:www\.)?([^\/\?#]+)") Count unique nonblank values
=IFERROR(COUNTUNIQUE(FILTER(B2:B100, B2:B100<>"")), 0) Google Sheets Query Builder
Free online Google Sheets QUERY builder. Build SELECT, WHERE, ORDER BY, and date-filter formulas in your browser, copy working examples, and fix syntax errors — no download, upload, or sign-in.
Open toolGoogle Sheets FILTER Formula Builder
Free Google Sheets FILTER formula builder: add one or more conditions with AND/OR logic, date filters, text contains, and blank checks, then copy a working FILTER formula — no upload or sign-in.
Open toolREGEXEXTRACT Formula Builder
Build a Google Sheets REGEXEXTRACT formula for domains, email domains, first numbers, text in parentheses, or custom patterns.
Open toolCount Unique Formula Builder
Build COUNTUNIQUE and UNIQUE formulas that count distinct values while ignoring blanks and returning 0 for empty ranges.
Open toolGoogle Sheets QUERY Date Filter Formulas
Fix Google Sheets QUERY date syntax with copy-paste formulas for one date, date ranges, date cells, TODAY, DATETIME values, current month, and FORMAT clauses.
Open toolGoogle Sheets FILTER Function Examples
Copy Google Sheets FILTER formulas for AND, OR, dates, blanks, multi-column filters, SORT, Top N, and #N/A/#REF fixes.
Open tool