🟩 Google Sheets examples
Google Sheets formulas and workflow examples.
Browse 77 practical Google Sheets pages for formulas, QUERY, imports, regex, dashboards, trackers and common spreadsheet workflows. Each page includes copy-ready formulas, five examples, common mistakes and related links.
Browse Google Sheets examples
Use the search and filters to find formulas, imports, regex patterns, dashboards, trackers and workflows. Results appear immediately below the filters.
Xlookup Examples
Search a lookup range and return a matching value from another range.
🔎 LookupVlookup Examples
Search the first column of a range and return a value from another column.
🔎 LookupHlookup Examples
Search the first row of a range and return a value from another row.
🔎 LookupIndex Match Examples
Combine INDEX and MATCH for flexible row and column lookups.
🔎 LookupMatch Examples
Return the position of a value inside a row or column.
🔎 LookupChoose Examples
Return one value or range from a list based on a position number.
🔎 LookupOffset Examples
Return a range that is a number of rows and columns away from a starting cell.
🔎 LookupLookup From Another Sheet Examples
Build lookups that return values from another tab in the workbook.
✅ LogicalIf Examples
Return one result when a condition is true and another result when it is false.
✅ LogicalIfs Examples
Test multiple conditions in order without deeply nested IF formulas.
✅ LogicalAnd and or Examples
Combine multiple logical tests inside IF, FILTER, or conditional rules.
✅ LogicalSwitch Examples
Return different outputs based on one expression or status value.
✅ LogicalIferror Examples
Return a cleaner fallback value when a formula returns an error.
✅ LogicalIsblank Examples
Check whether a cell is blank before calculating or labeling it.
✅ LogicalConditional Labels Examples
Create practical status labels such as late, due soon, complete, or over budget.
➕ SummarySumif Examples
Add values that match one condition.
➕ SummarySumifs Examples
Add values that match multiple conditions.
➕ SummaryCountif Examples
Count cells that match one condition.
➕ SummaryCountifs Examples
Count rows that match multiple conditions.
➕ SummaryAverageif Examples
Average values that match one condition.
➕ SummaryAverageifs Examples
Average values that match multiple conditions.
➕ SummarySumproduct Examples
Multiply arrays and add the results for weighted totals or conditional logic.
➕ SummarySubtotal Examples
Calculate totals that can ignore hidden or filtered rows.
➕ SummaryRunning Total Examples
Create cumulative totals for sales, budgets, tasks, or inventory.
🔤 TextLeft Right Mid Examples
Extract text from the start, end, or middle of a value.
🔤 TextLen Examples
Count characters in a text value.
🔤 TextTrim and Clean Examples
Remove extra spaces and non-printing characters from messy imported data.
🔤 TextSubstitute Examples
Replace specific text inside a cell.
🔤 TextTextjoin Examples
Join values with a delimiter while optionally ignoring blanks.
🔤 TextSplit Examples
Split text into columns using a delimiter.
🔤 TextConcatenate Examples
Combine text values into one string.
🔤 TextValue Examples
Convert text that looks like a number into a numeric value.
🔤 TextText Cleanup Workflow Examples
Clean names, codes, imported CSV values, and inconsistent text fields.
📅 Date & TimeToday and Now Examples
Return the current date or current date and time.
📅 Date & TimeDate Examples
Build valid dates from year, month, and day values.
📅 Date & TimeEomonth Examples
Return the last day of a month offset from a start date.
📅 Date & TimeEdate Examples
Move a date forward or backward by a number of months.
📅 Date & TimeWorkday Examples
Return a date after a number of working days.
📅 Date & TimeNetworkdays Examples
Count working days between two dates.
📅 Date & TimeDatedif Examples
Calculate the difference between two dates in days, months, or years.
📅 Date & TimeWeeknum Examples
Return the week number of a date.
📅 Date & TimeTime Duration Examples
Calculate hours, minutes, and durations between two times.
🧮 Array FormulasArrayformula Examples
Apply one formula to a whole column or range.
🧮 Array FormulasFilter Examples
Return rows from a range that match one or more conditions.
🧮 Array FormulasSort Examples
Sort a range by one or more columns.
🧮 Array FormulasUnique Examples
Return unique rows or values from a range.
🧮 Array FormulasSequence Examples
Generate a sequence of numbers, dates, or row numbers.
🧮 Array FormulasTranspose Examples
Switch rows into columns or columns into rows.
🧮 Array FormulasFlatten Examples
Combine values from multiple ranges into one column.
🧮 Array FormulasWraprows Examples
Wrap a single row or column into a set number of columns.
🗂️ QUERYQuery Select Examples
Use QUERY to select specific columns from a range.
🗂️ QUERYQuery Where Examples
Use QUERY to filter rows with WHERE conditions.
🗂️ QUERYQuery Group By Examples
Use QUERY to summarize values by category, month, or owner.
🗂️ QUERYQuery Pivot Examples
Use QUERY to build a pivot-style summary table.
🗂️ QUERYQuery Order By and Limit Examples
Sort and limit QUERY results for top lists and reports.
🗂️ QUERYQuery Label and Format Examples
Rename and format QUERY result columns.
🔗 ImportImportrange Examples
Import data from another Google Sheets file.
🔗 ImportImporthtml Examples
Import a table or list from a web page.
🔗 ImportImportxml Examples
Import structured data from web pages using XPath.
🔗 ImportImportdata Examples
Import data from a CSV or TSV URL.
🔗 ImportGooglefinance Examples
Pull financial market data into a spreadsheet.
🔗 ImportImportfeed Examples
Import RSS or Atom feed data into a sheet.
🔍 RegexRegexmatch Examples
Check whether text matches a regular expression pattern.
🔍 RegexRegexextract Examples
Extract matching parts of text with a regular expression.
🔍 RegexRegexreplace Examples
Replace text that matches a regular expression.
🔍 RegexExtract Email and Phone Examples
Extract emails, phone numbers, or IDs from messy text.
🔍 RegexValidate Text Pattern Examples
Validate IDs, emails, SKUs, and codes before using them in reports.
📊 Dashboards & TrackersSparkline Examples
Create tiny trend charts inside cells.
📊 Dashboards & TrackersDropdown Workflow Examples
Use dropdowns for status tracking, categories, and data entry controls.
📊 Dashboards & TrackersCheckbox Workflow Examples
Use checkboxes to build task lists, attendance trackers, and approval workflows.
📊 Dashboards & TrackersConditional Formatting Workflow Examples
Highlight overdue tasks, high values, duplicates, and status changes.
📊 Dashboards & TrackersDashboard Examples
Build simple summary dashboards with formulas, filters, and charts.
📊 Dashboards & TrackersBudget Tracker Examples
Track planned vs actual spending by category and month.
📊 Dashboards & TrackersAttendance Tracker Examples
Count attendance, absences, and completion rates.
📊 Dashboards & TrackersContent Calendar Examples
Plan posts, deadlines, owners, topics, and publishing status.
📊 Dashboards & TrackersProject Tracker Examples
Track tasks, owners, due dates, status, and overdue items.
📊 Dashboards & TrackersCombine Tabs Workflow Examples
Stack multiple sheets or monthly tabs into one reporting table.
Here are some ideas for you
Optional resources that may help if you are learning Google Sheets, building trackers, creating dashboards or improving spreadsheet workflows.
- Google Sheets booksSee ideas
Learn formulas, workflows and dashboards with structured examples.
- Spreadsheet dashboard booksSee ideas
Improve how you design trackers, summaries and reporting sheets.
- Keyboard shortcut guidesSee ideas
Build speed with navigation, editing and formatting shortcuts.
- Numeric keypadsSee ideas
Useful if you enter numbers often on a laptop or compact keyboard.
- External monitorsSee ideas
Helpful for viewing data, formulas and dashboards side by side.
- Desk notebooksSee ideas
Sketch formulas, tracker layouts and reporting ideas before building.
Some links in this section may be affiliate links. Choose only what is useful for your own work.