Tool category
Google Sheets Formula Builders and Examples
Build Google Sheets formulas for QUERY, FILTER, REGEXEXTRACT, COUNTUNIQUE, date filters, cross-sheet queries, text cleanup, and reusable reporting workflows.
Quick Google Sheets formulas and builders
Copy a working starting pattern, then open the matching builder or example when you need date criteria, another-sheet references, text extraction, or row filtering.
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 GROUP BY and SUM
=QUERY(A1:C9, "SELECT A, SUM(C) GROUP BY A ORDER BY SUM(C) DESC", 1)QUERY formula builder
Build single-date or between-date QUERY formulas with selected columns and ORDER BY.
QUERY another sheet
=QUERY('Sheet 2'!A1:D100, "SELECT A, B, D WHERE C > 100", 1)FILTER function examples
=FILTER(A2:D100, B2:B100="Paid")FILTER formula builder
Build row output with AND, OR, date, text, and blank conditions.
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")REGEXEXTRACT builder
=REGEXEXTRACT(A2, "^(?:https?:\/\/)?(?:www\.)?([^\/\?#]+)")COUNTUNIQUE builder
=IFERROR(COUNTUNIQUE(FILTER(B2:B100, B2:B100<>"")), 0)Split text into columns
=SPLIT(A2, "-")Choose the right Google Sheets workflow
Use this chooser when you know the spreadsheet problem but not the formula family.
Use QUERY for report-shaped output
Choose QUERY when you need SELECT columns, WHERE conditions, ORDER BY, date ranges, or a compact report table from a larger range.
Use FILTER for matching rows
Choose FILTER when you want all rows that match one or more conditions and the output should keep the original column order.
Use another-tab references for the same file
Use 'Raw Data'!A1:D100 for another tab in the same spreadsheet. Use IMPORTRANGE only when the source is a different spreadsheet file.
Use REGEXEXTRACT for structured text
Use REGEXEXTRACT for domains, IDs, codes, and other text patterns where a simple split is not specific enough.
Use COUNTUNIQUE for distinct values
Use COUNTUNIQUE with a blank guard when the result should be one number, such as unique customers, categories, emails, or owners.
Use formula examples for Excel-compatible patterns
Open the formula collection when the same workbook may be used in both Excel and Google Sheets.
Google Sheets Query Builder
Build Google Sheets QUERY formulas for selected columns, WHERE rules, ORDER BY, and date filters in your browser.
Google Sheets FILTER Formula Builder
Build Google Sheets FILTER formulas with AND/OR conditions, text contains, dates, blank checks, and optional sorting. Copy the result without uploading a sheet.
REGEXEXTRACT Formula Builder
Build a Google Sheets REGEXEXTRACT formula for domains, email domains, first numbers, text in parentheses, or custom patterns.
Count Unique Formula Builder
Build COUNTUNIQUE and UNIQUE formulas that count distinct values while ignoring blanks and returning 0 for empty ranges.
Google 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.
Google 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.