Google Sheets Formula Library
Browse ready-to-use formula templates for Excel, Google Sheets, SQL, and regex. Each formula includes a step-by-step breakdown, edge-case warnings, and real-world examples.
AI-generated Google Sheets formulas with validation. QUERY, ARRAYFORMULA, FILTER, IMPORTRANGE and more.
QUERY Function Basics
QUERY brings SQL-like power to Google Sheets. Filter, sort, group, and aggregate data with a single formula.
ARRAYFORMULA Basics
Write the formula once in the header row. It automatically applies to every row below. No dragging, no copying.
IMPORTRANGE With QUERY
Pull specific data from another Google Sheets file and filter it — all in one formula. The most powerful cross-sheet technique.
FILTER Function in Google Sheets
FILTER returns rows from a range that meet your conditions. Simpler than QUERY for straightforward filtering.
GOOGLEFINANCE Function
Pull real-time stock prices, historical data, and financial metrics directly into your spreadsheet. Build portfolio trackers and watchlists.
Can't find what you need?
Describe any formula in plain English and Formula Genius will generate it, explain it, and validate it — instantly.