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

=QUERY(A1:D100, "SELECT A, B, D WHERE A >= date '2026-01-01'", 1)

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)

FILTER Formula Builder

Build Excel dynamic array and Google Sheets FILTER formulas with one or two conditions.

Google SheetsBuilder

REGEXEXTRACT Formula Builder

Build a Google Sheets REGEXEXTRACT formula for domains, email domains, first numbers, text in parentheses, or custom patterns.

Google SheetsBuilder

Count Unique Formula Builder

Build COUNTUNIQUE and UNIQUE formulas that count distinct values while ignoring blanks and returning 0 for empty ranges.

Google SheetsBuilder