Workflow router
Spreadsheet Tools by Workflow
Choose spreadsheet tools by task: formulas, lookups, CSV cleanup, reporting, dates, columns, and templates.
Formula workflow
Use these when you need a copyable formula for totals, counts, dates, or duplicate checks.
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) 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-A2 Excel 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.
Open workflow itemXLOOKUP Formula Builder
Build a single-criterion or multiple-criteria XLOOKUP formula with not-found handling and match mode options.
Open workflow itemGoogle Sheets Query Builder
Free online Google Sheets QUERY builder. Build SELECT, WHERE, ORDER BY, and date-filter formulas in your browser, copy working examples, and fix syntax errors — no download, upload, or sign-in.
Open workflow itemGoogle Sheets FILTER Formula Builder
Free Google Sheets FILTER formula builder: add one or more conditions with AND/OR logic, date filters, text contains, and blank checks, then copy a working FILTER formula — no upload or sign-in.
Open workflow itemDuplicate Checker Formula Builder
Build a COUNTIF-based duplicate checker formula with blank-row protection for Excel or Google Sheets.
Open workflow itemCSV Column Cleaner
Clean CSV header names into simple lowercase spreadsheet-friendly column names locally in the browser.
Open workflow itemDate Difference Formula Builder
Build Excel and Google Sheets formulas to calculate days, completed months, or completed years between two dates.
Open workflow itemInventory Tracker Spreadsheet Template
Download a free inventory tracker CSV template for Excel or Google Sheets with reorder levels and supplier fields.
Open workflow item