Workflow router
Spreadsheet Formula Tools by Workflow
Choose spreadsheet tools by task: formula builders, lookup formulas, QUERY/FILTER reports, CSV cleanup, date converters, column tools, and templates.
Formula workflow
Use these when you need a copyable formula for totals, counts, dates, or duplicate checks.
Formula pages library
Open copyable Excel and Google Sheets formulas with sample data, expected results, and troubleshooting notes.
SUMIFS Formula Builder
Total rows by region, product, status, or month.
COUNTIFS Formula Builder
Count matching rows with one or more criteria.
SUMIFS vs COUNTIFS Guide
Decide whether your report needs a total amount or a row count.
Date Difference Formula Builder
Return days, completed months, or completed years between two dates.
Duplicate Checker Formula Builder
=IF(A2="", "", IF(COUNTIF($A$2:$A$100, A2)>1, "Duplicate", ""))Lookup workflow
Use these when you need to return a value from a row that matches an ID, SKU, name, or multiple criteria.
XLOOKUP Formula Builder
Modern lookup formulas with not-found handling and multiple-criteria mode.
VLOOKUP Formula Builder
Compatibility-friendly lookup formulas when the lookup column is first.
INDEX MATCH Formula Builder
Flexible exact-match lookups when return columns can be left or right.
XLOOKUP multiple criteria example
=XLOOKUP(1, (A2:A100=H2)*(B2:B100=H3), D2:D100, "Not found")CSV cleanup workflow
Use these when imported data needs cleaner headers, duplicate checks, unique counts, or text extraction.
CSV Column Cleaner
Customer Name,Invoice # -> customer_name,invoice
Duplicate Checker Formula Builder
Flag repeated IDs, emails, SKUs, or names after import.
Count Unique Formula Builder
=IFERROR(COUNTUNIQUE(FILTER(B2:B100, B2:B100<>"")), 0)REGEXEXTRACT Formula Builder
Extract domains, email domains, first numbers, or text in parentheses.
Reporting workflow
Use these when you need filtered rows, monthly summaries, category totals, or spreadsheet report formulas.
Google Sheets QUERY Builder
=QUERY(A1:D100, "SELECT A, B, D WHERE A >= date '2026-01-01'", 1)QUERY GROUP BY and SUM
=QUERY(A1:C9, "SELECT A, SUM(C) GROUP BY A ORDER BY SUM(C) DESC", 1)FILTER Formula Builder
=IFERROR(FILTER(A2:D100, B2:B100="East"), "No matches")QUERY vs FILTER Guide
Use QUERY for SELECT/ORDER BY reports and FILTER for direct matching rows.
SUMIFS by Month example
Use >= month start and < next month to avoid date-boundary errors.
Budget Tracker Template
Start a transaction table, then add category and monthly summary formulas.
Date and column workflow
Use these for date math, Excel serial dates, and column label conversions.
Date Difference Formula Builder
=B2-A2Excel Date Serial Converter
Excel serial 46023 -> 2026-01-01
Excel Column Letter Converter
27 -> AA and AA -> 27
QUERY date range example
Use Google Sheets QUERY date literals: date 'YYYY-MM-DD'.
Template workflow
Use these when you want a lightweight CSV starter instead of building a blank sheet from scratch.
Inventory Tracker Template
Track stock, reorder levels, suppliers, and inventory value formulas.
Budget Tracker Template
Track income and expenses before adding category or month summaries.
Content Calendar Template
Plan channel, status, owner, keyword, and publishing dates.
Templates index
Compare the free CSV templates before downloading.
SUMIFS Formula Builder
Build a SUMIFS formula with one or two criteria, optional month matching, and copy the Excel or Google Sheets result.
XLOOKUP Formula Builder
Build XLOOKUP formulas for Excel and Google Sheets with exact match, multiple criteria, not-found handling, left lookup examples, and #N/A fixes.
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.
Duplicate Checker Formula Builder
Build Excel and Google Sheets duplicate checker formulas with COUNTIF, blank-row protection, all-duplicate or after-first modes, sample flags, and cleanup tips.
CSV Column Cleaner
Clean CSV header names into lowercase spreadsheet-friendly column names locally in the browser, with previewed output and no uploads.
Date Difference Formula Builder
Build Excel and Google Sheets formulas to calculate days, completed months, or completed years between two dates.
Inventory Tracker Spreadsheet Template
Download a free inventory tracker CSV template for Excel or Google Sheets with reorder levels and supplier fields.